Data engineering, from zero

Learn data engineering by doing it.

A chatbot can write your SQL. It can't tell you the join just doubled the revenue.

Practice the judgment the job needs: short lessons that teach one idea at a time, then hand you a real database, git and a terminal to try it on, right in your browser.

  • No account needed
  • Nothing to install
  • Works on your phone
Try it noworders · 8 rows

Which city sold the most drinks? Click any order from that city.

order_idcitydrinks
1Austin2
2Boston1
3Austin1
4Austin1
5Denver3
6Boston2
7Denver1
8Austin2

Add them up in your head. It takes a few seconds.

Get a free lesson in your inbox each week

One hands-on data engineering lesson a week, starting with your first table. No account needed, and one click to stop.

How it works

Step 1

Learn the idea

Every step starts with a short, plain-English explanation. No jargon until it has been taught.

Step 2

Do it for real

A real database runs in your browser. You write real SQL against real tables, and see the result instantly.

Step 3

Climb the ladder

Earn XP, keep a streak, and rise from Curious to Principal Data Engineer on a public leaderboard.

New

The tools nobody teaches.

Most people use git for years without knowing what it is. Open it up in a real terminal in your browser, and watch every commit, hash and branch appear as you type.

One path, from your first table to production

The same skills data engineers use at work, in the order you need them. From your first table to a capstone pipeline you can show an employer.

Open the full journey
  1. 01Free

    Foundations

    What data engineering is, how tables work, and your first pipeline. No experience needed.

    6 of 6 lessons ready

  2. 02All levels

    The tools nobody teaches

    Git, the command line, Docker, logs and query plans: the everyday tools of data work that courses skip. Real git, plus practice versions of the terminal and Docker, all running in your browser.

    9 of 9 lessons ready

  3. 03Beginner

    Combining data

    Real data is spread across many tables. Join it without losing or doubling anything.

    3 of 3 lessons ready

  4. 04Coming soon

    SQL you'll use every day

    The SQL that trips people up at work: missing values, buckets, dates and time zones, readable queries, and the days with no data.

  5. 05Intermediate

    Reliable pipelines

    Pipelines that run every night without waking anyone up: tests, incremental loads and scheduling.

    5 of 5 lessons ready

  6. 06Intermediate

    Modeling for analytics

    Shape data so analysts get the right answer by default: facts, dimensions and history.

    3 of 3 lessons ready

  7. 07Advanced

    Files, formats & storage

    Where data actually lives: CSV, JSON, Parquet, and how to lay files out so queries fly.

    3 of 3 lessons ready

  8. 08Expert

    Architecture at scale

    The decisions senior engineers make: batch or streaming, warehouse or lake, speed against cost.

    3 of 3 lessons ready

  9. 09Expert

    Capstone: your own pipeline

    Build a working pipeline front to back, from raw files to a trusted dashboard, for the coffee chain you have followed all along.

    4 of 4 lessons ready

  10. 10Coming soon

    Interview drills

    The SQL questions data engineering interviews keep asking, as short timed drills with the traps interviewers look for.

Your first lesson takes six minutes.

The whole Foundations track is free. Upgrade only if you want to go further.

Start lesson 1