One lesson
An individual lesson
This track has no lesson ready to buy yet. Each lesson becomes available only after it is built and reviewed.
$5.00Not available yet
All course tracks
Salesforce · 30 lessons · up to 10 minutes each
SOQL and SOSL
A planned query path through filtering, relationships, search, and safe Apex use.
Coming Soon
One-time purchase · USD
Choose what to unlock
Access is attached to your account after payment is verified. No subscription.
Full category
SOQL and SOSL
Permanent access to the lessons published in this track when you buy. Future lessons are not included. 0 of 30 lessons are published; 0 are in owner review and 30 are Coming Soon.
$29.0030 lessons still in progress
Beginner
Lessons 1–10
01 SOQL and SOSL: Sketch record selection with SOQL
Topic: record selection with SOQL
Draw a small map of record selection with SOQL in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Beginner4 minComing Soon02 SOQL and SOSL: Name the parts of filters and comparison operators
Topic: filters and comparison operators
Label the main pieces in filters and comparison operators in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Beginner5 minComing Soon03 SOQL and SOSL: Trace an example of relationship queries
Topic: relationship queries
Follow one input through relationship queries in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Beginner6 minComing Soon04 SOQL and SOSL: Compare choices for aggregate functions
Topic: aggregate functions
Write down one practical difference between aggregate functions in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Beginner7 minComing Soon05 SOQL and SOSL: Find the boundary in ordering and result limits
Topic: ordering and result limits
Mark where ordering and result limits in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Beginner8 minComing Soon06 SOQL and SOSL: Inspect an example of SOSL search terms
Topic: SOSL search terms
Annotate a minimal example of SOSL search terms in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Beginner9 minComing Soon07 SOQL and SOSL: Connect search scopes and returned fields to a neighboring concept
Topic: search scopes and returned fields
Show how search scopes and returned fields in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Beginner10 minComing Soon08 SOQL and SOSL: Spot a failure mode in query selectivity
Topic: query selectivity
Describe one likely failure for query selectivity in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Beginner3 minComing Soon09 SOQL and SOSL: Read an official example of query bind variables
Topic: query bind variables
Summarize an official example of query bind variables in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Beginner5 minComing Soon10 SOQL and SOSL: Choose a use case for query behavior in Apex
Topic: query behavior in Apex
Match one small use case to query behavior in Apex in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Beginner6 minComing Soon
Intermediate
Lessons 11–20
11 SOQL and SOSL: Build an example with record selection with SOQL
Topic: record selection with SOQL
Create a small working example that uses record selection with SOQL in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Intermediate4 minComing Soon12 SOQL and SOSL: Compose filters and comparison operators with another component
Topic: filters and comparison operators
Combine filters and comparison operators in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Intermediate5 minComing Soon13 SOQL and SOSL: Configure relationship queries for a small case
Topic: relationship queries
Set up relationship queries in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Intermediate6 minComing Soon14 SOQL and SOSL: Validate inputs around aggregate functions
Topic: aggregate functions
Add a check around aggregate functions in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Intermediate7 minComing Soon15 SOQL and SOSL: Use ordering and result limits in a short workflow
Topic: ordering and result limits
Add ordering and result limits in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Intermediate8 minComing Soon16 SOQL and SOSL: Refactor SOSL search terms into a reusable unit
Topic: SOSL search terms
Extract SOSL search terms in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Intermediate9 minComing Soon17 SOQL and SOSL: Exercise search scopes and returned fields with sample data
Topic: search scopes and returned fields
Run sample data through search scopes and returned fields in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Intermediate10 minComing Soon18 SOQL and SOSL: Observe query selectivity outputs
Topic: query selectivity
Capture the result of query selectivity in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Intermediate3 minComing Soon19 SOQL and SOSL: Recover from a query bind variables failure
Topic: query bind variables
Handle one expected failure from query bind variables in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Intermediate5 minComing Soon20 SOQL and SOSL: Document query behavior in Apex behavior
Topic: query behavior in Apex
Write a short usage note for query behavior in Apex in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Intermediate6 minComing Soon
Advanced
Lessons 21–30
21 SOQL and SOSL: Test a boundary around record selection with SOQL
Topic: record selection with SOQL
Add an edge-case test for record selection with SOQL in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Advanced4 minComing Soon22 SOQL and SOSL: Harden filters and comparison operators
Topic: filters and comparison operators
Add the relevant access, safety, or validation control to filters and comparison operators in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Advanced5 minComing Soon23 SOQL and SOSL: Measure relationship queries
Topic: relationship queries
Record a small baseline for relationship queries in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Advanced6 minComing Soon24 SOQL and SOSL: Reduce cost in aggregate functions
Topic: aggregate functions
Change one measurable cost in aggregate functions in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Advanced7 minComing Soon25 SOQL and SOSL: Diagnose a ordering and result limits failure
Topic: ordering and result limits
Use an observable signal to explain a failure in ordering and result limits in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Advanced8 minComing Soon26 SOQL and SOSL: Make SOSL search terms repeatable
Topic: SOSL search terms
Show that rerunning SOSL search terms in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Advanced9 minComing Soon27 SOQL and SOSL: Review trade-offs in search scopes and returned fields
Topic: search scopes and returned fields
Compare two documented approaches to search scopes and returned fields in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Advanced10 minComing Soon28 SOQL and SOSL: Improve query selectivity maintainability
Topic: query selectivity
Refine query selectivity in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Advanced3 minComing Soon29 SOQL and SOSL: Verify query bind variables end to end
Topic: query bind variables
Check that a complete small flow using query bind variables in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Advanced5 minComing Soon30 SOQL and SOSL: Audit query behavior in Apex against its source docs
Topic: query behavior in Apex
Check the implementation of query behavior in Apex in the context of SOQL and SOSL queries over Salesforce records; save a short example or check that demonstrates the result.
Advanced6 minComing Soon
Reference documentation
References support the selected track topics while its lesson content is built and reviewed progressively.
This track is a catalog outline only. Each lesson remains unavailable until it is built and personally reviewed.