Have you mastered the basics of SQL? Are you ready for more? Learn modern SQL features like recursion and CTEs in MySQL 8. You’ll be writing sophisticated and effective queries in no time!Start learning
30 free interactive coding challenges
If you are serious about working professionally with MySQL databases, you should know the advanced SQL features introduced in MySQL 8. These include window functions, Common Table Expressions (CTEs), recursive queries, and GROUP BY extensions. They will allow you to perform complex computations using shorter SQL queries. If you want to perform deeper data analysis in MySQL, this set of interactive exercises is for you!
Window functions – first available in MySQL 8 – help you create rankings, find top-performing objects, compute running totals and moving averages, find year-to-year or month-to-month differences, etc. This will really power up your SQL reporting and help you find insights.
Common Table Expressions (CTEs) let you write readable and organized queries. Nowadays, data is processed in teams and it is important for everyone to be able to understand (and in some cases, change or adapt) queries written by others.
Recursive queries let you easily process hierarchical data like trees and graphs (e.g. employment hierarchies or organizational charts). Finally, GROUP BY extensions let you prepare multiple different statistics and different groupings in one query. Both make daily work easier.
These advanced SQL features are often omitted in traditional online MySQL courses. Our 3-course track gives you a unique opportunity to learn them in an interactive way.
The track is designed for intermediate and advanced SQL users interested in modern SQL. You should know the basics of SQL well: joining tables, working with GROUP BY and HAVING, using subqueries, and sorting data with ORDER BY. If these aren’t familiar concepts, start with our SQL Basics in MySQL course and come back here for more.
Advanced SQL in MySQL 8 is interactive. You practice by writing real SQL code and solving exercises directly in your web browser. Our online platform runs your code and verifies your solution. You don’t need to install any software on your computer.
This track uses MySQL 8. However, users working with MySQL 5 and earlier can also take it. The features that are only available in MySQL 8 are clearly marked.
Want to stay up to date with the latest MySQL features? MySQL window functions are essential for doing modern data analysis. Learn how to use them to take your analysis skills to the next level!
Do you want to perform multiple groupings in one query? Learn how to use GROUP BY extensions, such as ROLLUP in MySQL. Take the next step towards being a SQL expert!
Do you want to be able to process trees and graphs in MySQL? Are you using MySQL 8 or higher? Learn how to write recursive queries and you’ll soon be producing concise and powerful SQL queries!