CodingNeed.
SQL · Beginner

SQL for everyday data

Query a real SQLite database, then build a spending report.

Prerequisite: None · 76 minutes of guided study

8 published lessons, from first principles to a small project.

Open interactive course →

1 · Read and filter

  1. Read a table

    Read a table.

    8 min →
  2. Filter rows

    Filter rows.

    8 min →
  3. Sort deliberately

    Sort deliberately.

    8 min →

2 · Summarize

  1. Aggregate a result

    Aggregate a result.

    8 min →
  2. Group related rows

    Group related rows.

    8 min →
  3. Filter groups

    Filter groups.

    8 min →

3 · Connect and build

  1. Connect related data

    Connect related data.

    8 min →
  2. Project · Spending report

    Project · Spending report.

    20 min →