5 micro-topics in Data & Storage, each with the evidence that proves you have it and the written reason behind every link. Before you start, it rests on 2 other domains. Downstream, it holds up 4 domains.
5 topics · depth 1–4 of 16 · 4 internal links · 3 in · 4 out
Load-bearing links first. Each one says what in this domain rests on what outside it, and why.
2 links
Normalize a schema rests on Query rows with SELECT
You normalize toward the queries you can write.
Denormalize deliberately rests on Read a query plan
Denormalization is justified by a measured read path.
1 link
Version schema changes with migrations rests on Stage and commit changes
Migrations are versioned artifacts, and versioning habits carry over.
In prerequisite order. Each idea names the artifact that closes it, the market demand that put it on the map, and what it stands on.
Depth 1 · conceptual · unassisted · M07 §7.2
Removes duplication and update anomalies
Query rows with SELECT · SQL
You normalize toward the queries you can write.
Depth 2 · conceptual · unassisted · M07 §7.2
Enforces identity and referential integrity
Normalization is defined by keys.
Depth 2 · conceptual · guided · M07 §7.2
Trades duplication for read speed knowingly
You cannot denormalize deliberately without the normal form.
Read a query plan · SQL
Denormalization is justified by a measured read path.
Depth 3 · representational · unassisted · M07 §7.2
Expresses cardinality in tables
Choose primary and foreign keys
Cardinality is expressed with keys.
Depth 4 · procedural · scaffolded · M07 §7.2
Applies and reverses schema changes in order
Model one-to-many and many-to-many
Migrations change a schema you designed.
Stage and commit changes · Version Control
Migrations are versioned artifacts, and versioning habits carry over.
Everything downstream that names an idea here as a prerequisite, grouped by where it lives.
1 link
Build a repeatable ingestion pipeline rests on Choose primary and foreign keys
Idempotent loads require a key to upsert on.
1 link
Test against a real database rests on Version schema changes with migrations
A test database is created and torn down by migrations.
1 link
Store and query vectors in Postgres rests on Model one-to-many and many-to-many
Vectors live in a schema alongside their metadata.
1 link
Design an API contract rests on Model one-to-many and many-to-many
Resource shapes usually mirror the data model.
Retool. Retrain. Relaunch.
375 ideas. 17 weeks. No tuition, ever.
Vets Who Code is a veteran-run 501(c)(3). The accelerator is free, remote, and we don’t take a share of your first paycheck.
Free · Remote · 17 weeks · EIN 86-2122804