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

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: https://youtu.be/2myol9hI28c LWC Crash Course: https://youtu.be/bLyAsIeDZtw JS Crash Course: https://youtu.be/dY8li4JnoWQ SLDS Crash Course: https://youtu.be/HDsuCGbtqyk SOQL Reference Guide - https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/ 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/salesforce-development/?referralCode=C44BBFDBBBA789BC6A3D ? The Ultimate Hands-On Lightning Web Component - https://www.udemy.com/course/lightning-web-component-development/?referralCode=B29D1E8015D945236DBA ? The Practical Guide to SFDX and Salesforce CLI - https://www.udemy.com/course/salesforce-cli/?referralCode=91D0F7061562D1B59737 Follow SFDCFacts Academy: Website: https://sfdcfacts.com Facebook: https://www.facebook.com/sfdcfacts Instagram: https://www.instagram.com/sfdcfacts LinkedIn: https://www.linkedin.com/company/sfdcfacts Connect with Manish: https://www.linkedin.com/in/manish-choudhary/ Twitter: https://twitter.com/sfdcfacts Become a patron and support my work here: https://www.patreon.com/sfdcfacts #SalesforceIntegration #Api #Webservices #soql #salesforcetutorial #soqltutorial #sql