SQL Subquery | Complete Guide with Correlated Subquery | #SQL Course #15

A comprehensive SQL subquery tutorial that provides a complete understanding of subqueries in SQL and their use cases. We will cover everything about how to use it in SELECT, FROM, JOIN, WHERE, IN, EXISTS, ANY, ALL, and more..

☕ Stay connected

📚 Free Courses

🎓Other Platforms (Certifications)

⏱️ Timestamp
00:00 Intro
00:26 What is Subquery?
03:40 Why Subquery?
05:45 Categories of Subquery
07:52 Subquery Result Types
10:23 FROM Clause Subquery
21:15 How DB Executes Subquery
22:51 SELECT Clause Subquery
29:54 JOIN Clause Subquery
34:57 WHERE Clause Subquery
41:41 IN Operator Subquery
50:11 ANY, ALL Operators Subquery
56:25 Correlated Vs Non-Correlated Subqueries
01:07:11 Exists Operator Subquery
01:19:11 Subquery Summary

#sql #sqlserver #data #analytics
**Please note I may earn a small commission for any purchase through these links, which means at no additional cost to you - Thanks for supporting the channel!**
**All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for**

[DataWithBaraa]

TIMESTAMPS

00:00 Intro
00:26 What is Subquery?
03:40 Why Subquery?
05:45 Categories of Subquery
07:52 Subquery Result Types
10:23 FROM Clause Subquery
21:15 How DB Executes Subquery
22:51 SELECT Clause Subquery
29:54 JOIN Clause Subquery
34:57 WHERE Clause Subquery
41:41 IN Operator Subquery
50:11 ANY, ALL Operators Subquery
56:25 Correlated Vs Non-Correlated Subqueries
01:07:11 Exists Operator Subquery
01:19:11 Subquery Summary
Enjoy

[habibpranav]

Nobody on the internet has explained this topic in such a concise and clear way but you did and thank you for that Baraa.

[yashkamath]

Subqueries was the topic where i used to get confused about where and when to use . You explained each of the cases properly . Thank You

[ahmedshalaby]

just wanted to thank you because of your videos I have passed the interview

[DivyYadav-hgjs]

highest quality video on subquey ever made

[DivyYadav-hgjs]

FOR NOW THIS CHANNEL IS THE BEST CHANNEL TO LEARN SQL AND TABLEAU, I HOPE BARA U GET PYTHON AND POWER BI SOON I CAN SEE THIS CHANNEL REACHING HEIGHTS IN THE UPCOMING YEARS AS THE AMOUNT OF EFFORTS U PUT IN WILL SURELY MAKE THIS CHANNEL THE TOP CHANNEL FOR DATA ON YOUTUBE. THANK YOU FOR UR EFFORTS

[surajjidge]

One of the best channel on YouTube to learn SQL..!

[DivyYadav-hgjs]

YESTERDAY MY FRIEND CALLED ME AND THANKED ME FOR SUGGESTING UR CHANNEL TO HIM, UR A LIFE SAVER BARA U GOT COVERD SQL AND TABLEAU . tbh im ready to pay u for ur course on python and the amount of efforts u put are amazing please start python in ur way ur a DATA GOD u dont even know u helped so many people THANK U

[hafsaaittaleb]

Awesome! the best YouTube channel EVER, I'm on the 13 hour in tableau Tutorial and it' just amazing Baraa, Please we need PYTHON asap. You must teach our teachers at university because we don't understand anything from them.

[gbadeboabayomi]

Hey folks! Please subscribe to his channel. It's the only way to appreciate Baraa's selfless service to humanity. Thank you all for doing just that!

[NohablaEspnaol]

Thank you so much sir, you have explained it really well, loved your teaching method <3, I was really confused on this and I got recommended to watch your channel and it was worth it!!

[SAhmBal]

It's clear and simplest way to make us understand complex queries, but not only writing queries, but also clearly explaining our concepts about how SQL works behind the scenes. The presentation is also amazing and engaging, which doesn't make us feel bored. Overall, amazing content, highly appreciated! Thanks to the YouTube algorithm for bringing me here.

[AmanSingh-gogf]

I think the only channel which inspired me to learn SQL and tableau from scratch .. from a dot to a line .
I must say the only channel which make your concepts crystal clear in tableau

[Humanity_matters_st]

I really enjoyed this lesson! The way you broke down the complex topic into smaller, manageable sections made it much easier to understand. I look forward to more like this in the future. Keep up the great work! :-)

[gsalema]

Here we go again, this channel is all about uplifting yourself to the world 🎉

[veerendram]

Sir i am big fan of your teaching
Excellent work 👏👏👏

[ImtiyazMohammed-mpmp]

This is amazing, I learned basic sql from w3schools and some videos but wasn't able to proceed further then came across your channel. Thank you.

[RajdeepKumar-il]

Thank you Baraa, Completing this tutorial with practice, revision and notes making.

[RikhaMida]

Your channel is magnificent, it really helps many people especially beginner to be a master in SQL. Great job!

[slom]

Subscribed.

You are truely the best. I've been watching your advanced SQL course and it's been really helpful to me. Thank you.

Highly recommended watch to anyone wanting to better their understanding of advanced SQL functions !!