Subquery in SQL | Correlated Subquery + Complete SQL Subqueries Tutorial

preview_player
Показать описание

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.

[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]

FTC disclaimer: This video was sponsored by Brilliant.

🔴 WATCH MORE VIDEOS HERE 👇

✅ SQL Tutorial - Basic concepts:

✅ SQL Tutorial - Intermediate concepts:

✅ SQL Tutorial - Advance concepts:

✅ Practice Solving Basic SQL Queries:

✅ Practice Solving Intermediate SQL Queries:

✅ Practice Solving Complex SQL Queries:

✅ Data Analytics Career guidance:

✅ SQL Course, SQL Training Platform Recommendations:

✅ Python Tutorial:

THANK YOU,
Thoufiq
Рекомендации по теме
Комментарии
Автор

It's impossible to have a better video than this one about subqueries, here on YouTube. 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!

MrBrunoPING
Автор

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

yogamayaa
Автор

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 🤜🏻

atharvapathak
Автор

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.

Anonymous_it_is
Автор

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.

lasu
Автор

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

minithyagraj
Автор

One of the finest tutor I have ever seen, Going with the pace where the every concept is covered within a short time.

gokulnath
Автор

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!

vedanthasm
Автор

The BEST video on subqueries on this platform. What a stuff this man have put in here. Legend!

sudarshanmhaisdhune
Автор

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.

visceralcinema
Автор

The simplicity with which you broke down complex topics is a sheer gift

Keep it up

victor_peral
Автор

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

shilpikundu
Автор

The best subquery video I’ve come across on YouTube. Simple and easy to comprehend.

bakhtavarhafeez
Автор

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. 👊🏽👍🏽

shohelkasamji
Автор

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!

PrasanthKumar-pwbk
Автор

This is a greatest ever video about subqueries, very easy to understand and well explanation. Thank you so much!

vuphan
Автор

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!

mahdi-saber
Автор

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🙏🏻🙌🏻 👏🏻

mohammedshahil
Автор

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.

ashutoshpandey
Автор

Best SQL content so far. You have made sql easy and understandable

greentechkey