Track · data-engineering

SQL for Data Engineers

Schemas and DDL, window functions, CTEs and complex subqueries — what data marts and denormalised layers are built on.

48 tasks~15 h5 modules

Track program

5 modules
  1. 1
    Module 1

    DDL: schemas & tables

    9 tasks
  2. 2
    Module 2

    Aggregates & GROUP BY

    12 tasks
  3. 3
    Module 3

    Subqueries

    11 tasks
  4. 4
    Module 4

    CTEs & WITH

    7 tasks
  5. 5
    Module 5

    Window functions

    9 tasks

Who it's for

This track is built for people preparing for a data-engineering role. Tasks progress from basic to advanced, solutions are graded automatically, and both PostgreSQL and MySQL are supported.