Quick Start Guide · 07 · Level 2
Ask harder questions of your data.
Eight chapters that grow one table into a properly connected database — and teach the queries that answer real questions instead of listing rows.
30-day money-back guarantee. Payment is handled by Paddle, our Merchant of Record. See the refund policy and terms.
Quick Start Guide · 07
SQL Level 2
One table into
a real database
Level 2
What's inside
Eight chapters, every query run for real.
01
When one table stops being enough
Duplicate facts, update anomalies, and normalization explained without the textbook.
02
Designing the connection
A second table, a foreign key, and what the database actually enforces for you.
03
Joining tables together
INNER and LEFT JOIN taught visually, plus how to read an ON clause out loud.
04
Summarizing with aggregates
COUNT, SUM, GROUP BY and HAVING — one answer per category instead of a wall of rows.
05
Shaping the results
Ordering by more than one thing, LIMIT, and a query inside a query.
06
Why queries get slow
Indexes, what SCAN means, and reading a query plan as a habit.
07
Safe changes: transactions and constraints
All-or-nothing changes, rules that block bad data, and hand-written migrations.
08
Views, backups, and what comes next
Save a query you keep retyping, back up properly, and the honest path to PostgreSQL.
Look inside
Three real pages from the 32-page PDF.
Rendered straight from the file you'll download — an explanation, a worked step, and a page from the build. No mock-ups, no stock screenshots of someone else's screen.
CheckMate — the small task tracker every SecondNature code guide builds — is what these pages are working towards. Foundations gets it running; Level 2 makes it real. See the rest of the collection →
Who it's for
People who can SELECT, and want to stop stopping there.
One table only takes you so far. This guide is the jump to related data, real questions, and queries that stay fast when the table grows.
Runs entirely on SQLite, already on your machine. Every result printed in the guide came from an actual run.
Questions
Before you buy
Do I need the beginner SQL guide?
It helps, but not strictly. If you can write a SELECT with a WHERE, you can start here.
Does this transfer to PostgreSQL or MySQL?
Yes. Joins, aggregates, indexes, and transactions are shared ground, and chapter 8 covers the real differences.
Is Python required?
Only lightly, to run the examples. Every query also works in any SQLite tool you prefer.
What do I get after checkout?
An instant download link for a clean, print-friendly PDF. Yours to keep, on any device or printed.
The collection this belongs to
All five Level 2 guides for $77.
The same five subjects one level up: related tables behind the app, a real interface on top, code with structure, and a deploy that happens on its own. Each guide adds a feature to the project the beginner five built.
Python Level 2 · SQL Level 2 · HTML & CSS Level 2 · JavaScript Level 2 · Git & GitHub Level 2 · 166 pages in total
$77
$90 bought separately · save $13
Instant download · 30-day money-back guarantee · payment handled by Paddle.
From a list of rows to real answers.
32 pages · $18 · instant download · yours to keep.
Free sample chapter
Read chapter one before you spend anything
Seven pages from the Python guide — the start of CheckMate, the small task tracker the code guides build. It shows you exactly how a guide reads: what the tool is for, where it fits in a real app, and how the next guide picks the project up. Send us an address and it lands in your inbox in a moment.