CTEs in MySQL | Advanced MySQL Series

In this lesson we are going to take a look at CTEs in MySQL!

____________________________________________

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

BECOME A MEMBER -

Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!

____________________________________________

Websites:
📱Instagram: @Alex_The_Analyst
____________________________________________

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

[riteshgaihre]

I have started your data analyst bootcamp. I have completed your entire sql, excel series with projects. Now i am learning Tableu. Still to go with power bi and python.
Thank you for bootcamp series

[aleksandra]

Using ctes constantly at my work, a senior colleague thought me once, they are very helpful for huge data sets to compare with each other

[BruceBeck-fn]

I have only experienced CTEs in Alex's YouTube lessons. I believe I will learn more when I use CTEs out in the wild. Reasonable pace with clear instructions. I feel challenged in Alex's courses but NEVER stupid. We all have to start somewhere and it's helpful to have someone showing me the way that has walked this path. Much gratitude for your efforts Alex. Cheers! 😎

[SaeedBarrie]

Alex Freberg is one of the best Data Analysts out there.
Thank you Alex

[foland]

Thanks Alex, your course series helped me to best understanding about SQL. Clear, short, and precise.

[ATCSABChaitra]

Data analyst freshers really wants you
Dont stop making videos

[justinkings]

Man, I'm really enjoying this series. I can't wait to make projects on SQLs. Thanks, Alex!

[malcorub]

Great lesson and the next one on #Temp tables will be too. Last week, one first round interview question (non technical part of the interview series) I was asked was "describe the difference between a CTE and a #Temp Table." Alex basically answered that in this video.... Gotta be ready to answer these types of questions on the fly. 🙂

[charlesbliss]

This is the best way to go on tables. Thank you for this information

[NicheOrNitch]

Hey Alex! Love the video on CTEs. I'm wondering if you'd consider making one on solving a gaps and islands problem? I've watched and read tutorials on them and the overview logic makes sense but I tend to get a bit lost when applying all the various window functions. Thanks!

[leesever]

Hi Alex, the beginner and intermediate courses were presented on MS SQL platform while with the advanced you've moved to MySQL, which is written slightly different. I managed to find how to perform CTE in MS SQL, but it was kind of confusing. Anyhow, wanted to thank you for your videos. You're a great teacher and the videos are extremely beneficial.

[karthickraja]

hi alex,
we need end to end project data analysis
please consider about

[salonighurde]

Superb!!
I needed this as I'm currently learning CTE!!

[javiermillan]

Hello my friend. I love your content. You keep going

[alex-hz]

Can you explain me I have 2 different results for the same table: CTE AVG(salary) result 55589, without CTE 56090, if we export data to the spreadsheet it also shows AVG 56090.

[NohablaEspnaol]

Thank you so much for another great video :)

[Luis_Domingos]

May I ask in which real-world scenario would getting an average of averages without weighing by their relative counts make sense? I know this was just a didactic example, but I was still a bit puzzled by that considering the fact that an actual population average would have to consider how many people are contributing for each average: ((avg_salary * count_salary) WHERE gender = female) + ((avg_salary * count_salary) WHERE gender = male) / the sum of both counts. Thanks in advance!

[aryandodani]

Alex what is the difference between VIEW function and this WITH CTE example stuff

[nauvaldwifadillah]

in previous videos you mentioning alias. but in this video, is it oke to not use "as"? i can directly type avg_sal etc?

[rakshithajaganth]

Sir can u help me with this project " Efficient multidimensional modeling for educational data analytics"I didn't find any videos related to this on yt😢😢