SQL Subquery | Complete Guide with Correlated Subquery |

[@DataWithBaraa]

If you want to see more videos like this, Subscribe for more data tutorials like this :) bit.ly/3GiCVUE 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.

[@DivyYadav-hg2js]

highest quality video on subquey ever made

[@ahmedshalaby9343]

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

[@RikhaMida]

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

[@DivyYadav-hg2js]

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 KZbin. THANK YOU FOR UR EFFORTS

[@surajjidge970]

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

[@gsalema9607]

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

[@AmanSingh-go2gf]

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 .....❤

[@veerendram6638]

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

[@ImtiyazMohammed-mp8mp]

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.

[@gbadeboabayomi9241]

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!

[@Sjjeien]

Why?? We cant even understand his language due to that accent. So better search other vedios

[@farukhahmad1561]

I have subscribed him. He is great and puts a lot of efforts in his videos.

[@Toyahan43]

​@@SjjeienI couldn't understand at first too but you will get used to it. His teaching style is one of a kind, you will not find another person putting so much effort into his videos and making it avaliable to others for free. What dedication!

[@Sjjeien]

@@Toyahan43 thats not the case. There are lot of free videos available in youtube. But i cant even understand what this guy is saying... And also there is no need to watch till the language is used to me. As there are lot more easily understandable youtubers are present Then i thought that, instead of spending time watching this video. I should look for another

[@Toyahan43]

@@Sjjeien sure, whatever works for you. I have watched other youtubers but their lessons aren't as comprehensive. If they work for you then great

[@DivyYadav-hg2js]

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

[@DataWithBaraa]

Wow amazing 🤩 I will do soon

[@hafsaaittaleb6178]

Awesome! the best KZbin 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.

[@ska5691]

Thank you, Baraa Today I have learnt the concept of subqueries properly

[@Humanity_matters_1st]

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

[@SC-mx4wp]

BEST EVER TEACHER I MATE IN MY LIFE 🎉🎉❤❤. KEEP IT UP SIR. PLEASE HAVE FULL TOPICS COVERED ON SQL, TABLEAU, POWER BI 🎉🎉🎉

[@pyephetsavanh6668]

Thank you for your kindness sharing your knowledge ❤❤❤❤❤

[@RajdeepKumar-i5l]

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

[@s77lom49]

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

[@vasilkagenova6266]

Thank you so much. You are amazing. Whit, your calm voice and comprehensive explanation make the material easier to understand.

[@EsraaAyman-t3o]

I have watched so many tutors but the way you explain the information is really interesting and it's not that you share info you explain why it's happening and this is respectful thanks for your efforts.

[@NidhiGusai]

sir, you are doing great work. With your tutorials, I can now solve any SQL problems. Thank you for creating interactive and easily understandable SQL tutorials.

[@DataWithBaraa]

Glad to hear that

[@poojabihani-m9d]

Thank youuu so much!!! Only 20 minutes into the course and I'm learning alot of stuff, which i didn't learned in paid courses Thank you soo much!!! Please never stop uploading videoss

[@mahmoudalsayyad90]

I can't thank you enough! Could you please continue the course with advanced topics in databases, such as indexing, transactions, storage, and so on?

[@priyaljain8797]

Love love love for making sql so interesting with your teaching style!!

[@DataWithBaraa]

Glad you enjoy it!

[@pxlmusicby]

Never seen a person who can simplify things this easy

[@DataWithBaraa]

Thanks 🙏

[@TheDataworm]

You have an awesome tutorial libray on SQL the only addition I would recommend is making a long tutorial solving complex problems using all the skills you have taught. it will be very valuable to see the thought process of solving harder problems and choosing the right approaches.

[@DataWithBaraa]

Great suggestion!

[@TheDataworm]

@@DataWithBaraa Since you liked my suggestion 😉, I’d also recommend combining the advanced SQL playlist into one long video-it’ll definitely get more views like your basic SQL video! There are very few quality advanced SQL tutorials on KZbin. Also, do one on "pivot table"

[@donyelldf]

Another great video, you are a true teacher. Thank you

[@DataWithBaraa]

I appreciate that!

[@ashokmulimani9598]

I am really waited for this video.. thanks

[@hermanmokgope3011]

I've been waiting bro, came at a right time. 🎉

[@mochamadsyahrizal]

Yeaaahhh SQL Subquery letsgooo!!

[@martinberger365]

Love your tutorials @baraa, you are the best teacher ever! BTW I guess that using CTE, sometimes JOINS or Self joins, temporary tables, etc it's much useful than subqueries. For my experiences subqueries are not very much appreciated.

[@huseyinbarkay5854]

I was having hard times with subqueries, well this guy came second to Jesus Ty so much man !

[@satyar-g5p]

cool video, really good tutorial, explained well, audio and visuals are perfect, will check out more of your videos. 😀

[@juancruz7836]

I was waiting for this video, thanks :D:D:D

[@ManjeeriG]

Thank you Baraa..😊

[@farukhahmad1561]

Hey Baraa, I really enjoy your videos. Can you please make a Tutorial Video on power BI?

[@OrtikAbdakimov]

Hurrraaaa🎉🎉🎉🎉❤❤❤❤ i was waiting for it

[@Abzarad]

بارك الله فيك

[@maskanist]

Hello @DatawithBara! Hope you are doing well and really thank you so much for this amazing package and I learned a lot from you rather than my own teacher. Appreciating your good effort, would you please make a video on CASE STATEMENT similar to subquery full video you made already? Kindly help me in this regard and make a full package video on CASE STATEMENT & CASE STATEMENT with JOINS but complete one, similar to SUBQUERY CHAPTER you made. Thanks.... I will be looking forward your kind feedback. Love you ❤❤❤❤❤❤

[@HadeerMansha]

Thanks sir for such a valuable content❤❤

[@DataWithBaraa]

So nice of you

[@HadeerMansha]

@@DataWithBaraa ❤❤

[@AnyBenny]

The best explanation!

[@DataWithBaraa]

Glad you think so!

[@govardhanreddy690]

Thank you sir ❤

[@PhaswanaLedwaba]

Nobody does SQL like Baraaaa! 🎉

[@makarsh29]

please make video on recursive cte

[@DivyYadav-hg2js]

BARA IF U GET A PYTHON COURSE FOR DATA SCIENCE IM SURE THIS CHANNEL WILL BE THE MOST POULAR CHANNEL ON KZbin WAITING FOR UR NEW COURSE LOVE YOU

[@DataWithBaraa]

That's the plan!

[@abhishekkukreja6735]

How do you edit videos and add animation? Its amazing

[@kelothkanna]

so informative sir..a request from your student can you please make videos on python for data analytics

[@subashlingden9883]

Thank you Baraa!

[@kiminonashidesu8697]

Hi Baraa! How many clips do you want to do tutorial? Thanks to make me understand sql better.

[@jbjsb]

Always on top ❤👌

[@DataWithBaraa]

❤️

[@shrutiy903]

Hi... Will you pls make one complete playlist for data analyst... Thank u in advance

[@DataWithBaraa]

Yes, soon

[@Aky-n4j]

There is one more video left. After that CTE will come for which I am waiting.

[@ManjeeriG]

Yes. Me too 😊

[@utkarshgupta-q5c]

Baraa brother , can you please provide the estimated time line for covering all the topics in advance sql. your videos are so awesome and easy to understand each concept with clarity. eagerly waiting for rest of the parts.

[@DataWithBaraa]

I hope in October I would cover the whole course, working now on sql projects. Good quality needs time

[@utkarshgupta-q5c]

@@DataWithBaraa Thanks Baraa for the quick response. Yes it does take time to make quality content. Will be waiting for the new videos.

[@mohamed0707-g7n]

Thank you so much ❤

[@DataWithBaraa]

You're welcome 😊

[@Ajpraize7]

Can you please add the dataset you use along with your videos so we can practice and try along with it. thanks

[@DataWithBaraa]

It is already available check the substack the link in my description

[@DivyYadav-hg2js]

CAN U ALSO COVER A TOPIC CALLED INDEXING AND TRIGGERS IN SQL ITLL MAKE IT COMPLETE THANK U THOUGH BARA

[@ehabnady2473]

Great video as always Barra

[@DataWithBaraa]

Thank you 🤗

[@Toyahan43]

Brother, please provide the presentation notes for the lectures. It will be really helpful

[@A4O_TSL]

Baraa, I'm from Argentina and I commited myself in this journey to be a Data Analyst and a System Enginner because i love this world of the data, and I meet your channel with the HR tableau proyect, and i want to say you, thank you for all that you do for us, you may one of the best inspirations that i have to dont cross my arms and say i can be a data analyst. Greetings from Argentina

[@martinberger365]

¿Y como te fue? Porque veo que hace tres años arrancaste a estudiar. ¿Ya estas metido en el mundo del data?

[@A4O_TSL]

@@martinberger365 Hola!, si en realidad hace casi 2 mejor dicho finales del 2022 empecé con pequeños tumbos por temas de tiempo, y el año pasado fue donde más le di fuerza a esto, a pesar de que aún suelo hacer algunos que otro proyecto me dedicó a la parte BI de una empresa donde vivo, siendo el encargado de la parte analítica y de negocios, y además sumado a que estoy en mí 4to año de carrera casi 5to, es difícil...mucho, pero se puede, siempre adelante sigue, es mí mejor consejo, desde los proyectos básicos y tontos hasta los que tu conocimiento avanzado llegue, no hay que hacer mucho a veces y otras hay demasiado, pero esto es asi. Saludos

[@martinberger365]

@@A4O_TSL cuánto me alegro. Bueno me encantaría poder hablar con vos porque quiero hacer el mismo camino. Hace un año que estudio e hice cuatro proyectos en Github

[@adwaitjawadekar1185]

Sir can you please make 1 video For subquery CTE its a highly asked interview questions.

[@DataWithBaraa]

Working on it

[@ragulmarley4900]

😊new subscriber add some videos beginner to pro sql for data analytics concept 😊 ... Kudos for ur efforts

[@DataWithBaraa]

Sure 👍

[@ahmedshalaby9343]

we need another video difference between joins and subqueries and related to the performance

[@durgabudhathoki]

Finally !!video is out.. waiting is over 🎉❤

[@LeonanielBalijon]

where can i find the dataset for this? so that I can practice... thank you

[@aabhasagrawal410]

sir can you suggest where can i practice sql questions to improve my understanding. Any set of questions

[@DataWithBaraa]

@@aabhasagrawal410 I suggest to interact with ChatGPT to practice and generate practice examples

[@aabhasagrawal410]

@@DataWithBaraa it will be very unstructured sir, i tried leetcode and all but the quality of questions is not at par there.

[@nothuman8989]

@@aabhasagrawal410 For , leetcode there are many other concepts left to learn , Best go to chat gpt any write a query there , I have learned sql subqueries and now i want to pratice it , give me 20 question that are most frequently asked in sql interview questions , that are realted to sql sub queries . Modify query according to your need .

[@aabhasagrawal410]

@@nothuman8989 oh thanks sir.

[@DGTransformer]

Hello Baraa, in tableau i want to link a dashboard with another external one.

[@NGKannur]

My another morning stuff. completed in one sit. Thanks Baraa💥💜 Whoever reading my comment, Please ensure subscribe the channel and support Baraa. Its just a matter of clicking a subscribe button there for we support motivate this person. I forwarded this to my fellow friends and colleagues and every ones liked the way he explain the topics. From Kerala, India

[@OPTIMUSPRIME-q8x]

time to sit and learn again 😅😅

[@DataWithBaraa]

@@OPTIMUSPRIME-q8x you always make me laugh with this comment 😂😂

[@upshow781]

If there was a way for me to like and subscribe 1000 time in your channel I will gladly do so. Dude, ur the best

[@DataWithBaraa]

Wow so nice of you thanks dear ❤️

[@rajshekar1362]

I'm really waiting for this video thank you Baraa 🎉❤