Window Functions Practice Set

Window functions are a powerful modern addition to SQL. They allow you to prepare complex SQL reports: rankings, differences between two rows, running totals, moving averages, time series analysis, and more.

Are you dreaming of a career in data analysis? You need to know SQL window functions if you want to move freely in the modern SQL environment. This course offers a unique opportunity to practice SQL window functions interactively.

Window functions are rarely covered in a typical SQL course curriculum, and exercise sets for window functions are even more scarce. This course is designed to fill this gap in the market. To take full advantage of this course, you should know at least the basics of window functions. You don't know anything about them? Take the Window Functions course first and come back for more.

This course offers multiple exercises designed to make you practice writing realistic reports using SQL window functions. Their syntax is complex and difficult to remember. You need practice to grasp the syntax and be comfortable with creating complex reports with window functions.

The course uses three different datasets. In the first part of the course, you will work with data from an online store. You will rank products, compute statistics for customers and their typical order size, divide customers into categories, etc. In the second part, you will deal with data from track running competitions. You can find out the fastest 100m runner, the average pace for the 10000m, the country with the most medals in the women’s marathon, etc. In the third part, you will train with traffic data from a blog of an online pet product store. You will find out which articles and article categories lead to sales the most, which author generates the biggest traffic, which articles are the most popular, when they reach the height of their popularity, etc.

We created our exercises so that you would not only practice window functions but also use the SQL queries you would actually write in your projects. The datasets and the reports are diverse and useful. It’s very likely that you will work with similar data in real life: transaction data similar to that of a store, marketing data similar to that of a blog, or achievement data in different categories similar to that of a sports competition.

The course uses the standard SQL syntax that can be used in all databases that support window functions.

This SQL course is interactive. You'll practice writing actual SQL queries to solve exercises in your web browser. Our web-based platform will run your command and verify your solution. You don't need to install anything on your computer, so you can start practicing right away.