**BETA (USE NOW FOR FREE)**

What you get?

- 192 interactive exercises
- Lifetime access
- Certificate of completion
- 30 days money back guarantee

# Window Functions

Use analytic functions to deeply understand data.

On February 28 at 1:00 PM UTC the platform will be unavailable for a few minutes due to planned maintenance break.

What you get?

- 192 interactive exercises
- Lifetime access
- Certificate of completion
- 30 days money back guarantee

Use analytic functions to deeply understand data.

Window functions are so powerful that they serve as a dividing point in time: people talk about SQL before window functions and SQL after window functions. Because they were introduced into the standard relatively recently, these functions aren't covered in many SQL courses.

Note: Most popular database engines support window functions; MySQL is the only one that does not.

This course covers the syntax and semantics of SQL window functions. It shows how powerful they are, what the typical use cases are, and how to use ORDER BY and PARTITION BY to set up a frame for window functions. You'll also learn the difference between ROWS and RANGE clauses.

This course is intended for intermediate users. We assume the user knows the basics of SQL, including:

- How to select from a single table, including writing complex WHERE conditions
- How to JOIN tables
- How GROUP BY and HAVING work

- A web browser
- Knowledge of basic SQL, including JOINs and GROUP BY clauses

- Compute running totals and running averages
- Build rankings
- Find best and worst performers
- Investigate trends across time
- Calculate contributions to the whole, such as commission percentages

You'll also get a deeper understanding of SQL aggregate functions.

- Beginning database analysts
- Developers who want to keep their knowledge of SQL current
- Students taking classes in relational databases
- Anyone who wants to learn SQL window functions

Window functions? We'll explain what it's all about.

0% completed (8 of exercises done)

Your first encounter with window functions.

0% completed (17 of exercises done)

Discover how you can define the function window with PARTITION BY

0% completed (16 of exercises done)

Learn how you can rank rows with window functions.

0% completed (26 of exercises done)

Get to know how to create sophisticated window frames for your window functions.

0% completed (26 of exercises done)

Learn the most essential analytic functions.

0% completed (30 of exercises done)

Create advanced statistics computed independently for various groups of rows.

0% completed (25 of exercises done)

Master all the skills you acquired so far in our big practice part.

0% completed (30 of exercises done)

Test the skills you acquired in the whole course with this final quiz.

0% completed (14 of exercises done)

0