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

Credits : SFDCFacts Academy

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

Responses

Popular Salesforce Videos

Salesforce Admin Certification 2020 Questions Explained with References - Part II

Video in

How to prepare and pass Salesforce Admin Certification with Practice Exam Questions 2020 practice questions and answers for the Salesforce Administration Salesforce Certified Admin Exam Questions Salesforce Administrator Certification Exam…