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 you interview ready.

Check out my other crash courses
Salesforce Integration Crash Course:    • Salesforce Integration Crash Course |...  
LWC Crash Course:    • Lightning Web Component Crash Course ...  
JS Crash Course:    • Modern JS Crash Course | The Ultimate...  
SLDS Crash Course:    • SLDS Crash Course  Beginner's guide ...  

SOQL Reference Guide https://developer.salesforce.com/docs...

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


About:

Manish is a highly experienced Software Developer who has worked in big tech companies like Google and Salesforce. Presently he is associated with Amazon as SDE 2.
He is on his journey to make everyone interview ready for the big 5 FAANG (Facebook, Amazon, Apple, Netflix, Google) companies. Check out his channel for comprehensive tutorials on various technologies and mock google/amazon interviews.

My courses on Udemy (discounted links below):

The Complete Salesforce Development Course https://www.udemy.com/course/salesfor...

The Ultimate HandsOn Lightning Web Component https://www.udemy.com/course/lightnin...

The Practical Guide to SFDX and Salesforce CLI https://www.udemy.com/course/salesfor...

Follow SFDCFacts Academy:
Website: https://sfdcfacts.com
Facebook:   / sfdcfacts  
Instagram:   / sfdcfacts  
LinkedIn:   / sfdcfacts  


Connect with Manish:
  / manishchoudhary  
Twitter:   / sfdcfacts  

Become a patron and support my work here:   / sfdcfacts  

#SalesforceIntegration #Api #Webservices

#soql #salesforcetutorial #soqltutorial #sql