Navigate Select ESC Close

CTEs in MySQL | Advanced MySQL Series

2024-03-12 Education
188.0k
3.0k
92
Alex The Analyst
Alex The Analyst
1.4m subscribers

Unlock all features

FREE: Get instant access to 10 AI summaries, chats, or transcripts per day.

Description

Full MySQL Course: https://www.analystbuilder.com/courses/mysql-for-data-analytics In this lesson we are going to take a look at CTEs in MySQL! GitHub Code: https://github.com/AlexTheAnalyst/MySQL-YouTube-Series/blob/main/Advanced%20-%20CTEs.sql ____________________________________________ 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: https://coursera.pxf.io/5bBd62 📖Data Analysis with Python - https://coursera.pxf.io/BXY3Wy 📖IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR 📖Tableau Data Visualization - https://coursera.pxf.io/MXYqaN Udemy Courses: 📖Python for Data Science - https://bit.ly/3Z4A5K6 📖Statistics for Data Science - https://bit.ly/37jqDbq 📖SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij 📖Tableau A-Z - http://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! https://www.youtube.com/channel/UC7cs8q-gJRlGwj4A8OmCmXg/join ____________________________________________ Websites: 💻Website: AlexTheAnalyst.com 💾GitHub: https://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*

Top Comments (10)

@riteshgaihre5 2024-03-12

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

83 9 replies
@aleksandra8579 2024-03-13

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

33 1 replies
@ATCSABChaitra 2024-03-12

Data analyst freshers really wants you Dont stop making videos

26
@justinkings635 2024-08-20

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

20
@muhammadintesar3023 2025-05-28

Now this is actually a start of advance level , I have to go through sub queries, window funtions, and CTES again and again to clear the concepts along with real data problems remeber we have to think through a raw data to create a logic to solve data problems using all these tools like group by , window funtion, sub queries ctes etc, Think and analyse which tools are best for certain conditions.. Thanks to alex for making things so easier to grab and learn making progress day by day and very hopefull to get a dream job as an analyst

7
@SaeedBarrie 2024-10-04

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

3
@jyg9504 2025-10-22

Easier to understand on a rewatch. Thanks!

2
@charlesbliss753 2024-05-21

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

2
@foland2619 2024-10-24

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

2
@norhazarizaabuhassan1272 2025-08-29

starting my advance level today. I don't know what I'm looking...but thank you. I learn many through you video

0

Unlock the Data Inside
Turn Videos into Knowledge

  • Get FREE 10/day: transcripts, summaries, chats
  • Chat with videos, export text & PDF
  • $1 free API credit for RAG, chatbots & research

Free forever plan • All features unlocked

App screenshot