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!
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)
I cannot speak for MySQL course cause I haven't attended it but, having attended other technical Coursera (and Google, too) Courses I fet a little bit disappointed regarding the content. Definitively, too much bla bla bla and little practical approach.
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!
@@alexter001122 yes. I finished my bootcamp in Sep-2021, then applied for a data analyst position at various startups, did some interviews, and started working as a data analyst in Feb-2022.
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
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.
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.
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.
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!
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.
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.
I just finished the Beginner, Intermediate, and Advanced SQL videos. Thank you, Alex, for publishing these. I'm adding SQL to my tool belt. These were a fantastic first look at the language.
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.
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.
Done for SQL Tutorial after 3 weeks of learning and spending 2-3 hours in each session while creating different scenarios outside the samples. hehe Mygee! I made it! haha! Thank you Alex! Next step is to get a certificate of SQL before proceeding to the other Tools. Hopefully I'm doing it right. Lol
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.
Thanks so much for these tutorials! I had a basic understanding of queries in ArcMap for GIS data and didn't understand why it was really that important but now thinking of it as having a database that has pre-made queries that can be manipulated in different ways to process and analyze data has made me understand its importance!
Thank you so much Alex! I went through the basic, intermediate and advanced SQL Tutorials. I would love to learn more about the store procedures in detail!
Thanks for giving such a clear and concise explanation for why one would use subqueries! I'm currently working through the Google Data Analyst certification program and your explanation and approach was much easier to understand than the instructor who presented on this very topic.
Brilliant SQL Tutorial Series! Every Video has really helped to fill in any potential gaps in my knowledge and even reinforce my existing skills. Thanks Alex!
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.
You posted a tutorial on CTE before this. I am following from the older videos to the newer ones so I got lost for a bit and had to come find this. Thank you for making learning easy
Thank you for your work and detailed explanations Alex. I mainly use COGNOS and COGNOS SQL so this is a great crash course for me to learn the differences between the two.
Thank you for sharing, really really appreciate this. I would love to see more advanced stuff, specifically examples where you're using synonyms across different servers within source stored procedures (used to populate stage tables) to make joins along with ctes. I am at an internship right now, and still in my first year of college, I feel completely lost when working in these health insurance databases, most videos on youtube don't really go into more complicated stuff that I work with everyday so thank you again Many of these queries in the code base are 3000+ lines long and my brain goes numb looking at all the subqueries, joins, and obscure functions I have no idea what they do
Hi! I just tried the syntax for subquery in where but I tried it also using join and got exact result *Alex subquery in Where* select EmployeeID, JobTitle, Salary from EmployeeSalary where EmployeeID in ( select EmployeeID from EmployeeDemographics where Age > 30 ) *my syntax*: select demo.EmployeeID, JobTitle, Salary from EmployeeDemographics as demo join EmployeeSalary as sal on demo.EmployeeID = sal.EmployeeID where Age > 30 Anyway, I find your tutorial very informative and tried to use some work arounds if they will have the same output. Thank you always, Alex!
I just learned this recently! Wonder do you have any recommendation for an intermediate level courses after the beginner course? I'm 75% done with my SQL beginner course. Thanks! :)
Hey Alex thanks for making videos which are so informative and helpful..as a mechanical engineer who wants to change his profession to data analyst ..what will u suggest to learn first
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
This looks like a really interesting subject. I didn’t know anything about it until now, but I suspect the exponential, geometric, and weibull distributions might factor in?
Hello Alex, why did you create the subquery when to get the average you could have just specified : "SELECT EmployeeID, Salary, (AVG)salary FROM EmployeeSalary"? I am really confused and would be glad if you could help.
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!
In the last query, you used a subquery in the WHERE clause to filter for employees over 30. Could you also have accomplished that by joining the two tables and adding a WHERE EmployeeDemographics.Age > 30?
Agree Veronica, in that case we could use it in a join table. However, I believe using the subquery in the where clause is much faster than joining in this case. Maybe Alex could confirm that?
Hi Alex. Thank you very much for this series of videos. For me, your method of teaching is easy to follow and understand. Are perhaps you going to produce a tutorial on Goolge's Looker too in the near future?
Very helpful, thank you. Is there a way to find out the input parameters of a stored procedure, that someone else may have created, w/o using the "modify" option?
Your content is awesome, Alex! Thanks for all the videos! I don't know if you've answered this before, but I need to ask: how can I show my SQL skills in a portfolio project? Showing Python code with all the EDA and data viz is ok, I can do it, but I always have a hard time figuring out how to show employers that I know SQL (it seems like all they care about is if I've used in a job situation, which I haven't had the chance to). Any tips on that? Thanks again!
It's a good question. I'm kind of in the same situation than you. Personally, what I'm trying to do is simply looking for datasets online then trying to make my own project. You can for example find free datasets in SQL server website or Kaggle but I agree with you that it's not that simple. Hopefully Alex will answer this comment.
Hi there! great content!! Just to know, in a working place, how often is a subquery used compared to the join function? As both can give the same result.
Hello teacher where can I load those data to practice following your explanations? Thank you
Год назад
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....
Hey,i love your videos! I have a question though. In your last example you can simply do the normal query and filter using "WHERE Age>30" and still get the same results, right? If yes,then why do we need to use WHERE sub query?
Hi Alex thank you for your work great tutorial. Today I had a test in SQL for a company it was so hard. Do you know a good platform to train myself with exercice ? I mess this interview but I really would to do better next tile
Just to clarify, only the where statement combined with the subquery can only have 1 column selected? SELECT and FROM can select all columns if wanted from a subquery? thanks!
The entire, Beginner, Intermediate, and Advanced playlists are a gold mine, Alex!
Thank You!!!
Glad you like them!
where is advance sql playlist
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!
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)
I have a Coursera certificate in MySQL, but you've explained it so much better than the instructor of that course.
I cannot speak for MySQL course cause I haven't attended it but, having attended other technical Coursera (and Google, too) Courses I fet a little bit disappointed regarding the content. Definitively, too much bla bla bla and little practical approach.
I'm taking that course right now. Have to heavily supplement it with the mode tutorial because the actual course lacks soooo much detail and examples!
Same. Taking a 4 week class from Coursera and i was stuck on week 3 where the instuctor teaches subquiries and joins. Hope this video will help
@@tasadem20 I’m having the same problem in week 3, I couldn’t understand the instructor and she didn’t not explain correctly
I have the same issue on datacamp, before I realised I was already doing nested subqueries and CTEs 💀
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!
Really glad to hear it! :D
Question: were you able to land an analyst job after finishing your bootcamp?
@@alexter001122 yes. I finished my bootcamp in Sep-2021, then applied for a data analyst position at various startups, did some interviews, and started working as a data analyst in Feb-2022.
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
wish you all the best in your journey. consistency is key 💪
How is it now????
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.
How was your journey now? Mind sharing us your experience?
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.
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.
Excellent, someone who knows how to zoom in for those watching on mobile!!!!
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!
best of luck and i hope you celebrate with us when you get it. cheers
did you get that job ?
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.
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.
Thanks for the great tutorial! Currently on my Google Data Analytics Certificate! This video made it easier to understand the concept!
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.
I just finished the Beginner, Intermediate, and Advanced SQL videos. Thank you, Alex, for publishing these. I'm adding SQL to my tool belt. These were a fantastic first look at the language.
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.
do tell
How is it now?
@@mizerosamuel5613 I got a job. :) This really helped me!
@@mizerosamuel5613i got one bro
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.
So glad to hear that! And I agree - sometimes one good explanation of something is all you need to really get the grasp of it
Hello matheus please can we chat on telegram I need assistance
Done for SQL Tutorial after 3 weeks of learning and spending 2-3 hours in each session while creating different scenarios outside the samples. hehe Mygee! I made it! haha! Thank you Alex! Next step is to get a certificate of SQL before proceeding to the other Tools. Hopefully I'm doing it right. Lol
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.
Thanks Alex for teaching Advance SQL REALLY QUICK.
After roaming around with other tutorials, it makes your tutorial more valued. Thanks sir
Thanks so much for these tutorials! I had a basic understanding of queries in ArcMap for GIS data and didn't understand why it was really that important but now thinking of it as having a database that has pre-made queries that can be manipulated in different ways to process and analyze data has made me understand its importance!
Thank you so much Alex! I went through the basic, intermediate and advanced SQL Tutorials. I would love to learn more about the store procedures in detail!
You're most welcome! Thanks for learning with me :)
Just finished watching all sql tutorial videos in this bootcamp. Time to watch the portfolio project.
Had troubles understanding some concepts from a bootcamp but your explanations are amazing! Concise, precise and easy to understand.Thank you!
Im taking a test today and this is the perfect video for a quick reminder of everything.
Your videos are good Alex.
We need a playlist of SQL needed for data science. Its a request. :)
Finally finish this advanced tutorial. Keep going for next series...
Thanks for giving such a clear and concise explanation for why one would use subqueries! I'm currently working through the Google Data Analyst certification program and your explanation and approach was much easier to understand than the instructor who presented on this very topic.
I have taken udacity course on sql and i applied the course on an actual db but your tutorials are much better realy specially on the joins
Brilliant SQL Tutorial Series! Every Video has really helped to fill in any potential gaps in my knowledge and even reinforce my existing skills. Thanks Alex!
I am Finally done with SQL on this amazing channel. But got to go back for some revisions.
Thank you so much for posting this series. I am learning SQL for the first time and your videos are extremely helpful :)
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.
You posted a tutorial on CTE before this. I am following from the older videos to the newer ones so I got lost for a bit and had to come find this. Thank you for making learning easy
Very helpful. All your videos about SQL are very easy to grasp and concise. Thank you so much.
Thank you Alex, i really learnt a lot from the beginners series up this advance series
This is a great video about subquery. Thank you, Alex!
Thank you so much Alex for providing such a valuable skills for free. It really made me become a aspiring data analyst.
On my journey through the boot camp...
This comes in handy. Thank you.
Thank you for your work and detailed explanations Alex. I mainly use COGNOS and COGNOS SQL so this is a great crash course for me to learn the differences between the two.
I learned so much with your videos. You made learning SQL very fun. I enjoyed your examples. Thank you!
Thank you for sharing, really really appreciate this. I would love to see more advanced stuff, specifically examples where you're using synonyms across different servers within source stored procedures (used to populate stage tables) to make joins along with ctes. I am at an internship right now, and still in my first year of college, I feel completely lost when working in these health insurance databases, most videos on youtube don't really go into more complicated stuff that I work with everyday so thank you again
Many of these queries in the code base are 3000+ lines long and my brain goes numb looking at all the subqueries, joins, and obscure functions I have no idea what they do
This is tremendously helpful. Got to resolve a blocker because of you. Thanks!
You just basically saved my career now
Hi! I just tried the syntax for subquery in where but I tried it also using join and got exact result
*Alex subquery in Where*
select EmployeeID, JobTitle, Salary
from EmployeeSalary
where EmployeeID in (
select EmployeeID
from EmployeeDemographics
where Age > 30
)
*my syntax*:
select demo.EmployeeID, JobTitle, Salary
from EmployeeDemographics as demo
join EmployeeSalary as sal
on demo.EmployeeID = sal.EmployeeID
where Age > 30
Anyway, I find your tutorial very informative and tried to use some work arounds if they will have the same output. Thank you always, Alex!
God bless you, Mr. SQL.
Keep up the Amazing content Alex!
Thank you so much. I had trouble understanding sub-queries. You've explained it so well. 😎
Thank you Alex for ur way in simplifying the training! Are you giving later more advanced videos about SQL or that is all ?
keep up the good work sir. I have been following your videos and techtfq videos as well and learned so much
I just learned this recently! Wonder do you have any recommendation for an intermediate level courses after the beginner course? I'm 75% done with my SQL beginner course. Thanks! :)
WOAHH!!!😍😍 Thank you so much for making it easy :)
Hey Alex thanks for making videos which are so informative and helpful..as a mechanical engineer who wants to change his profession to data analyst ..what will u suggest to learn first
Sounds like Dane Cook is teaching me SQL. Good video, thank you.
Thank you so much, Alex. Your videos are superb.
You should remind ppl to like your videos. I really like all your videos, super helpful~~~ but always forget to like it....
do you have any suggestions on where I could practice these functions more? and this playlist is really beneficial thanks for the time and effort!
I’ve been using SQL on my job since 2007, and I swear that I still don’t know everything I should know when it comes to really "complicated" queries.
Same lol
Me too.
I wish I had this during my undergrad over a decade ago.
What program is used here? It looks like a Jupyter NB for SQL
Subquery can also alternatively be replaced by temp table or CTE.
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
Please make a video on Window Functions. I love your videos :)
that was really quick
Thanks Alex.
Great course
This looks like a really interesting subject. I didn’t know anything about it until now, but I suspect the exponential, geometric, and weibull distributions might factor in?
Hello Alex, why did you create the subquery when to get the average you could have just specified :
"SELECT EmployeeID, Salary, (AVG)salary
FROM EmployeeSalary"?
I am really confused and would be glad if you could help.
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!
Hello Alex,
Where can we find some practice excercises to practice SQL queries?
Try StrataScratch.com or Leetcode.com :)
@@AlexTheAnalyst Thank You 🙂
Excellent Tutorial
I'd love a tutorial for working with SSIS Packages
Thank you this series is really helpful. 👌
What happens if you remove "over ()" from the "with Partition By" example?
In the last query, you used a subquery in the WHERE clause to filter for employees over 30. Could you also have accomplished that by joining the two tables and adding a WHERE EmployeeDemographics.Age > 30?
Agree Veronica, in that case we could use it in a join table. However, I believe using the subquery in the where clause is much faster than joining in this case. Maybe Alex could confirm that?
Hi Alex. Thank you very much for this series of videos. For me, your method of teaching is easy to follow and understand. Are perhaps you going to produce a tutorial on Goolge's Looker too in the near future?
Great content
Thanks Alex!
thank you Alex!
Very helpful, thank you. Is there a way to find out the input parameters of a stored procedure, that someone else may have created, w/o using the "modify" option?
Thank you for this video and recommendation
Your content is awesome, Alex! Thanks for all the videos! I don't know if you've answered this before, but I need to ask: how can I show my SQL skills in a portfolio project? Showing Python code with all the EDA and data viz is ok, I can do it, but I always have a hard time figuring out how to show employers that I know SQL (it seems like all they care about is if I've used in a job situation, which I haven't had the chance to). Any tips on that? Thanks again!
It's a good question. I'm kind of in the same situation than you. Personally, what I'm trying to do is simply looking for datasets online then trying to make my own project. You can for example find free datasets in SQL server website or Kaggle but I agree with you that it's not that simple. Hopefully Alex will answer this comment.
UPDATE youtube
SET button_Name = 'star_rating'
WHERE button_Name = 'like'
here we go @Alex you have got my 5 stars ;)
Hi there! great content!! Just to know, in a working place, how often is a subquery used compared to the join function?
As both can give the same result.
Joins are used all the time - subqueries about 10% as many times as joins
SELECT * FROM (SELECT employeeID, Salary, AVG(Salary) AS Allavgsalary FROM EmployeeSalary); CAPS LOCK IS FRIEND NOT FOOD
Hello Alex
I love ur videos they v been guiding me through data analysis but i v issues with my sql
Thanks for the video! Studying SQL with DataCamp but the explanation on subqueries is very short..
Thanks it was helpful!
And one thing I am confusing in, that which one is better to learn Tableau or Power Bi?
wondering the same thing
Hello teacher where can I load those data to practice following your explanations?
Thank you
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....
hello Alex and thanks for greate videos.
What "over ()" means?
thanks
Where is primary and foreign key video could you please share the link
thank you so much for this tutorial
Hey,i love your videos! I have a question though. In your last example you can simply do the normal query and filter using "WHERE Age>30" and still get the same results, right? If yes,then why do we need to use WHERE sub query?
Hi Alex thank you for your work great tutorial. Today I had a test in SQL for a company it was so hard. Do you know a good platform to train myself with exercice ? I mess this interview but I really would to do better next tile
Try Leetcode or Stratascratch - both are good options
You can use HackerRank too. Its free
How about doing an AVG SALARY for each employee instead of AVG FOR ALL? How do you query that?
Just to clarify, only the where statement combined with the subquery can only have 1 column selected? SELECT and FROM can select all columns if wanted from a subquery? thanks!
@Alex The Analyst Hey alex can you explain the functions CUME_DIST(),FIRST_VALUE,LAST_VALUE,RANK,DENSE_RANK,LAG,LEAD,NTILE etc (window functions)