CTEs in MySQL | Advanced MySQL Series

Full MySQL Course: www.analystbuilder.com/course...
In this lesson we are going to take a look at CTEs in MySQL!
GitHub Code: github.com/AlexTheAnalyst/MyS...
____________________________________________
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:
📖Google Data Analyst Certification: coursera.pxf.io/5bBd62
📖Data Analysis with Python - coursera.pxf.io/BXY3Wy
📖IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
📖Tableau Data Visualization - coursera.pxf.io/MXYqaN
Udemy Courses:
📖Python for Data Science - bit.ly/3Z4A5K6
📖Statistics for Data Science - bit.ly/37jqDbq
📖SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
📖Tableau A-Z - bit.ly/385lYvN
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!
/ @alextheanalyst
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: github.com/AlexTheAnalyst
📱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

[@user-kq3tc5tu1c]

I have only experienced CTEs in Alex's KZbin 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! 😎

[@aleksandra8579]

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

[@ATCSABChaitra]

Data analyst freshers really wants you Dont stop making videos

[@riteshgaihre6277]

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

[@jameskorankye6096]

What SQL server do you use?

[@riteshgaihre6277]

@@jameskorankye6096 postgre sql

[@riteshgaihre6277]

@@jameskorankye6096 postgre sql

[@charlesbliss753]

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

[@salonighurde6975]

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

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

[@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. 🙂

[@javiermillan338]

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

[@karthickraja3513]

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

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

[@rakshithajaganth6846]

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

[@Roxana11270]

I have noticed that the result for avg salary for both female and male is different from the result obtained with windows functions, on the pervious video. Could anyone explain, please? which version is more accurate?

[@consuela3905]

Hey, I see the same in both cases, female 53750 and male 57428.5714. Which results do you see?

[@juanmanuelarevalomadrid1937]

does anyone know where I can find parks_departments table ?

[@abdulqudusoyelami3019]

I had to create one myself. Probably you do same

[@claudiaklausgraber1361]

@@abdulqudusoyelami3019 you can download it by the link at the first SQL-video for beginners "installing mySQL" :)

[@KaizuKalyug]

Check his first video (select statement video) you will see the data set link in description

[@moak08]

Can chat gpt do this?

[@peekknuf]

easily, but it still does silly mistakes, so you gotta be able to verify the output

[@malcorub]

"Can you create a small single sample temporary data set and from that give me SQL query that joins two CTE's together?" plug this question into your CHAT GPT machine and see for yourself. As stated above it does make mistakes sometimes if not asked the question properly OR not given enough context.