Advanced SQL Tutorial | Subqueries

In today's Advanced SQL lesson we walk through how to use Subqueries.

____________________________________________

SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________

RESOURCES:

Coursera Courses:

Udemy Courses:

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________

SUPPORT MY CHANNEL - PATREON/MERCH

____________________________________________

Websites:
____________________________________________

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

[adityapandey]

The entire, Beginner, Intermediate, and Advanced playlists are a gold mine, Alex!
Thank You!!!

[usuallyclueless]

I have a Coursera certificate in MySQL, but you've explained it so much better than the instructor of that course.

[damasusaditama]

All your SQL tutorial videos from the basic up to this have helped me understand SQL, MUCH BETTER compared to the explanation that I've got from a bootcamp. Your explanation is so complete and concise. Thank you so much, Alex!

[halildurmaz]

Perfectly clear explanation. However, I also noticed wrong information:
 
7:17 You said, "In your Subquery, you can only have 1 column selected". However, you can select multiple columns by using parentheses WHERE (a, b) IN (SELECT a, b FROM x)

[marcellaperkes]

Thank you Alex! 🙌 For the last year I’ve been learning about data analysis/computer science part time, with the goal to move into the tech industry so that I can WFH, be available to my kids, and have income growth potential. Your videos were fundamental to my learning. I just landed my first job in the industry, and I attribute a big part of that to you.

[ninahbae]

Today i have completed SQL😩😩🥰❤️ Am so grateful for having found your channel, i believe by 2024 i will land a data analyst role in government or health care all studying from this bootcamp from scratch🙏🙏🙏 never been as committed, thank you so much once again, tomorrow am starting off with Python

[jjsinclair]

This has come just in time for an interview I have in the morning for a modelling analyst position, can't begin to describe how much your videos have helped! Keep up the crazy good work you are doing here!

[ThiagoSimoes]

I thought I knew SQL, but this whole series of videos help me understand that I don't know anything. Although your explanation was ease to follow and understand, I feel that need more study to really understand all the concepts.Thanks a lot for your time to make this series.

[davidcorona]

Holy mackerel! We think and code exactly the same.This is exactly how I teach people about sub-queries, and partition by, and even the rarely used 'right join' which is similar to 'not in' where clause sub-query.

[yanirhaim]

Thanks for the great tutorial! Currently on my Google Data Analytics Certificate! This video made it easier to understand the concept!

[loose.electricity]

Just finished this series, thank you so much, you've re-ignited my passion for learning again. These simple, clear explanations of concepts has given me the confidence to dive back into more advanced concepts again.

[stultuses]

Excellent, someone who knows how to zoom in for those watching on mobile!!!!

[salikmalik]

Your videos are good Alex.
We need a playlist of SQL needed for data science. Its a request. :)

[ekinci_io]

As someone who received SQL training during master's degree, I have to say that I learned much more from Alex's SQL lessons than what I learned at school. You are amazing Alex!

[akj]

Thanks for letting us know that for a subquery in the SELECT and WHERE clauses; it can only have a single value and single column respectively as an output.

[flyeagle]

I Am glad I followed the whole series of SQL tutorials from easy to advanced. Now I am clear on the concept. Now I am going to follow a real-world project of yours.

[Alexdasilva]

I've just finished this series (1 week). I'm going to rewatch it all again (hopefully 1 day) and then start the Portfolio Project. I started from 0 and your videos are purely useful content, it made me understand SQL really fast.
Thanks from Spain.
PD: I will communicate here when I finish the course completly and also if I am lucky enough to get a job.

[matheuspegorari]

I love your videos, content is never enough. I know sometimes may be obvious to talk about something like subqueries when we have lots of content in the internet, but your explanation is very pertinent and very didatic, i learned a lot today. For this I thank you.

[frgvvkt]

Thanks Alex for teaching Advance SQL REALLY QUICK.

[melissaleigh]

King, you are the best sql teacher on youtube. Thanks SO much for making content on sql concepts that are actually used in everyday work flows.