Advanced SQL Tutorial | Subqueries

I have enjoyed your videos. I have been programming and working as a dba for a long time, 28 years - since sql server 4.2. (Do you remember *=). I would consider myself an expert in sql server. I was even able to pick up a couple things in your sql videos that I didn’t know or at least did 8n a different way. Great job. Looking forward to the python and newer content. Working towards learning how to use ML to help clean data and find errors over the next year.

Excellent Tutorial

Instead of doing WHERE EmployeeID IN (SELECT EmployeeId FROM EmployeeDemographics WHERE Age > 30), you could do WHERE EXISTS (SELECT EmployeeId FROM EmployeeDemographics WHERE Age > 30 AND EmployeeDemographics.EmployeeId = EmployeeSalary.EmployeeId). No? Which one is more efficient.

that was really quick

I'll stop here at DAY-4

Still confusing AF, but I think I will get there at some point. Thanks!

I just finished the SQL tutorial from beginner to advanced. Now I want to start the portofolio project but part 2 & 4 of that video are missing. Let me know when those video already uploaded. thank you very much and sorry if there's something wrong about this comment, I'm still learning English

Where this may be good for beginners I was hoping for some actual advanced queries. These were sort of common sense basic IMO. Where I work they have some COMPLEX subqueries and I was hoping to get something even remotely similar. But i'm just not the target audience for this video obviously.

How do you do this on MySQL or MariaDB?

Hey Alex! All your videos on Sql Tutorials are awesome! Can you make a video on how to use primary and foreign keys in Sql Server? You've mentioned in one of your videos that you'll be covering those topics but I haven't come across the PK and FK in the Sql Tutorials(maybe I've missed them). Or if you have a video already out, could you direct me to it? Thanks for all the videos, they've helped me understand SQL Server much better!

Thank you so much, Alex. Your videos are superb.

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.

Thanks it was helpful!

question. i'm confused why does GROUP BY not work when writing subqueries? i didn't quite understand..

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.

Thanks Alex!

How about doing an AVG SALARY for each employee instead of AVG FOR ALL? How do you query that?

Hi Alex! I'm following you in LinkedIn. Pls, keep me post it about the data analyst bootcamp you plan to launch. I, myself I am changing career. I want to be more technical marketer with strong focus on web analytics and touching here and there analytics subjects....

Take a shot everytime you hear " really quickly" and try to survive

Great content Thanks