Welcome! This course aims to teach you how to use various GROUP BY extensions: ROLLUP, CUBE, and GROUPING SETS. They are often used to create advanced reports with SQL.

These extensions to the GROUP BY clause have been added to the ANSI/ISO standard SQL:1999. They are supported by all major database engines with some exceptions:

• ROLLUP, CUBE and GROUPING SETS have been available in PostgreSQL since version 9.6.
• MySQL only supports ROLLUP with a syntax slightly different than the standard one.

We assume that you already know a lot about SQL and can put that knowledge into practice. In particular, we assume that you know how to group rows by single or multiple columns and how to calculate aggregate functions: sums, averages, maximum values, etc.

So, are you ready?