\( \newcommand{\vect}[1]{\mathbf{#1}} \newcommand{\mat}[1]{\mathbf{#1}} \newcommand{\R}{\mathbb{R}} \newcommand{\E}{\mathbb{E}} \newcommand{\Prob}{\mathbb{P}} \newcommand{\T}{^{\top}} \newcommand{\norm}[1]{\lVert #1 \rVert} \newcommand{\abs}[1]{\lvert #1 \rvert} \newcommand{\ihat}{\mkern1mu\hat{\boldsymbol{\imath}}\mkern2mu} \newcommand{\jhat}{\mkern1mu\hat{\boldsymbol{\jmath}}\mkern2mu} \newcommand{\pd}[2]{\frac{\partial #1}{\partial #2}} \newcommand{\argmax}{\operatorname*{arg\,max}} \newcommand{\argmin}{\operatorname*{arg\,min}} \newcommand{\cdata}[1]{\class{c-data}{#1}} \newcommand{\cmodel}[1]{\class{c-model}{#1}} \newcommand{\ctruth}[1]{\class{c-truth}{#1}} \newcommand{\cgrad}[1]{\class{c-grad}{#1}} \newcommand{\closs}[1]{\class{c-loss}{#1}} \newcommand{\cparam}[1]{\class{c-param}{#1}} \newcommand{\csecond}[1]{\class{c-second}{#1}} \renewcommand{\,}{\mkern3mu} \)

P03 · SQL and Databases

A free, illustrated L1 course of 8 modules in the Programming and Data track. Modules include: The relational model and keys; Selecting, filtering and sorting; Joins.

P03 L1 · Core 8 modules · about 32 lessons Planned · Ring 3

Part of the Programming and Data track. Ships in Ring 3 (Breadth) of the roadmap.

Modules

1. The relational model and keys
2. Selecting, filtering and sorting
3. Joins
4. Aggregation and window functions
5. Subqueries and common table expressions
6. Schema design and normalization
7. Indexes, query plans and transactions
8. Beyond relational: document, key-value, columnar and vector stores

Signature illustrations

The pictures a learner should still see in their head a year later:

Join animations, sliding window frames, B-tree index diagram, entity-relationship diagrams, query-plan trees.

Status

This course is planned, not written yet. It ships with Ring 3 (Breadth).

Every lesson will follow the same twelve-part blueprint with at least three purpose-made figures. Watch the repository to hear when modules ship, or help write and review it.