SOQL & Data Access

Querying and accessing Salesforce data — SOQL, SOSL, relationships, and DML patterns.

Topics Covered

• SOQL Basics — SELECT, WHERE, ORDER BY, LIMIT, OFFSET, date literals
• Relationship Queries — Parent-to-child (subqueries), child-to-parent (dot notation)
• Aggregate Functions — COUNT, SUM, AVG, MIN, MAX, GROUP BY, HAVING
• SOSL — Full-text search, FIND, RETURNING, search groups
• DML Operations — Insert, update, upsert, delete, undelete, merge, Database methods
• Dynamic SOQL — String-based queries, bind variables, security considerations