SOQL and SOSL in Depth

Apex ProgrammingSOQL and SOSL in DepthMaster Salesforce's two query languages: relationship queries, semi-joins, aggregates, polymorphic TYPEOF, user-mode security, dynamic queries with binds, query selectivity and the Query Plan tool, and full-text search with SOSL.Intermediate · about 85 minutesWhat you will learn

Write relationship queries in both directions, semi-joins and anti-joins

Use aggregate functions with GROUP BY, ROLLUP, CUBE and HAVING and read AggregateResult

Enforce security with WITH USER_MODE and explain why it is preferred over WITH SECURITY_ENFORCED

Build safe dynamic SOQL with Database.queryWithBinds and avoid SOQL injection

Explain query selectivity, indexes and use the Query Plan tool for large data volumes

Write SOSL searches and choose correctly between SOQL and SOSL

Contents

How SOQL fits the platform

SOQL syntax essentials

Relationship queries

Polymorphic relationships and TYPEOF

Aggregates, GROUP BY, ROLLUP, CUBE and HAVING

ORDER BY, LIMIT and OFFSET

Locking and tracking clauses

Security: WITH USER_MODE, SYSTEM_MODE and SECURITY_ENFORCED

Bind variables

Dynamic SOQL

SOQL for loops and QueryLocator

Query performance: selectivity, indexes and the Query Plan tool

SOSL: full-text search

SOQL vs SOSL: choosing

Common errors and what they mean

Worked example: an account health query service

Best practices

Common pitfalls

Hands-on exercises

Key takeaways