SQLearnAcademy

PostgreSQL in the browser

SQL lessons right in your browser

A little theory, lots of practice.No installs or setup.Write a query — see the result instantly.

Start learningTrainer
SELECT name, price
FROM products
WHERE price > 100
ORDER BY price DESC;
Result3 rows
ProBook 14 Laptop899.00
Galaxy A54 Smartphone399.00
Espresso Mini Coffee Maker129.00
19modules
168hands-on lessons
217trainer tasks

One database instead of scattered examples

Every lesson runs on one end-to-end online shop database. At first there is just a products table. Then the database gradually grows: customers, orders, payments, shipping, a warehouse — up to ten related tables.

A tick means “one”, a crow's foot means “many”: one customer — many orders.

Course program

19 modules of theory and practice + a trainer with work tasks.

  1. Part 1

    Query basics

    Reading, filtering, transforming and counting.

    5 modules · 41 lessons

  2. Part 2

    Multiple tables

    Relationships, JOIN, building a schema and changing data.

    5 modules · 45 lessons

  3. Part 3

    Advanced queries and reports

    Subqueries, CTEs, window functions and summary reports.

    3 modules · 25 lessons

  4. Part 4

    Data engineering

    Transactions, performance, reliability and scale.

    6 modules · 57 lessons

Full course program

free

Function reference

95 PostgreSQL functions — with explanations and examples you can run right on the page.

Open the reference

Where do we start?

Two paths to confident SQL — pick whichever suits you.

step by step

Learn

Theory + practice in the sandbox — from your first SELECT to transactions, indexes, and scaling.

Open the course

like real work

Trainer

Already know the basics and want more practice? Hands-on tasks with no theory — you build and grow the database yourself.

Open the trainer