Get the app

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

Download on the App Store
Explore with AI:ChatGPTClaudePerplexity
Main Path

What you'll learn

Main Path

The mandatory throughline of this roadmap.

  1. 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
    1. What a Database Actually Is
    2. The Relational Model
    3. Schemas, Keys, and Integrity
    4. Fluent SQL — Reads and Joins
    5. Indexes — Why Queries Get Fast (and Slow)
    6. Transactions and ACID
    7. Concurrency — How the Engine Keeps You Sane
    8. Inside PostgreSQL
    9. Reading EXPLAIN — Diagnose Any Slow Query
    10. Running a Database in Production
    11. Modeling Real-World Domains
    12. Beyond OLTP — The Modern Data Ecosystem

Explore more roadmaps

Law
Legal literacy — how law actually works. The trunk gives you the operating system: where law comes from, how courts and precedent work, contracts, torts, property, criminal vs civil, and constitutional structure. Clusters dive into reading cases, contract mechanics, IP, your rights with police, and the startup legal toolkit.
Sales
A working understanding of the craft of selling — buyer psychology, discovery, qualification, objection handling, negotiation, and pipeline math. The trunk walks one complete deal motion from prospect to close to expansion; clusters dive into outbound mechanics, discovery frameworks, objection playbooks, negotiation, founder-led sales, and enterprise deals.
Psychology
A working understanding of psychology — what the science actually claims about how minds, brains, and behavior fit together. The trunk gives you the orientation a literate professional needs (how psychology knows what it knows, the brain behind behavior, learning, memory, decision-making, emotion, personality, social influence, development, pathology, and what therapy does); clusters dive into research methods, perception, cognition mechanics, social influence tactics, the field guide of disorders, applied behavioral science, and the psychology of everyday life.
Algebra & Precalculus
The foundation curriculum that prepares you for any university-level math course — calculus, linear algebra, discrete math, statistics. Builds symbolic fluency from variables and equations through functions, polynomials, exponentials, trigonometry, and the proof and set-theory groundwork that modern mathematics rests on.
Environmental Science
A coherent, mechanistic picture of how the Earth actually works as a coupled system — its biogeochemical cycles, climate physics, ecosystems, pollution pathways, and the leverage points where solutions live. The trunk gives you the throughline a working professional needs to reason about environmental claims; clusters dive into circulation, ecology, paleoclimate, climate modeling, pollution, energy, and mitigation.
Music Theory
A working understanding of how music is built — the twelve-note system, intervals, scales, keys, chords, harmony, rhythm, and form. The trunk gives you the complete map from a single note to a finished song; clusters dive deep into modes, the circle of fifths, chord construction, progressions, rhythm, melody, and form.

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.

Start Databases

Download on the App Store