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

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

Рет қаралды 105,714

Күн бұрын

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

Пікірлер: 123

@SFDCFacts 2 жыл бұрын

Do you find this video helpful? Here are my other crash courses you might be interested in: ⏭ Salesforce Integration Crash Course 🔗 kzfaq.info/get/bejne/aNOpos9qza-WaJc.html ⏭ LWC Crash Course 🔗 kzfaq.info/get/bejne/mLKpdNZ6yqq-pKs.html ⏭ Modern Javascript Crash Course 🔗 kzfaq.info/get/bejne/mr9on8xlr9TTh4U.html ⏭ SLDS Crash Course 🔗 kzfaq.info/get/bejne/fqqjqKZ4x9rVqZ8.html ⏭ CSS Filter Crash Course 🔗 kzfaq.info/get/bejne/nd5iaNugyczciWw.html

@kmpkidsdance2195 2 жыл бұрын

Can u plz explain lwc progress bar our own customization by using CSS or jquery

@demariotucker1176 2 жыл бұрын

Wow! Definitely some of the best Salesforce content I have encountered yet! Kudos my friend and thanks so much for creating this!

@saniyahussain2159 5 ай бұрын

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!!

@kittyvonrosco8116 Жыл бұрын

I'm not very technical and this was very well explained with good examples. Thank you!

@thfeiroz76 2 жыл бұрын

I find it much useful in understanding the SOQL topic for beginners. Your presentation is very good with examples. Thank you.

@rajeshbawge9250 Жыл бұрын

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

@ollenelsonhall7393 Жыл бұрын

Fantastic tutorial, keep up the great videos!

@chrystalfreeland2862 Жыл бұрын

This is an awesome tutorial! Thank you, this helps out a lot.

@Halil7236 Жыл бұрын

Great content, thank you for your time and effort. Much appreciated.🙏

@RandomGuy-hv7tb 2 жыл бұрын

You're one of the best instructor, your udemy course resolved all my doubts.

@rupeshjha1929 2 жыл бұрын

Thanks @ Manish for the wonderful crash-course. This 60 min video is a go to refresher for SOQL anytime for anyone

@SFDCFacts 2 жыл бұрын

Thanks Rupesh, glad you enjoyed it!

@gsairamsai266 2 жыл бұрын

Thanks for the great tutorial on SOQL and its really worth of time...

@ravirajadhalikar9679 2 жыл бұрын

Very useful, really liked it. Thank you :)

@amuthak9513 Жыл бұрын

you have explained very clear about the Concepts.Its very useful as i am beginner. Thanks for your content.

@gauravbhardwaj2588 2 жыл бұрын

Mast bhai. Thanks a lot. Please, make video on regular basis.

@rinkibiswas9760 Жыл бұрын

awesome video sir. being from non IT background I understood all very nicely

@guilhermesouza5366 Жыл бұрын

Awesome, find this course in a great time, it help me so much, thanks Manish!

@irmak3885 2 жыл бұрын

Thank you so much. It is an amazing informative video. I love it. Please share more videos.

@siddharthanks6843 Жыл бұрын

this helped me brush up. Thanks a lot.

@lifeinatl-vlog8001 Жыл бұрын

the second half is a must watch!

@swayanpravasahoo8735 2 жыл бұрын

wonderful Manish....very helpful

@saikumargummalla1709 2 жыл бұрын

THANK YOU SO MUCH MANISH YOUR SOQL CRASH COURSE HELPS ME ALOTTT

@sivareddycrm 2 жыл бұрын

Thanks Manish for wonderful session. In future, I want to learn on list, Map, Set, multiple Maps,obects which are useful while writing apex.

@muralikrishna4243 Жыл бұрын

Ya really use full course. And the way you explained is also very good tq for providing with such type of videos

@anishroy8805 2 ай бұрын

Great Explanation Manish bhai 😍

@sanjaychari9666 2 жыл бұрын

You explain it so well.

@ADITYASINGH-ih2hz 2 жыл бұрын

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.

@antrasharma3580 2 жыл бұрын

Thank you so much, its really helpful.

@fit.shubhh 2 жыл бұрын

Thanks a lot Manish Sir to provide such a great content🤩...

@arnabsaha9483 2 жыл бұрын

Keep Updating, Salesforce Development coarse please ... & Add more Coding Challenges in Apex

@birendrachand5286 11 ай бұрын

Great Video !

@sathishgopi3217 8 ай бұрын

Such a Great Broh !!!

@ranvirk9039 2 жыл бұрын

Awsome video...thank you so much

@zt3258 7 ай бұрын

Thank you!

@damupawan2518 Жыл бұрын

Thanks bro... really very helpful 🙂

@anusha81 2 жыл бұрын

Thanks a lot for this video 👍

@Vishal-cs8bp 11 ай бұрын

Excellent Explanation

@husnuozaltun3477 6 ай бұрын

Thank you brother.

@manishamaradkar6023 Жыл бұрын

I cleared all my doubt ..thanks for the video...if possible make video on trigger in salesforce.

@karthikdv158 2 жыл бұрын

very much useful, Thank you so much

@ashishsahu1310 2 жыл бұрын

Good content!!

@gauravpatil4930 2 жыл бұрын

Thank you so much. It is an amazing informative video....Very Helpful

@SFDCFacts 2 жыл бұрын

Thanks Gaurav :)

@yash25dec 2 жыл бұрын

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.

@sravankumares7138 2 жыл бұрын

Awesome vedio thanks 😊

@riyazpasha6264 2 жыл бұрын

nice explanation bro

@madebyyasemin 2 жыл бұрын

hi i really enjoy while learning with your videos about Salesforce. Can you pls make next video about triggers

@suhaskshirsagar5202 2 жыл бұрын

Nice explanation..👌👌

@ramesha5243 Жыл бұрын

Thank you very much, Excellent understanding very clearly, and I think you missed having aquery

@meatswitch9572 2 жыл бұрын

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?

@maruthisainath6080 2 жыл бұрын

Awesome video sir. If possible please do video on apex Classes and triggers.

@learnwithtrailhead2856 2 жыл бұрын

Good one Manish, Keep posting such type of crash courses. I am looking for more interview series :P

@SFDCFacts 2 жыл бұрын

This will lead you to clearing an interview ;)

@user-qe2vi4ye9o 2 ай бұрын

nice session

@omkarkulkarni9539 Жыл бұрын

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.

@divyasreemareedu7105 7 ай бұрын

thanks Manish , liked the course. Could you please make a deeper course on relationship soql queries in combination with Apex

@vikassinghal7496 2 жыл бұрын

Love you man

@BoomcoreIsLive 2 жыл бұрын

Thanks for the great tutorial on SOQL

@SFDCFacts 2 жыл бұрын

Glad you liked it

@satyaprasad9371 2 жыл бұрын

Super explanation

@filmydetective3116 Жыл бұрын

Thank you..

@vinitham8781 2 жыл бұрын

Thank you so much for this sir, Can u do a video of FFLIB framework

@Sai-Krishna786 Жыл бұрын

Useful

@pratikshapatil6792 Жыл бұрын

Thank u

@naveenkumar-ib4lm 2 жыл бұрын

usefull information

@MD-fh4lb 2 жыл бұрын

Good Course

@satoboshi11 2 жыл бұрын

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?

@suneelkumar-kn4ds 2 жыл бұрын

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

@rajeshbawge9250 Жыл бұрын

Pls you have to make videos on trigger if its already let me know.... Bcz your explanation is very useful thank you advance

@SanamKarki 2 жыл бұрын

Thank you so much for this. I would definitely love to see a course on APEX. Thanks.

@mrdarshyt2914 2 жыл бұрын

hmm

@srinivaschandika6153 Жыл бұрын

Very good Explanation, how to get distinct records using soql. kindly help me

@tejachowdhary1159 2 жыл бұрын

hello Brother Excellent explanation. can you please make a crash course on TRIGGERS.

@debarunsengupta3555 2 жыл бұрын

I think it would be better if you can include having clause and polymorphic soql as well

@rajnishjha5817 2 жыл бұрын

Yes, I thought there is no having clause as such in SOQL ...oh boy!!😆😅

@parvathymc138 2 жыл бұрын

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.

@SFDCFacts 2 жыл бұрын

Noted :)

@parvathymc138 2 жыл бұрын

@@SFDCFacts Thank you

@sandhyasrimahesh9918 2 жыл бұрын

Super

@ramireddygarivinaykumarred7261 2 жыл бұрын

Fantastic explanation Manish bro

@SFDCFacts 2 жыл бұрын

Thank you so much bro! Hope you've subscribed, I ll be coming up with a lot more soon 😀

@ramireddygarivinaykumarred7261 2 жыл бұрын

We want SOSL also

@kaishgupta4376 2 жыл бұрын

How to fetch data when you have alphanumeric character by using like operator

@chinomsojohnson8746 7 ай бұрын

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

@MD-fh4lb 2 жыл бұрын

Hi Manish, can you write about how to know which profile have access to which objects ?

@Abhishek-yb9kb 2 жыл бұрын

Thanks Manish, one doubt - can i fetch Account name from contact, maybe using inner qurey or in any other way

@ramesha5243 Жыл бұрын

Could please make all complete course videos series for admin, Development , LWC, Integration for us please

@selsiaebanezar1308 2 жыл бұрын

After querying I need the particular data in Excel what to do for that

@anmoldhanvijay2138 Жыл бұрын

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 ,

@shamisyed9285 2 жыл бұрын

How to download the columns names and data type in sales force

@saichakravarthi510 2 жыл бұрын

superb bro

@SFDCFacts 2 жыл бұрын

Thanks 🤗

@sailakshmankanukollu5328 2 жыл бұрын

How to get unique records in single query like we use distinct in Oracle

@Tanya-vr2um 2 жыл бұрын

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

@vinayhans161 4 ай бұрын

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??

@vaibhavbhojne1446 Жыл бұрын

How to write soql query that will retrieve account having 2 contact and 2 opportunity

@a.k8058 6 ай бұрын

What is difference between SOQL and SQL both are same or different?

@gauravbhardwaj2588 3 жыл бұрын

Bhai waiting. I have purchased your all course on udemy

@SFDCFacts 2 жыл бұрын

Great Gaurav, hope it is helping you by leaps and bounds

@gauravbhardwaj2588 2 жыл бұрын

Pl share ur what app no

@chandrabasetti4893 Жыл бұрын

How can we track that a user has used Salesforce inspector?

@maheshb5703 2 жыл бұрын

Great job brother. Help me to write this querry. SOQL for {list of accounts which should not have contacts}

@moneybee5228 2 жыл бұрын

Select phone, name from account where phone=null or select name, account.name from contact where account.name=null

@sanjaychari9666 2 жыл бұрын

crash course on 1. Triggers 2. Apex 3.Aura Component 4. Asynchronous-batch Apex

@SFDCFacts 2 жыл бұрын

Thanks for the suggestions Sanjay!

@dsn910 2 жыл бұрын

How to install this tool....

@SeekingSmiles236 Жыл бұрын

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?

@user-js5ml8id9n 2 ай бұрын

18:38 % is percentile, not ampersand (&).

@KumarNaveennaveen 2 жыл бұрын

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

@arthisu8270 2 жыл бұрын

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.

@SFDCFacts 2 жыл бұрын

Wow!! This means a lot to me. Best of luck Arthi!!