SOQL (Salesforce object query language) and DML (Data manipulation language) are the languages used in Salesforce to read and modify records, respectively. In this blog post, we’ll explore how to use them in Apex, including best practices to prevent hitting governor limits. This will be particularly helpful to developers who are new to Salesforce development, or those who need a refresher on these topics.
Multitenancy in Salesforce
Before diving into SOQL and DML, it’s important to first understand how your records are stored in Salesforce. The database that contains your records behind the scenes does not actually contain a SQL table for each of your standard and custom objects. The database stores records in a multitenant database, a database that stores data and metadata from multiple tenants in a standardized way. The database contains generic tables to store standard and custom object records.
I particularly like the image below from
Leave a Reply