Skip to content
skillbld
All courses

Learn PostgreSQL visually: how the server works, how to model data, query it, keep it correct and make it fast. Each day has diagrams, a mind map and a quick knowledge check.

  • 14 days
  • ~30 min / day
  • Beginner
  • Free account required
0/14

Ready when you are

Saved on this device. No account needed.

Start Day 1

The big picture

Everything you'll cover, and how it fits together.

Mind map · click a dot to fold, drag to pan

Day by day

Go at your own pace. Your progress is remembered on this device.

  1. 1
    Day 1Up next 30 min

    Meet PostgreSQL

    What Postgres is, how the server works and your first query in psql.

    RDBMSClient/serverpsql
  2. 2
    Day 2 30 min

    Databases, Tables & Data Types

    Create a database, design a table and choose the right types.

    CREATE TABLEData typesINSERT
  3. 3
    Day 3 30 min

    Querying with SELECT

    Read exactly the rows and columns you need.

    SELECTWHEREORDER BYLIMIT
  4. 4
    Day 4 30 min

    Filtering & Operators

    Combine conditions and handle NULL correctly.

    AND / ORINLIKENULL
  5. 5
    Day 5 30 min

    Changing Data

    Update and delete rows safely.

    UPDATEDELETERETURNING
  6. 6
    Day 6 30 min

    Constraints & Keys

    Let the database protect your data.

    PRIMARY KEYFOREIGN KEYUNIQUECHECK
  7. 7
    Day 7 30 min

    Joins

    Combine rows from related tables.

    INNERLEFTFULLSelf join
  8. 8
    Day 8 30 min

    Aggregates & Grouping

    Summarise data with counts, sums and groups.

    COUNT / SUMGROUP BYHAVING
  9. 9
    Day 9 30 min

    Subqueries & CTEs

    Break big questions into readable steps.

    SubqueriesWITHEXISTS
  10. 10
    Day 10 30 min

    Indexes & Performance

    Find rows fast and read query plans.

    B-treeEXPLAINANALYZE
  11. 11
    Day 11 30 min

    Transactions & Concurrency

    All-or-nothing changes and many users at once.

    ACIDIsolationMVCC
  12. 12
    Day 12 30 min

    Views, Functions & Triggers

    Reusable queries and logic inside the database.

    VIEWFUNCTIONTRIGGER
  13. 13
    Day 13 30 min

    JSONB & Full-Text Search

    Flexible documents and search inside Postgres.

    JSONBGINtsvector
  14. 14
    Day 14 30 min

    Capstone: Library Database

    Design, build and query a complete schema.

    ModellingBuildingQuerying