No video
Subquery in SQL | Correlated Subquery + Complete SQL Subqueries Tutorial
Рет қаралды 1,038,430
Күн бұрынVisit brilliant.org/t... to get started learning STEM for free, and the first 200 people will get 20% off their annual premium subscription.
This is the SQL Subquery Tutorial video which gives you a complete understanding of subqueries in SQL. We start with explaining what a subquery is and then writing a sample SQL query containing a subquery and then explaining how SQL processes a query statement containing a subquery.
In this video we shall also look at the different types of subquery in SQL by writing SQL queries which uses these different types of subqueries. We shall look at single row subquery, multiple row sub query, single column subquery, multiple column subquery and also the correlated subqueries.
This video will also explain about the different Clauses in SQL query where it is allowed to have a subquery and we shall look at example queries to explain these differences.
Finally, we will look at the SQL commands like INSERT, UPDATE and DELETE where it is allowed to use subqueries.
Hopefully, this videos gives you a complete understanding of what subqueries are, how to use them and where to use them.
My recommended SQL Course: learnsql.com/?...
[All the scripts and SQL queries used in this video is shared in my Discord server. You can join my discord by clicking on the below link. It's FREE]
Join my Discord Server: / discord
FTC disclaimer: This video was sponsored by Brilliant.
🔴 WATCH MORE VIDEOS HERE 👇
✅ SQL Tutorial - Basic concepts:
• SQL Tutorial - Basic c...
✅ SQL Tutorial - Intermediate concepts:
• SQL Tutorial - Interme...
✅ SQL Tutorial - Advance concepts:
• SQL Tutorial - Advance...
✅ Practice Solving Basic SQL Queries:
• Practice Solving BASIC...
✅ Practice Solving Intermediate SQL Queries:
• Practice Solving INTER...
✅ Practice Solving Complex SQL Queries:
• Practice Solving COMPL...
✅ Data Analytics Career guidance:
• Data Analytics career ...
✅ SQL Course, SQL Training Platform Recommendations:
• SQL Course / Training
✅ Python Tutorial:
• Python Tutorial
THANK YOU,
Thoufiq
@yogamayaa 2 жыл бұрын
Can we all take a moment to appreciate this guy, providing such amazing content for free? Hats off to you Sir. These videos are extremely useful for students like me :)
@mullaipugazhendi3236 Жыл бұрын
YES ,REALLY AWESOME VIDEO.
@yashpathak5837 11 ай бұрын
Q
@independentmotivatesupport8171 10 ай бұрын
Who care
@BCE_Abinash Ай бұрын
In he shared the file that he used in this video if yes pls share the link
@nilankanpal4454 28 күн бұрын
Has done really a great job, like a perfect point of revision before the exam
@MrBrunoPING 2 жыл бұрын
It's impossible to have a better video than this one about subqueries, here on KZfaq. I challenge someone to present me something at this level, of didactics, examples and duration. THANK YOU TEACHER! WILL FOLLOW YOU IN ALL YOUR VIDEOS!
@techTFQ 2 жыл бұрын
Thank you for the amazing feedback bro. I am so glad you found this helpful :)
@emrannoon2179 2 жыл бұрын
I 101% agreed Bruno. I love the way he explained
@emrannoon2179 2 жыл бұрын
@@techTFQ You are rocking bro
@veerabhadrarao258 2 жыл бұрын
Awesome
@enshk79 Жыл бұрын
You said didactics!!!!! Awesome. And I concur!!!
@minithyagraj6692 2 ай бұрын
For a first-timer in coding, I can say that I have understood how coding works and its all because of your brilliant way of not just explaining the queries but also explaining how SQL processes the code, which is truly amazing. Thank you and God bless!!
@Anonymous_it_is 2 жыл бұрын
I haven't seen explanation of this kind anywhere, even paid courses fail to teach this way. Kudos to you man! I can't thank you enough. Magnificent content!!! SQL learners need a teacher like you.
@techTFQ 2 жыл бұрын
Thank you Rohit. glad you liked it :)
@chaitalibanerjee5459 2 жыл бұрын
True
@rooja1000 Жыл бұрын
@@techTFQ u r such a true teacher.. who explains so clearly..n all concepts r actually easily understandable..learning so much from ur knowledge n way of teaching n explaining..thanks a lot...
@techTFQ Жыл бұрын
Thanks a lot Rooja 🙏🏼
@lasu5060 2 жыл бұрын
Since I started my new job I've been running away from subqueries. Whenever the query reached a certain level of complexity I referred it to the data scientist, this week I faced a challenge in which I will not be able to escape from the subqueries. I watched several videos and none reached this level of detail, mainly explanation. It will help me a lot. Thank you!!! Eternally grateful.
@atharvapathak3411 2 жыл бұрын
Man you are the most humble teacher i ever saw, 1) You make hard things look easy 2) You know exactly where people will have doubts and the pain of those ( Not only you revive that with solutions but also give precautions ) 3) You explain things again and again without any hesitation or showing an attitude which i love the most! Everyone can see how much you want to make things understandable and easy for all. I'm really looking forward for a ' Whole Advance SQL statements using Windows function and their applications' Video Using Timestamps, extract, rank in those cases is quite tricky and I'm sure you are an Aid to those! KUDOS To You With All The Respect! Keep doing the work you do, no one else is at this level and Humbleness 🤜🏻
@techTFQ 2 жыл бұрын
Hi Atharva , It’s really pleasing to read such feedback. Thank you very very much for your kind words.. truly appreciate it and I am so happy to know you find value in my contents 🙏🏼🙏🏼🙏🏼☺️
@visceralcinema 6 ай бұрын
I think what's most effective about your tutorials is you don't just execute simple sql statements to illustrate a point, you actually provide real problems and demonstrate your "approach" with solving them--they're almost like "word problems" from primary school. 🤭 This has helped me understand greatly how to breakdown (future) problems.
@vedanthasm2659 2 жыл бұрын
You are one of the best SQL tutor👍 I have seen. The best part is, you take one topic and cover everything in that (Full meals 😁). No need search any other content. Super helpful... Bro!
@techTFQ 2 жыл бұрын
Thank you Vedantha for this amazing feedback :) Really motivates me to make more :)
@sudarshanmhaisdhune1039 Жыл бұрын
The BEST video on subqueries on this platform. What a stuff this man have put in here. Legend!
@PrasanthKumar-pw9bk 3 ай бұрын
Stopped Surfing in internet about SQL and simply following your videos now. Its such a clear content that you deliver for us free. Thank you Sir!
@gokulnath4297 Жыл бұрын
One of the finest tutor I have ever seen, Going with the pace where the every concept is covered within a short time.
@bakhtavarhafeez702 2 жыл бұрын
The best subquery video I’ve come across on KZfaq. Simple and easy to comprehend.
@techTFQ 2 жыл бұрын
Thank you Hafeez. glad you liked it :)
@mahdi-saber 2 жыл бұрын
I have always used ORM tools to generate SQL queries, since I was afraid about complex queries. After watching your video three times, I feel quite confident to go deeper and write down complex native SQL commands. I wish you the best for such a thoughtful content!
@techTFQ 2 жыл бұрын
Thank you Mahdi :)
@victor_peral Жыл бұрын
The simplicity with which you broke down complex topics is a sheer gift Keep it up
@shilpikundu6279 Жыл бұрын
Never come across a better SQL teacher like you, every point sooo detailed! This is like a goldmine for SQL. Kudos to you for curating such awesome content!!!
@shaziasulthana9454 Жыл бұрын
super explanation haven't seen explanation of this kind anywhere, even paid courses fail to teach this way. Kudos to you man! I can't thank you enough. Magnificent content!!! Brilliant tutor thank you SQL learners need a teacher like you.
@mohammedshahil4898 2 жыл бұрын
A much needed one. Subqueries are the ones which i encounter the most in my work. And this video really helped me understand it even more clearly. Thank you so much Brother for yet another helpful video🙏🏻🙌🏻 👏🏻
@techTFQ 2 жыл бұрын
I am glad you liked it bro 😍 Thank you ☺️
@eealliance5997 Жыл бұрын
Please what kind of work? I hardly find jobs where you have to make constant queries to a database.
@snehasn91 Жыл бұрын
You are really good. I go through all your SQL videos whenever I need to go for interviews, and it always works for me. Here I am back again to watch your videos as I am in middle of a job search! Wish me luck. Thank you so much for these wonderful videos, they are the best!
@techTFQ Жыл бұрын
Thank you Sneha and wishing you all the best 👍
@ItsWithinYou 2 жыл бұрын
Superb! Thank YOU Taufiq for sharing this video. I could not find a better explanation of correlated subquery anywhere else. Now, I am very clear about this topic. I appreciate all your help!
@techTFQ 2 жыл бұрын
I am glad to hear that Rajiv :)
@dharaneeswaran4086 20 күн бұрын
I have attended many interviews confusion with this subquery and types and you just nail it...on the money. Thank you so much!!
@laurak5196 2 жыл бұрын
Yes!! So glad you covered this in such a detailed video. Can’t wait to watch! Thank you so much!
@techTFQ 2 жыл бұрын
Your welcome Laura 🙏🏼 Do give me your honest feedback after you watch the video..
@laurak5196 2 жыл бұрын
@@techTFQ I enjoyed it! I do have some thoughts tho but it will take me time to compile those and send. It was a crazy day. I think subqueries are the hardest thing left for me in SQL except that I need to get more practice with window functions and also the with clause. But for subqueries I always feel like there is so much more to them. This video is helpful but I’d like to see a more general one to explain the various use cases for the placement of subqueries in the various clauses. Your real world experience such as when you mention that this is something we do all the time or this is something that is really not recommended to do and then you explain why - those comments are very helpful bc I’ve never been in this field and you are a pro so those pro tips are so valuable. So the use cases for the different placements in select, from, and where and also the performance for those for me would be also useful to have a solid understanding of. You did explain use case and performance in some detail for correlated subqueries in this one which was very useful, but I personally would like to have a better understanding of when the subquery in the from vs select vs where clause is the best choice vs forgetting the subquery altogether and going with the with clause. So, in the real world how often do you use subqueries vs the with clause and best use cases for each. Maybe a video to encompass all of that. And I think that making it very clear that any subquery in the from clause must have an alias is something that beginners don’t necessarily always know so that could perhaps be emphasized. I love that you spent an hour explaining subqueries but I could see another video stepping back in more general terms being also very useful. I hope this was helpful. Thanks for all of your good work. I also like the new background. 😊
@laurak5196 2 жыл бұрын
@techTFQ I also want to add that I’m honored that you asked for feedback. I’m not sure if that was what you were looking for. I hope you have a nice night. 🙏🏻
@techTFQ 2 жыл бұрын
Hi Laura, I loved this feedback. Kind of gave me an idea for a future video which should clear your doubts about where to use subquery and when to use it. And not just subquery but in general how to apply any SQL concepts when solving problem using SQL. But first let me thank you for this amazing feedback because I am sure this took you a very long time to compile and write them down. I completely understand your point of view and its something that a few others have asked me as well. But the thing is that, the only way you can clearly understand "where to use a subquery and when to use it and what concept of SQL to use and not use when solving a problem", all these will get clear only with experience. You need to solve many many queries, only then you will get an understanding of what to use when. But yes, I can frame some tips and tricks which can give you a better idea of what subqueries to use and where to use them and when to use them based on what kind of requirement.. Just that I can explain these by hopefully solving different types of SQL queries. Let me try to plan a video revolving this and come up with some tricks and tips. And thank you for noticing the new background 😀 Bought a new camera and some lights and just starting to learn how to make better videos. Hopefully my video visuals and editing will get better with time. Have a great day Laura and Thanks again for your amazing suggestion 🙏
@laurak5196 2 жыл бұрын
@@techTFQ Thank You for taking the time to write such a detailed reply, Thoufiq. I’m so glad the KZfaq algorithm finally got some sense and started steering me to your channel. I’ve learned so much from you and I really appreciate your encouragement and guidance. It’s true what they say: You are the best SQL teacher on KZfaq. I can’t believe how your subscribers have grown since I found you at under 7K. This is a testament to your knowledge and experience and not only that but your way of explaining and your patience and clarity too, along with humility, which is rare and valuable as well. I hope and trust that all of your aspirations will become reality! And thank you again for your hard work. I’m so glad the feedback was helpful. I do so appreciate your feedback and tips for me too. Have a great night and hugs to your family 🙏🏻😀
@sourabhroy8731 2 жыл бұрын
Man...what an explanation. I have attended paid courses for SQL but never understood the concepts so clearly. Thank you so much and i will be soon joing your 3 Aug batch.
@techTFQ 2 жыл бұрын
Glad you liked it 🙏🏼
@jayeetadas6735 2 жыл бұрын
Bhaiya, your videos are just awesome. I was not good in sql. But I have started clearing interviews. Explanation is very nice and clear. Keep it up. Now step by step I will try to do it. Windows function video was really helpful. My concept is clear now.
@techTFQ 2 жыл бұрын
Thank you Jayeeta for your kind words :) Really happy to know my videos have helped 🙏
@abhigoswami6668 2 жыл бұрын
where were you my angel? I have attended multiple trainings for SQL but nobody explains the concept in the way you do!! Quality content with practical examples. Hats off to you for helping so many IT professionals to understand SQL in depth.
@rainbow100_ Жыл бұрын
Wanna ask what system management did he use in this video and what do use ?
@ndz7372 Жыл бұрын
@@rainbow100_ Pg admin on postgres
@sachinsuman8536 Жыл бұрын
Hi. Your videos are great. Thanks for the effort you are making just for us to learn. I really appreciate that. While solving the UPDATE related question, I think the answer should be this: update employee e set salary=(select max(eh.salary) * 0.1 + e.salary from employee_history eh where e.dept_name=eh.dept_name) where e.dept_name in (select dept_name from department where location='Bangalore') and emp_id in (select emp_id from employee_history);
@kennedymatanda4972 Жыл бұрын
I can download this video a thousand times just because of the quality of the presentation!. Good work bro.
@kaviyathamizharasan1451 2 жыл бұрын
Splendid Video Thoufiq !! 👏👏Neat and clear explanation of all the concepts. Types of Queries you did framed to solve in this video is like a cherry on the cake. Many thanks for considering our request and working on the same. TechTFQ and Thoufiq will surely be my go-to channel/person for SQL hereafter. I wish you should be recognized and appreciated by many subscribers very soon. Please keep doing the great work 😊🙏
@techTFQ 2 жыл бұрын
Thank you so much Kaviya for your amazing feedback :) I truly appreciate you taking time to leave this feedback. I am so glad you liked the content and than you so very much for your kind wishes :)
@kaviyathamizharasan1451 2 жыл бұрын
@@techTFQ Pleasure is all mine 😊🙏
@yashrajsingh9961 4 ай бұрын
This video was amazing, i really thing the free code camp audience would go nuts for this video, if you ever thing about donating this series
@surbhidaksh1549 2 жыл бұрын
Best Teacher with best Teaching methods and explaining each n every topic. Amazing content 😊👍
@techTFQ 2 жыл бұрын
Thanks a ton Surbhi
@ashutoshpandey1452 2 жыл бұрын
I had learnt sql from various sources...but no one can match up the with your tutorial. And I prepared for the job by watching your tutorial and successfully got the job.
@cynthiazhu473 Жыл бұрын
Subqueries are so tricky to me but this is by far the most detailed and comprehensive explanation on subquery that I've seen! Thank you soooooo much for that. Quick question on the total sales example, shouldn't we use SUM(quantity * price) to get total sales instead of just SUM(price)?
@softwarekabaapno1 Жыл бұрын
I'm guessing the price column represents total price and not price per unit.
@vuphan2956 Жыл бұрын
This is a greatest ever video about subqueries, very easy to understand and well explanation. Thank you so much!
@W3Fi Жыл бұрын
Sir, could you please make a video on elucidating when to use Join over Sub queries or vice-versa? Indeed, this is one of the major drawback for the beginner like me to deal with it in the initial stage.
@paulchukwuka6653 Жыл бұрын
You are just the best, just know that i am learning alot from you. Much respect from NIGERIA
@shohelkasamji11 Жыл бұрын
Your explanation is amazing, really love watching your videos as I get to learn so much and they’re not boring either. Thank you so much for sharing this. Keep up the amazing work. 👊🏽👍🏽
@damodardy5761 2 жыл бұрын
IT IS ONE OF THE BEST VIDEOS ABOUT SUBQUERY. THE EXPLANATION WAS CRISP AND CLEAR. THANKS FOR ALL YOUR EFFORTS
@techTFQ 2 жыл бұрын
Thank you Damodar.. glad you liked it
@shaffumehta1405 2 жыл бұрын
best content quality on this plateform ....amazing sir and god bless you sir and thanku so much for sharing your knowledge so deeply and nicely...it really helped a lot of students
@techTFQ 2 жыл бұрын
Thank you Shaffu 🙏🏼 Glad you liked it
@satishkumar-lh6kz 2 жыл бұрын
your teaching is much better than many celebrity trainers, great teaching, thank you for wonderful explanation
@SambitKuSahu 2 жыл бұрын
Thank you so much for your valuable info on subquery.
@techTFQ 2 жыл бұрын
Your welcome Sambit 🙏🏼
@rajeshjadhav2761 2 жыл бұрын
Best SQL video i have been through...The Way making us to understand and the language used can help even non tech guys like me to understand easily...Thank you so much... keep doing....
@techTFQ 2 жыл бұрын
Glad you liked it Rajesh
@Pankaj_Menaria_Bawa 2 жыл бұрын
Most awaited video I was waiting for...thank you sir.. following you on LinkedIn ❤️
@techTFQ 2 жыл бұрын
Thank you Pankaj 🙏🏼 I hope you like this one
@Pankaj_Menaria_Bawa 2 жыл бұрын
@@techTFQ yes sir it helped me a lot ❣️
@techTFQ 2 жыл бұрын
I am glad to hear that ☺️
@user-os7kd2bk8g Жыл бұрын
Almighty has saved my time in exploring here and there for learning sql and landed your youtube channel directly.
@yomtovaharoni Жыл бұрын
well detailed and great explanation of an important topic in SQL! I think there might be a mistake in the question with the number of units sold by each store. the average is (3+2+11+6)/4 and is far greater from 2 which you remarked :)
@MalayKhandkar Жыл бұрын
well noted! even i made that observation
@cypherecon5989 Жыл бұрын
Yes, I dont know why he made this mistake because in the avg(prive) exercise he said that you have to group them and then calculate the avg().
@youssefa7172 Жыл бұрын
@@cypherecon5989 in that example he said across all stores
@BabalolaMalik-jd5ut Жыл бұрын
I also observe that as well 👍 I think that's a mistake We should be left with 2 stores
@surajtiwari9078 7 ай бұрын
Yes ! As the avg price for all stores coming as 2200.0
@shivsharma9153 2 жыл бұрын
This is an amazing video..thank you for helping students like me!!!!!!!!!❤❤❤❤❤❤❤❤
@techTFQ 2 жыл бұрын
I am so glad to hear that Shiv .. Thanks for your feedback and I am glad this helped ☺️🙏🏼
@tamilarasic1159 15 күн бұрын
you are a GEM. I never find a place to learn all these variations of sub query. Much useful video. Thank you so much for this wonderful lecture.
@urvindarkaur0278 2 жыл бұрын
Hi , what an amazing effort!! THNAKS A MILLION!! Totally worth it. Also, kindly share the content notes if you have created for these stuff as it will be easy to practise alongside
@techTFQ 2 жыл бұрын
Thank you :) I have shared the dataset and all the scripts in my discord. link to join my discord is in video description
@pravinsonawane5799 9 күн бұрын
"Fantastic explanation! Your teaching style made the concept of subqueries so much clearer. I really appreciate the time and effort you put into breaking down the material. Thanks for another insightful and helpful video!"
@velap2129 2 жыл бұрын
Saving this to my folder and I am sure I m going to watch this multiple times... Going to be very useful... Thanks Btw, could you have a video explaining how to analyze the performance of different queries that accomplish same result but performance is different due to the way it is handled
@techTFQ 2 жыл бұрын
Thank you Vela :) I hope you like it. As for performance of different queries, ill make separate video about it.
@velap2129 2 жыл бұрын
@@techTFQ certainly, like all the videos you make. It really shows how much efforts you put into it to make it very clear to everyone. I'm in no way connected to sqls at work, but got interested at after seeing your videos.
@techTFQ 2 жыл бұрын
Amazing vela , I am so glad to read this .. Thank you 🙏🏼
@itikalaneelu9126 Жыл бұрын
i have gone through hundreds of videos on Joins but unable to get the knowledge. With just one video i became expert in joins :) this is because of you sir . Keep up the good work. I will be following your videos going forward. excellent explaination without any confusion.
@AsadAli-wi1xs 2 жыл бұрын
Sir please make the video on sql store procedure and trigger...
@techTFQ 2 жыл бұрын
Sure bro will do it
@Nura853 2 жыл бұрын
Thank you a lot! Your explanation is much more clear than the explanation from my online course. God bless you!
@pam9367 2 жыл бұрын
Thalaiva u r great... learned more thanks 🤞🙌
@techTFQ 2 жыл бұрын
haha Thank you buddy 😍
@Anilkumar-reddy 11 ай бұрын
Take a bow to these guy for him amazing work. Thank You Toufiq for all your videos. Please continue your work. will always support you
@harithaatla8937 2 жыл бұрын
thank you so much for clear explanation
@techTFQ 2 жыл бұрын
Your welcome Haritha 🙏🏼 Glad you liked it
@harichandrajaiswal8804 2 жыл бұрын
It's impossible to have a better video than this one about subqueries u are the best sirr
@techTFQ 2 жыл бұрын
Thank you :) Glad this helped
@readistreet9383 2 жыл бұрын
thanks a lot for the videos, you explain it very well!
@techTFQ 2 жыл бұрын
Glad you like them bro!
@manithsuy286 Жыл бұрын
I've been having such a hard time with subqueries on how to write them, understanding them, etc. You've helped a lot thanks.
@nisha6165 2 жыл бұрын
You are a great teacher 🎉 wonderful method of teaching 😀 pls try to be Active on this platform because a teacher like u is need for everyone.. If u know sql data tools kindly post it when u r free.. Thanks for the great work♥️ Because free education is the world's best education 🎈
@techTFQ 2 жыл бұрын
Thank you Nisha ☺️🙏🏼 I am glad you value my contents so much .. and yeah I want to post more video on KZfaq.. working towards it.. May I know what u mean by data tools?
@nisha6165 2 жыл бұрын
@@techTFQ Data tools like SQL SERVER INTEGRATION SERVICES (SSIS), ANALYSIS SERVICES(SSAS),REPORTING SERVICES (SSRS). Thanks for your reply 🎈
@techTFQ 2 жыл бұрын
Oh ok got it.. Noted and let me consider the suggestion
@nisha6165 2 жыл бұрын
@@techTFQ Thanks 😊
@glstnlev 2 жыл бұрын
You are the king. To me it’s the most difficult part of learning SQL. Thank you!
@techTFQ 2 жыл бұрын
Thank you Levon 🙏🏼 Glad you liked it
@saurabhrajput7482 2 жыл бұрын
Sir, please provide us with the same table are you using during the written query. Thanks for uploading this amazing video.
@techTFQ 2 жыл бұрын
Yeah I’ll share all these scripts in my discord server .. so you can join my discord using the link in video description
@saurabhrajput7482 2 жыл бұрын
Ok Thanks again 👏
@kamalbashir786 2 жыл бұрын
@@techTFQ Sir,when you share the script on Discord server. as I just checked I didn't found out script there
@techTFQ 2 жыл бұрын
It’s there in announcement channel.. U can ask other in discord if u can’t find it
@truptipatil6962 2 ай бұрын
HI techTFQ ,You made SQL easier to understand ,I am following you for SQL ,And I understood very well .Thank you 😃
@satheeshkumarak6708 2 жыл бұрын
@ 1:06:06 , in line number 164, I think it should set salary = (select salary + (max(salary*0.1)) Each Employee's salary should be incremented from his own salary and not from the maximum salary. The maximum salary is to be considered only for calculation of the increment. Am I right?
@techTFQ 2 жыл бұрын
Nope.. the question was to provide increment based on the max salary not considering each employee salary
@satheeshkumarak6708 2 жыл бұрын
@@techTFQ , so based on your logic, Sir, everyone from a department will be having equal salary, right?
@techTFQ 2 жыл бұрын
Exactly
@ashisoni6425 Жыл бұрын
A Big thanks to you. you make hard thinks easy in a single video this is extremely appreciable sir. thanks a lot...your explaining each and everything without timewasting short and easy I'm not gonna forget subqueries in my whole life after watching these. this free video in my paid course i didn't learn like these again thanks a lot.........
@Zenith40450 2 жыл бұрын
Nice explanation...Helpful content...👍👍👍
@techTFQ 2 жыл бұрын
Thank you Ambar 🙏🏼
@greentechkey Жыл бұрын
Best SQL content so far. You have made sql easy and understandable
@mangeshputran6593 2 жыл бұрын
Thank you for the amazing content.
@techTFQ 2 жыл бұрын
Your welcome bro. glad you liked it
@hiulaicheng3781 Жыл бұрын
This is the best SQL video I have ever seen. Thx
@aurojitmishra2542 2 жыл бұрын
Timestamp 55:30 The average will be 5.5 (11+2+6+3/4) . But the query resulted as 2.2. Any thoughts?
@aryar7510 2 жыл бұрын
Even I have the same thoughts
@techTFQ 2 жыл бұрын
It is 2.2 because it is the avg of quantity from the entire sales table.. You avg of 5.5 is the avg when considering the group by query .. Difficult to explain in comment but if you read the query statement properly and try it out yourself, you will come to know
@aurojitmishra2542 2 жыл бұрын
Thanks for the explanation 🙌
@paulhowrang 2 жыл бұрын
@@techTFQ True but it defies logic, if we have multiple entries of the same store, you cant take average without summing from individual stores, moreover, this cant be just ignored because it is for learning purpose, the query will become more involved, to a more attentive student current case seems confusing
@yoo0angg Жыл бұрын
I noticed this right away as well. I am very much an SQL newbie but the average of 2.2 is taking the full sales table into account with multiple store rows and not aggregating the total sales for each store. It is incorrect. You have to take the average using the group by clause.
@sourabhchoudhary8908 Жыл бұрын
this is really really great best explanation on subqueries
@fathimafarahna2633 2 жыл бұрын
Amazing 👏
@techTFQ 2 жыл бұрын
Thank you 😍
@sreenivas351 2 жыл бұрын
Your channel is the best bro better than Coursera courses you deserve more subscribe made concepts clear thank you so much 💥
@techTFQ 2 жыл бұрын
Thank you Sree
@kushagrasharma5944 2 жыл бұрын
Please can you share the dataset
@techTFQ 2 жыл бұрын
I have shared the dataset in my discord channel. you can join my discord using the link present in video description
@user-mh3mw7fk9w Ай бұрын
it was an amazing tutorial, all the subqueries were in a single video. learnt a lot, it will take time to process all these.
@nileshkewalya1 Жыл бұрын
Well Explained. Looking at these queries after a decade, I was searching for something which would explain in a simple language and w/o confusing! Kudos to you... 👏👏👏
@hemujagwan3573 Жыл бұрын
Best teacher for learning SQL ...in KZfaq . Thank you guru ji 🙏🙏🙏
@itikalaneelu9126 Жыл бұрын
This video is far far better than any videos in entire youtube
@jatinyadav8960 2 жыл бұрын
Best video on practical Implementation of Sub Queries on KZfaq
@techTFQ 2 жыл бұрын
Thank you Jatin
@shivambajpai5919 Жыл бұрын
super video on SQL subqueries . A complete take on subqueries with practical examples. Definitely the Best Video on whole youtube even better than paid classes .
@chandrikalakshmikandan8895 Жыл бұрын
First of all thanks to explain in deeply in this concept. You make hard things to teach in easy way. Hats off to that.
@laurak5196 Жыл бұрын
Wow, Thoufiq!! Look at you go, almost 200K! Well deserved, my friend, and so happy for your success!
@techTFQ Жыл бұрын
Thank you Laura ☺️☺️☺️ Always special to read your well wishes 🙏🏼
@supersql8406 Жыл бұрын
Fantastic! This video even helps professionals SQL writer like me who needs a quick refresher!
@arunsingh768 2 ай бұрын
U r really a good mentor on SQL. Very good concept. I have learnt to many things from ur vedio
@mrdiegorio 9 ай бұрын
Kudos to you, I am so impressed with your SQL Tutorials. They are really amazingly well explained, and technically really excellent. Thank you for sharing this free resource with the community.
@techTFQ 8 ай бұрын
Welcome and glad it helped
@RecordColl 2 жыл бұрын
Thank you! Using the EXISTS with a subquery has helped me resolve a report request that was stumping me.
@techTFQ 2 жыл бұрын
Glad to hear that :)
@PeterPan-hs5tu 10 ай бұрын
oh boy❤ hands down the best advance sql tutorial i have seen in hundreds of sql related lesson. this is the bread n butter of what sql is all about. thank you 🙏 buddy for putting this out. Super informative and essential. 🍸
@kopilkaiser8991 4 ай бұрын
Your video has been very useful. Thank you so much for such an informative and useful video which cleared my clouds around innerQuery/subSquery. Even the correlated subQuery was a complicated topic which I wasn't understanding. But again, thanks to you and I'm so grateful to you for being able to clarify my confusion and now I will be able to write SQL queries better :)
@dominiktokarski8054 Жыл бұрын
I'm just in 1/3 of this video but I need to smash like button right now because your video perfectly teach in easy way many concepts I thought were much harder to learn. Keep doing content like this brother.
@ayanSaha13291 2 жыл бұрын
I must say, your teaching techniques are extraordinary. Thank you.
@techTFQ 2 жыл бұрын
Glad you liked it Ayan
@aesthetic_muscle 2 жыл бұрын
your lecture was too smooth and very comprehensive . Thank you for this wonderful video
@techTFQ 2 жыл бұрын
Thank you Punith :)
@cozimbatman4100 Ай бұрын
Thank you for being so thorough. You sir have earned my subscription
@Beant1980 2 жыл бұрын
The best Video on KZfaq for -> Correlated Subquery, Thanks
@techTFQ 2 жыл бұрын
Glad you think so! Thank you :)
@itsnature5391 Жыл бұрын
hey man only person on youtube to teach sql so simplistically
@techTFQ Жыл бұрын
Thanks buddy , glad it helps
@glorysowji9218 2 жыл бұрын
No words how to appreciate you TFQ, really this is a fabulous, spectacular video explaining all possible ways that are used in SQ. Thank you so much. Though I'm new to IT Sector your videos are helping me a lot in understanding the concepts. Previously I used to have N no, of doubts, but now you cleared all my doubts. I literally very much appreciated the videos that you are making. Very much useful for Non-IT Students/Employees. God Bless You.👌👌🤝🤝. I really like the way you teach the concepts. Helps me to practice more. Plz help me to get the datasets used in this video. I tried using links but couldn't find them.
@ayush.pratap.singh. Жыл бұрын
@techTFT - i am also in the same boat. Can you please upload where we can find this dataset. so that we can practise more about it.
@brigienshilpa8034 Жыл бұрын
Awesome thanks a lot ,i had lot of doubt in subquery but after watching your video i am confident that I too can write query using subquery
@rakhiyadav7977 2 жыл бұрын
Perfectly explained every usage of subquery. Great work..Thoufiq..!
@techTFQ 2 жыл бұрын
Thank you ☺️ 🙏🏼
@ravi184 Жыл бұрын
It is one of the best video classes, I learn something in such a short time. Everything is clearly explained by you regarding the subqueries. Thank you for the videos
@lakkudawargave 4 ай бұрын
On u tube no one explained the example about executing subquery with DML command but u done it , thinks 4 that✨️✨️🤝
@PreciousAfricanStoryz Жыл бұрын
You are simply the best here on KZfaq. Thank you so much no one does it better than you. Your videos has really helped me
@JerryJonesIndia Жыл бұрын
Awesome. Explained in such a simple way, even a person who is new to SQL can understand very well!!!
@aniketsonmali6672 5 ай бұрын
THE BEST SQL TUTORIAL AVAILABLE ON YT 💯💯💯
techTFQ
Рет қаралды 559 М.
Thu Vu data analytics
Рет қаралды 202 М.
techTFQ
Рет қаралды 973 М.