Easier to read with cream paper, a tint, more contrast or larger text? Choose your colours and text, once, for every page.

Free module

SQL analytics with DuckDB

Learn SQL analytics hands on with DuckDB: window functions, ROLLUP and CUBE subtotals, CSV files as tables and EXPLAIN query plans.

6 lessons325 min lessonAI and data science

The lessons

Each lesson is free to read in full. Create a free account to run its commands in a live lab and to sit its quizzes and tasks.

  1. 1

    Row store and column store

    I can say why an analytical query reads a table differently from a lookup.

    Read the lesson

  2. 2

    SQL window functions

    I can add a running total or a rank beside each row without losing rows.

    Read the lesson

  3. 3

    Partitions and window frames

    I can rank inside each group and average over a moving window.

    Read the lesson

  4. 4

    Query a CSV file with SQL

    I can query a CSV file by its name.

    Read the lesson

  5. 5

    ROLLUP, CUBE and subtotals in SQL

    I can total at several levels in one query.

    Read the lesson

  6. 6

    Reading an EXPLAIN query plan

    I can read EXPLAIN and say why one query is cheaper than another.

    Read the lesson

Teaching a class? Set this module for your students with a teacher guide, marked assignments and a lab for every student.