Lumina

Manuals / SQL

Foundations · Beginner → Pro

SQL

Interactive path — click phases, expand checkpoints, mark chapters done. Ask questions of data — SELECT through transactions and indexes.

~6 wk

Typical span

6 phases

Learning bands

0/12

Chapters done

0%

Progress

Relative time weight by phase — click a band to open Phase detail.

Start chapter 1

Learning path

Phase map for this manual. Download the SVG or jump into a phase below.

Interactive pathway

Learning roadmap

A progressive route through 12 nodes across 6 phases. Click any node to open the chapter.

  • Chapter
  • Guide
  • Checkpoint
  • Beginner Mid Advanced
  1. 01

    Start

    1 step

    1. 01How to use this SQL path~15 minGuide
  2. 02

    A · Query

    4 steps

    1. 02SELECT basics — reading rowsWeek 1Chapter
    2. 03WHERE, ORDER BY & LIMITWeek 1–2Chapter
    3. 04JOINs — inner, left, and relationshipsWeek 1–2Chapter
    4. 05Checkpoint A — SELECT & JOINsGate · Week 3–4Checkpoint
  3. 03

    B · Analyze

    2 steps

    1. 06Aggregations & GROUP BYWeek 2Chapter
    2. 07Subqueries & CTEsWeek 2Chapter
  4. 04

    C · Write

    2 steps

    1. 08INSERT, UPDATE, DELETE safelyWeek 3Chapter
    2. 09Transactions & isolationWeek 3Chapter
  5. 05

    D · Performance

    2 steps

    1. 10Indexes & EXPLAINWeek 3–4Chapter
    2. 11Checkpoint B — SQL job-readyGate · Week 8–10Checkpoint
  6. 06

    Reference

    1 step

    1. 12Timeline, tools & cheat sheet~15 minGuide
Text list of all chapters
  1. 01How to use this SQL pathStart
  2. 02SELECT basics — reading rowsA · Query
  3. 03WHERE, ORDER BY & LIMITA · Query
  4. 04JOINs — inner, left, and relationshipsA · Query
  5. 05Checkpoint A — SELECT & JOINsA · Query
  6. 06Aggregations & GROUP BYB · Analyze
  7. 07Subqueries & CTEsB · Analyze
  8. 08INSERT, UPDATE, DELETE safelyC · Write
  9. 09Transactions & isolationC · Write
  10. 10Indexes & EXPLAIND · Performance
  11. 11Checkpoint B — SQL job-readyD · Performance
  12. 12Timeline, tools & cheat sheetReference

Next, learn…

Same neighborhood as SQL — keep the momentum.

FoundationsJavaScript
FoundationsTypeScript
FoundationsPython
FoundationsGit & GitHub

Discussion

Light notes for this path — saved in your browser only (not a public forum yet).

  • No notes yet — leave the first.