Full-Stack Software EngineerIntermediate8 modules~4.0 hours hands-on
Database Engineering — Relational & NoSQL
Master relational database design, normalization, ACID properties, advanced SQL, indexing, and NoSQL trade-offs to make confident data storage decisions.
// What you'll be able to do- Tables, keys, relationships, and normalization
- Joins, aggregations, subqueries, and window functions
- Reliable data and SQL injection prevention
- B-trees, EXPLAIN ANALYZE, and optimization strategy
8 modules, built to run
Every module ships runnable code. Expand any one to see what's inside.
00IntroductionWhat problem databases solve and why it matters30 min
Objective — What problem databases solve and why it matters
Start moduleFree preview
01The Relational ModelTables, keys, relationships, and normalization30 min
Objective — Tables, keys, relationships, and normalization
02SQL MasteryJoins, aggregations, subqueries, and window functions30 min
Objective — Joins, aggregations, subqueries, and window functions
03ACID, Transactions & SecurityReliable data and SQL injection prevention30 min
Objective — Reliable data and SQL injection prevention
04Indexes & Query PerformanceB-trees, EXPLAIN ANALYZE, and optimization strategy30 min
Objective — B-trees, EXPLAIN ANALYZE, and optimization strategy
05NoSQL & the CAP TheoremDocument stores, key-value, and consistency trade-offs30 min
Objective — Document stores, key-value, and consistency trade-offs
06ORMs & MigrationsPrisma schema, type-safe queries, and versioned changes30 min
Objective — Prisma schema, type-safe queries, and versioned changes
07Pattern SynthesisChoosing the right database for any scenario30 min
Objective — Choosing the right database for any scenario
Ready to start Database Engineering — Relational & NoSQL?
Jump into Module 0 — no account required.