Salesforce Object Query Language (SOQL) Crash Course | The Complete Hands-on Tutorials

SOQL in Salesforce is used to retrieve data from the Salesforce database for specific information. This video covers everything you need to know as a beginner to SOQL from writing your first SOQL query to making your interview ready.

0:00 – What is SOQL? Why do we use it?
1:15 – Demystify a SOQL query
1:54 – How to build or write a SOQL query?
3:21 – Project’s object schema overview
3:55 – Auto Build SOQL using Dev console
5:29 – Query standard object records using SOQL (Write your first SOQL query)
6:25 – Querying custom object’s records using SOQL
7:49 – Filtering records using SOQL (Using WHERE clause in SOQL)
9:00 – AND Operator in SOQL (using multiple filter conditions)
10:34 – OR Operator in SOQL
11:28 – Using AND and OR operator together in SOQL
13:45 – Using multiple OR conditions in SOQL
14:50 – Using IN operator in SOQL (combining multiple OR conditions together in SOQL)
16:03 – Using LIKE operator in SOQL (Finding close match records with SOQL)
19:58 – ORDER BY clause in SOQL (Sorting records using SOQL)
22:20 – Comparison Operators in SOQL (Equals, greater than, not equals, less than, etc)
25:50 – Date Literals in SOQL (working with date fields in SOQL)
28:53 – Using LIMIT keyword in SOQL (Limiting the number of records in resultset in SOQL)
29:55 – OFFSET keyword in SOQL
31:07 – Understanding Relationship Queries in SOQL (No join queries)
33:55 – Getting Relationship Name for SOQL
36:02 – Inner SOQL Queries on Standard Objects, Fetching Child Records along with Parent in SOQL (Parent to Child Relationship SOQL queries) – Standard Objects
38:09 – Inner SOQL Queries on Custom Objects, Fetching Child Records along with Parent in SOQL (Parent to Child Relationship SOQL queries)
41:47 – Child to Parent Relationship Queries on Standard objects
45:47 – Child to Parent Relationship Queries on Custom objects
49:00 – Advanced SOQL – GROUP BY Clause Overview
50:17 – Using Aggregate Function in SOQL (MAX, SUM, AVG, MIN, COUNT functions) – Advanced SOQL
52:47 – Aggregate functions with GROUP BY clause in SOQL