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!
Want to master MySQL window functions and significantly increase the expressive power of your SQL queries? This course, geared for intermediate MySQL 8 users, will show you how to perform complex computations in one simple query.
Window functions were introduced to MySQL 8.0 in 2018. They immediately streamlined and facilitated the daily work of analysts, data scientists, and data engineers. They are also an essential feature for anyone doing business analysis in MySQL 8 or above.
Window functions are similar to aggregate functions: they compute a value for a group of rows. In window functions, this group is called a window frame. Unlike aggregate functions and GROUP BY, window functions do not collapse rows and return one value for the entire group; they keep details of each individual row and show the group value.
In SQL, window functions let you easily process time series data (e.g. monthly financial results, daily website visits, quarterly sales totals, etc.). Use them to build SQL reports that:
Window Functions in MySQL 8 is split into multiple parts. Each part covers one aspect of window functions: the OVER() clause, PARTITION BY, ORDER BY, defining window frames, etc. You will also learn different types of window functions, including:
You’ll also practice using window functions with GROUP BY. Finally, you’ll learn when to use window functions and when to use GROUP BY.
The course is interactive. You’ll learn by writing real SQL queries in our online console and immediately seeing the results. Our platform runs your code and verifies your solution. Each exercise includes an instruction and a task that you complete. This way, you can put your new knowledge into practice right away.
This course is intended for intermediate users. We assume the user knows the basics of SQL, including:
In this MySQL course you will learn:
You'll discover how window functions in MySQL can be used to:
Window functions? We'll explain what it's all about.
Your first encounter with window functions.
Discover how you can define the function window with PARTITION BY
Learn how you can rank rows with window functions.
Get to know how to create sophisticated window frames for your window functions.
Learn the most essential analytic functions.
Create advanced statistics computed independently for various groups of rows.
Do you know when window functions are evaluated in a MySQL query? Let's find out.
Master all the skills you acquired so far in our big practice part.
Test the skills you acquired in the whole course with this final quiz.