Learn SQL in a Garden

visited

I

First Basket

SELECT · WHERE · ORDER BY · LIMIT

walk the rose bed, fill a basket — the foundation

visited

II

Tending the Bed

INSERT · UPDATE · DELETE

plant, prune, pull — the database starts to change

visited

III

The Greenhouse

CREATE TABLE · constraints · ALTER · DROP

design the trait card before any flower goes in

visited

IV

The Flight Path

JOIN · INNER · LEFT · RIGHT · FULL

a bee flies the path between bees and flowers

visited

V

The Sorting Table

GROUP BY · COUNT · SUM · AVG · HAVING

tip the harvest onto the table and sort by kind

visited

VI

The Basket Inside the Basket

subqueries · IN · EXISTS · correlated

gather a small basket first, use it inside the larger query

visited

VII

The Directory at the Gate

indexes · query plans · EXPLAIN

a signpost the gardener consults before walking the beds

VIII

Looking at Neighbors coming soon

window functions · RANK · LAG · LEAD

each flower can see how it compares to its neighbors

IX

The Day's Work coming soon

transactions · BEGIN · COMMIT · ROLLBACK

wrap risky changes so the bed can be returned to morning

❋

The Field Guide

colors · operators · clauses · mutations

a single page of reference cards, shared across every chapter