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...
LWC Crash Course: • Lightning Web Componen...
JS Crash Course: • Modern JS Crash Course...
SLDS Crash Course: • SLDS Crash Course - Be...
SOQL Reference Guide - 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 - www.udemy.com/course/salesfor...
📹 The Ultimate Hands-On Lightning Web Component - www.udemy.com/course/lightnin...
📹 The Practical Guide to SFDX and Salesforce CLI - www.udemy.com/course/salesfor...
Follow SFDCFacts Academy:
Website: sfdcfacts.com
Facebook: / sfdcfacts
Instagram: / sfdcfacts
LinkedIn: / sfdcfacts
Connect with Manish:
/ manish-choudhary
Twitter: / sfdcfacts
Become a patron and support my work here: / sfdcfacts
#SalesforceIntegration #Api #Webservices
#soql #salesforcetutorial #soqltutorial #sql
21 июл 2024
