Tools / ILLUSTRATED SERIES

Illustrated SQL

Joins, Windows, and Queries You Can Actually Picture

See how a query changes your data. Follow a small shop’s dataset from simple filters to joins, aggregations, and window functions.

Coming soon

We’re preparing this book for publication. Its Amazon listing will be linked here when it’s available.

Read a sample chapter

A REAL LOOK INSIDE

The Mental Model of a Join

Part I operated on one table at a time. A join combines related rows from two tables into wider result rows. This chapter develops a physical model for that operation before introducing the syntax used to express it.

An excerpt from the working manuscript. Read the illustrated pages or download the complete sample chapter.

Read the sample →

First page of The Mental Model of a Join, a sample from Illustrated SQL

A LITTLE MORE CLARITY

What you’ll explore.

Analysts and developers who want to understand what their queries do.

The outline is from the working manuscript and may change before publication.

01Tables and keys
02Filtering and sorting
03Joins
04Grouping and aggregation
05Window functions
06Practical query patterns

PUT AN IDEA TO WORK

There’s a seat for your curiosity.

Try a coding problem, then compare approaches with a friend.

Explore practice

Opening your workspace…