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
Thanks a lot, Baraa! I was struggling with subqueries and watched almost all the available videos on this topic on TH-cam, but I didn’t understand a word. However, after watching your entire video, I can finally say that I’ve understood this topic clearly! Thanks again, and wishing you the best!
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
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 TH-cam. THANK YOU FOR UR EFFORTS
Awesome! the best TH-cam 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.
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! :-)
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 !!
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 TH-cam algorithm for bringing me here.
This was such a masterpiece. No one can explain such complex things better than you. I got the full and deep understanding of subqueries and they seem very useful. Thank You so much Bara i am so grateful to you ❤
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 .....❤
Amazing tutorial Baraa sir. After watching this amazing marathon video on SUBQUERY, I'm little out of words for appreciation. Speechless!!! In your every single tutorials, you're not leaving any moment to surprise me. I really appreciate your effort of building Database (SalesDB). Most complete Databse to learn each and every single concept. &&&& Baraa sir's Behind the scene analysis is pure GOLD DUST. 🌠🌠🌠 Very meditative course sir. !!!!!!!!! my curiosity to start project is increasing day-by-day.... Thank you, Baraa sir.
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
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.
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.
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 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 TH-cam. Also, do one on "pivot table"
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.
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.
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 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
@@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
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 ❤❤❤❤❤❤
Is it possible to get the same result without applying the subquery? SELECT PoductID, Price FROM Sales.Products WHERE Price > AVG(Price) As price and the calculated average price are information within the same table.
@@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 .
1:13:00 For exists subquery, select 1 sounds like "return True". I am curious whether SELECT 0, returns true or false. Because it will return a value but 0 usually means "false". I am gonna give it a try and comment.
SELECT 0 DOES the exactly same thing what SELECT 1 does. It is interesting to me that the thinking process of sql that is so different than programming languages like python or C. It requires another way of thinking
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
Please guys, if you wanna learn real raw SQL subscribe to this guy tutorial, he is indeed SQL Wizard , He actual architecturised the structure of the said SQL. This training is marvellous. Thank you Baraa
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
Nobody on the internet has explained this topic in such a concise and clear way but you did and thank you for that Baraa.
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
Thanks a lot, Baraa! I was struggling with subqueries and watched almost all the available videos on this topic on TH-cam, but I didn’t understand a word. However, after watching your entire video, I can finally say that I’ve understood this topic clearly! Thanks again, and wishing you the best!
Glad it was helpful!
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
Wow amazing 🤩 I will do soon
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 TH-cam. THANK YOU FOR UR EFFORTS
One of the best channel on TH-cam to learn SQL..!
just wanted to thank you because of your videos I have passed the interview
Awesome! the best TH-cam 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.
highest quality video on subquey ever made
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! :-)
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 !!
Great video, could have never understood corelated subquery without this video. thank u so much !!!!!
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 TH-cam algorithm for bringing me here.
Thank you so much for the kind words! I’m thrilled you’re enjoying the content and finding it engaging. Glad the algorithm brought you here! 😊
This was such a masterpiece. No one can explain such complex things better than you. I got the full and deep understanding of subqueries and they seem very useful. Thank You so much Bara i am so grateful to you ❤
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.
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 .....❤
Amazing tutorial Baraa sir.
After watching this amazing marathon video on SUBQUERY, I'm little out of words for appreciation. Speechless!!!
In your every single tutorials, you're not leaving any moment to surprise me.
I really appreciate your effort of building Database (SalesDB).
Most complete Databse to learn each and every single concept.
&&&& Baraa sir's Behind the scene analysis is pure GOLD DUST. 🌠🌠🌠
Very meditative course sir. !!!!!!!!!
my curiosity to start project is increasing day-by-day....
Thank you, Baraa sir.
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
Here we go again, this channel is all about uplifting yourself to the world 🎉
Your channel is magnificent, it really helps many people especially beginner to be a master in SQL. Great job!
Sir i am big fan of your teaching
Excellent work 👏👏👏
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.
Glad to hear that
Thank you so much sir, you have explained it really well, loved your teaching method
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.
Thank you Baraa, Completing this tutorial with practice, revision and notes making.
a correlated Subquery is like a magic 🪄
Thank you Baraa for your explanation of this hard topic!!!
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.
Great suggestion!
@@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 TH-cam. Also, do one on "pivot table"
BEST EVER TEACHER I MATE IN MY LIFE 🎉🎉❤❤. KEEP IT UP SIR.
PLEASE HAVE FULL TOPICS COVERED ON SQL, TABLEAU, POWER BI 🎉🎉🎉
Love love love for making sql so interesting with your teaching style!!
Glad you enjoy it!
Thank you so much. You are amazing. Whit, your calm voice and comprehensive explanation make the material easier to understand.
Never seen a person who can simplify things this easy
Thanks 🙏
Baraa, thank you for your knowledge and quality work, this is the best course on SQL!
I've been waiting bro, came at a right time. 🎉
Thank you, Baraa Today I have learnt the concept of subqueries properly
cool video, really good tutorial, explained well, audio and visuals are perfect, will check out more of your videos. 😀
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?
BARA IF U GET A PYTHON COURSE FOR DATA SCIENCE IM SURE THIS CHANNEL WILL BE THE MOST POULAR CHANNEL ON TH-cam WAITING FOR UR NEW COURSE LOVE YOU
That's the plan!
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.
Iconic Explanation ❤
Another great video, you are a true teacher. Thank you
I appreciate that!
Thank you for your kindness sharing your knowledge ❤❤❤❤❤
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.
I hope in October I would cover the whole course, working now on sql projects. Good quality needs time
@@DataWithBaraa Thanks Baraa for the quick response. Yes it does take time to make quality content. Will be waiting for the new videos.
Wonderful Baraaaaaaa 👍
we need another video difference between joins and subqueries and related to the performance
I am really waited for this video.. thanks
Hurrraaaa🎉🎉🎉🎉❤❤❤❤ i was waiting for it
I was having hard times with subqueries, well this guy came second to Jesus
Ty so much man !
I was waiting for this video, thanks :D:D:D
like always great knowledge ...
Keep making such informative videos Baraa
I will try my best
Awesome sir ❤❤
Great content, Thank you!
Thanks 🎉
Yeaaahhh SQL Subquery letsgooo!!
Good explanation
The best explanation!
Glad you think so!
so informative sir..a request from your student can you please make videos on python for data analytics
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
¿Y como te fue? Porque veo que hace tres años arrancaste a estudiar. ¿Ya estas metido en el mundo del data?
@@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
@@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
بارك الله فيك
Nobody does SQL like Baraaaa! 🎉
Thank you sir ❤
Thanks sir for such a valuable content❤❤
So nice of you
@@DataWithBaraa ❤❤
Hey Baraa, I really enjoy your videos.
Can you please make a Tutorial Video on power BI?
Always on top ❤👌
❤️
Thank you Baraa..😊
Thank you once again Bara...
you are absolutely the best teacher ! but why did you edit the nescafe mug as if there is hot drink in it. Lol
please make video on recursive cte
Thank you so much ❤
You're welcome 😊
There is one more video left. After that CTE will come for which I am waiting.
Yes. Me too 😊
Great video as always Barra
Thank you 🤗
Thank you Baraa!
❤from india❤
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 ❤❤❤❤❤❤
How do you edit videos and add animation? Its amazing
CAN U ALSO COVER A TOPIC CALLED INDEXING AND TRIGGERS IN SQL ITLL MAKE IT COMPLETE THANK U THOUGH BARA
Hi Baraa! How many clips do you want to do tutorial? Thanks to make me understand sql better.
Hi...
Will you pls make one complete playlist for data analyst...
Thank u in advance
Yes, soon
Will be looking for your Tableau too. Thanks ,we are waiting for your Python lesson Baraa.
😊new subscriber add some videos beginner to pro sql for data analytics concept 😊 ... Kudos for ur efforts
Sure 👍
Brother, please provide the presentation notes for the lectures. It will be really helpful
Can you please add the dataset you use along with your videos so we can practice and try along with it. thanks
It is already available check the substack the link in my description
Sir can you please make 1 video For subquery CTE its a highly asked interview questions.
Working on it
Hey Bara , which dataset you've used . can I get a lik of that.
Is it possible to get the same result without applying the subquery?
SELECT PoductID, Price
FROM Sales.Products
WHERE Price > AVG(Price)
As price and the calculated average price are information within the same table.
where can i find the dataset for this? so that I can practice... thank you
Please which screen recording software do you use?
Obs
Finally !!video is out.. waiting is over 🎉❤
sir can you suggest where can i practice sql questions to improve my understanding. Any set of questions
@@aabhasagrawal410 I suggest to interact with ChatGPT to practice and generate practice examples
@@DataWithBaraa it will be very unstructured sir, i tried leetcode and all but the quality of questions is not at par there.
@@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 .
@@nothuman8989 oh thanks sir.
1:13:00 For exists subquery, select 1 sounds like "return True". I am curious whether SELECT 0, returns true or false. Because it will return a value but 0 usually means "false". I am gonna give it a try and comment.
SELECT 0 DOES the exactly same thing what SELECT 1 does. It is interesting to me that the thinking process of sql that is so different than programming languages like python or C. It requires another way of thinking
Hello Baraa, in tableau i want to link a dashboard with another external one.
how do i get this database?
time to sit and learn again 😅😅
@@OPTIMUSPRIME-q8x you always make me laugh with this comment 😂😂
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
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
Wow so nice of you thanks dear ❤️
I'm really waiting for this video thank you Baraa 🎉❤
Please guys, if you wanna learn real raw SQL subscribe to this guy tutorial, he is indeed SQL Wizard , He actual architecturised the structure of the said SQL. This training is marvellous. Thank you Baraa