Salesforce Object Query Language (SOQL) Crash Course | The Complete Hands-on Tutorials | In 1 Hour
Vložit
- čas přidán 9. 07. 2024
- 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
Do you find this video helpful? Here are my other crash courses you might be interested in:
⏭ Salesforce Integration Crash Course 🔗 czcams.com/video/2myol9hI28c/video.html
⏭ LWC Crash Course 🔗 czcams.com/video/bLyAsIeDZtw/video.html
⏭ Modern Javascript Crash Course 🔗 czcams.com/video/dY8li4JnoWQ/video.html
⏭ SLDS Crash Course 🔗 czcams.com/video/HDsuCGbtqyk/video.html
⏭ CSS Filter Crash Course 🔗 czcams.com/video/gx25xodfxY8/video.html
Can u plz explain lwc progress bar our own customization by using CSS or jquery
Wow! Definitely some of the best Salesforce content I have encountered yet! Kudos my friend and thanks so much for creating this!
Fantastic tutorial, keep up the great videos!
This is an awesome tutorial! Thank you, this helps out a lot.
Great content, thank you for your time and effort. Much appreciated.🙏
I'm not very technical and this was very well explained with good examples. Thank you!
I find it much useful in understanding the SOQL topic for beginners. Your presentation is very good with examples. Thank you.
Very useful, really liked it. Thank you :)
Awesome, find this course in a great time, it help me so much, thanks Manish!
You explain it so well.
Very nice explanation with proper understanding if anyone have little bit confusion go through this video you can get each and everything without boring. thank you
You're one of the best instructor, your udemy course resolved all my doubts.
Thanks for the great tutorial on SOQL and its really worth of time...
this helped me brush up. Thanks a lot.
THANK YOU SO MUCH MANISH YOUR SOQL CRASH COURSE HELPS ME ALOTTT
Great crash course as always.
Thanks, Manish sir .
In the future, i would really like to see a crash course on Apex + SOQL.
Please think about it.
What a video!
I belong to a non tech background and the way you are breaking the thing into a simplified manner is just simply boosting my confidence and increasing my interest!!
Thanks Manish for wonderful session. In future, I want to learn on list, Map, Set, multiple Maps,obects which are useful while writing apex.
Thanks @ Manish for the wonderful crash-course. This 60 min video is a go to refresher for SOQL anytime for anyone
Thanks Rupesh, glad you enjoyed it!
wonderful Manish....very helpful
Thank you so much. It is an amazing informative video. I love it. Please share more videos.
Thank you so much, its really helpful.
the second half is a must watch!
Great Video !
you have explained very clear about the Concepts.Its very useful as i am beginner. Thanks for your content.
Mast bhai. Thanks a lot. Please, make video on regular basis.
awesome video sir. being from non IT background I understood all very nicely
Thanks a lot Manish Sir to provide such a great content🤩...
Great Explanation Manish bhai 😍
Such a Great Broh !!!
Good content!!
Excellent Explanation
Thank you!
Thanks a lot for this video 👍
Ya really use full course. And the way you explained is also very good tq for providing with such type of videos
Keep Updating, Salesforce Development coarse please ... & Add more Coding Challenges in Apex
Awsome video...thank you so much
very much useful, Thank you so much
Love you man
Thanks bro... really very helpful 🙂
Thank you brother.
Awesome vedio thanks 😊
I am admire of your work. There is only one correct Account object isn't the parent of contact/opportunity. there is a lookup relationship( with delete item checkbox). I too got to know it while checking something else.
Thank you..
Thank you so much. It is an amazing informative video....Very Helpful
Thanks Gaurav :)
Thanks for the great tutorial on SOQL
Glad you liked it
How to fetch data when you have alphanumeric character by using like operator
Nice explanation..👌👌
I cleared all my doubt ..thanks for the video...if possible make video on trigger in salesforce.
hi i really enjoy while learning with your videos about Salesforce. Can you pls make next video about triggers
Good one Manish, Keep posting such type of crash courses.
I am looking for more interview series :P
This will lead you to clearing an interview ;)
This is the top recommended video on this subject, and I'm eager to learn, but I have a really bad auditory processing disorder and I can't understand most accents without asking for clarification. Can you please consider putting closed captions on videos like this?
Thanks for the video! I have a question, I was running a parent-child query and get 50 records as results but when I run a report with the same filters and objects I get 75 records.
Have this ever happened to you?
nice explanation bro
After querying I need the particular data in Excel what to do for that
Hi, is it possible to write a comparision logic in where clause like if I want to get records WHERE ECM_PARTY_ID =ECM_ADDRESS_ROW_ID is it possible through SOQL query
I had an interview question where I was asked to write a soql query on the account field to retrieve all related contacts and I wrote this Select Id, Name (Select Id, Name from Contacts) from Account. The interviewer said it was wrong and we will need to loop through each account record to get the related contacts. Is there a better way to do this. I would love to know incase I see it again. I have gone online but I keep on seeing the same thing I did at the interview
Super explanation
nice session
thanks Manish , liked the course. Could you please make a deeper course on relationship soql queries in combination with Apex
How to download the columns names and data type in sales force
Hello Manish,
Your Videos was awsome for better understanding related the salesforce core concept. but there one humble request to you, please create a crash course lecture video on Visualforce and Asynchrnous process.
What if we want data from a particular field who's having a self relationship. For now I'm able to get I'd only. Any tips for this ,
the one who created his custom object how did he create the table which is the name and the data in city__s how did he create
Awesome video sir.
If possible please do video on apex Classes and triggers.
Useful
How to write soql query that will retrieve account having 2 contact and 2 opportunity
Thank you so much for this sir, Can u do a video of FFLIB framework
Thank you very much, Excellent understanding very clearly, and I think you missed having aquery
Thank u
I think it would be better if you can include having clause and polymorphic soql as well
Yes, I thought there is no having clause as such in SOQL ...oh boy!!😆😅
Good Course
usefull information
Hi, Thanks so much for detailed videos, could you please publish a video on end to end project explanation which covers all aspects like LWC, Apex programming wiht Triggers, Integration etc.
Noted :)
@@SFDCFacts Thank you
How to get unique records in single query like we use distinct in Oracle
Thank you so much for this. I would definitely love to see a course on APEX. Thanks.
hmm
Thanks Manish, one doubt - can i fetch Account name from contact, maybe using inner qurey or in any other way
What is difference between SOQL and SQL both are same or different?
Fantastic explanation Manish bro
Thank you so much bro! Hope you've subscribed, I ll be coming up with a lot more soon 😀
We want SOSL also
Super
Hi, Just completed this course and it is very helpful... having 1 question..while fetching data from parent to child soql query, the child data is in json format Because of multiple childs ...can we extract them in relational format??
Hi Manish, can you write about how to know which profile have access to which objects ?
hello Brother Excellent explanation. can you please make a crash course on TRIGGERS.
superb bro
Thanks 🤗
Hello Sir, Please help me understand this::::: Select AccountId,max(Amount) from Opportunity where AccountId = '0015i00000NCb9lAAD'
group by AccountID
I should get the result as 915000 but getting 91500 . Can you explain me why this is happening?
How to install this tool....
Pls you have to make videos on trigger if its already let me know.... Bcz your explanation is very useful
thank you
advance
How can we track that a user has used Salesforce inspector?
Very good Explanation, how to get distinct records using soql. kindly help me
crash course on
1. Triggers
2. Apex
3.Aura Component
4. Asynchronous-batch Apex
Thanks for the suggestions Sanjay!
Bhai waiting. I have purchased your all course on udemy
Great Gaurav, hope it is helping you by leaps and bounds
Pl share ur what app no
If have created a report and report type contains Accounts, Custom object lets say B.
I am filtering in report using Account record type and record type from B.
COULD YOU PLEASE TELL ME HOW CAN WE WRITE A SOQL QUERY FOR THIS?? PLEASE
Could please make all complete course videos series for admin, Development , LWC, Integration for us please
Great job brother. Help me to write this querry. SOQL for {list of accounts which should not have contacts}
Select phone, name from account where phone=null or select name, account.name from contact where account.name=null
18:38 % is percentile, not ampersand (&).
How to retrieve ALL CONTACTS FROM ALL ACCOUNTS IN A SINGLE SOQL ?
Link to your udemy course?
I am from a non-IT field.Initally i didn`t understand anything in salesforce but now I am learning from your videos,its easy and faster than reading Salesforce help docs.
Wow!! This means a lot to me. Best of luck Arthi!!
I need test classes for apex classes
Nice, write some then :) Just kidding buddy!!
🤝👌