Skip to main content
Interactive Learning Path

Databases Curriculum.

A structured path through schema design, indexing, transactions, and query performance.

This learning path focuses on design correctness first, then performance evidence.

Suggested learning order

  1. Database design basics (entities, keys, constraints)
  2. Indexing + transactions (how correctness and performance interact)
  3. Query performance engineering (EXPLAIN → diagnose → change → verify)

Roadmap Curriculum

1
databases Step 1 of 3

Database Design Basics (Beginner)

Learn how to model data, choose keys, define relationships, and create a schema that supports reliable queries.

2
databases Step 2 of 3

Indexes & Transactions (Intermediate)

Design useful indexes and understand transactional guarantees: isolation levels, atomicity, and consistency tradeoffs.

3
databases Step 3 of 3

Query Performance Engineering (Advanced)

Use EXPLAIN plans, statistics, indexes, and query rewrites to improve latency and throughput with safe tradeoffs.