Skip to content
KodeTrail

SQL

Ask questions, get answers — from data.

Beginner13 lessons≈2 h 48 min total
Start this trail

Begins with: What is a database?

Trail map

  1. Camp 1

    First steps

    Databases, tables, and your very first query.

    1. What is a database?8 min
    2. Tables, rows, and columns10 min
    3. Your first SELECT12 min

  2. Camp 2

    Querying

    Filter, sort, and compute — the daily bread of SQL.

    1. Filtering with WHEREOn the trail map
    2. ORDER BY and LIMITOn the trail map
    3. COUNT, SUM, AVGOn the trail map

  3. Camp 3

    Multiple tables

    Real data lives in many tables. JOIN brings it together.

    1. JOINsOn the trail map
    2. GROUP BYOn the trail map
    3. SubqueriesOn the trail map

  4. Camp 4

    Changing data

    Create tables and modify data — with care.

    1. INSERTOn the trail map
    2. UPDATE and DELETEOn the trail map
    3. CREATE TABLEOn the trail map
    4. Project: library databaseOn the trail map