Based on the role Data Architect
Databases
Build the universal mental model that every database is implemented against — the relational model, schemas and keys, indexes, transactions, concurrency, PostgreSQL architecture, production operations, modeling patterns, and the modern data ecosystem (NoSQL, distributed SQL, warehouses, vectors, streaming).
12 lessons
What you'll learn
Main Path
The mandatory throughline of this roadmap.
Unit 1
Databases
Build the universal mental model that every database is implemented against — the relational model, schemas and keys, indexes, transactions, concurrency, PostgreSQL architecture, production operations, modeling patterns, and the modern data ecosystem (NoSQL, distributed SQL, warehouses, vectors, streaming).
12 lessons
- What a Database Actually Is
- The Relational Model
- Schemas, Keys, and Integrity
- Fluent SQL — Reads and Joins
- Indexes — Why Queries Get Fast (and Slow)
- Transactions and ACID
- Concurrency — How the Engine Keeps You Sane
- Inside PostgreSQL
- Reading EXPLAIN — Diagnose Any Slow Query
- Running a Database in Production
- Modeling Real-World Domains
- Beyond OLTP — The Modern Data Ecosystem
Explore more roadmaps
Frequently asked questions
What does the Databases roadmap cover?
1 unit: Databases.
How do I start the Databases roadmap?
Get the Mochivia app on the App Store and open this roadmap there.