Curriculum

Data Storage & Retrieval

Relational modelling, indexes, transactions, the NoSQL families and what each one is actually for, then replication and sharding. More interviews are lost on the storage layer than on any other part of the diagram.
Free
6 modules · 30h · 31 lessons · Beginner
Relational Modelling
5 hours
5 lessons
Beginner
Relational Modelling
Free
02.1
Indexes & Query Plans
5 hours
5 lessons
Beginner
Indexes & Query Plans
Free
02.2
Transactions & Isolation
5 hours
5 lessons
Beginner
Transactions & Isolation
Free
02.3
NoSQL & Choosing a Data Model
5 hours
6 lessons
Beginner
NoSQL & Choosing a Data Model
Free
02.4
Replication
5 hours
5 lessons
Beginner
Replication
Free
02.5
Partitioning & Sharding
5 hours
5 lessons
Beginner
Partitioning & Sharding
Free
02.6
The drills in this track
02.1 · Schema

Turn six requirements into a schema, then survive three change requests that a bad model cannot absorb.

02.2 · Seek

Eight slow queries, one index budget. Spend it where it changes the plan, not where it looks obvious.

02.3 · Anomaly

Two transactions interleave. Name the anomaly and the lowest isolation level that would have prevented it.

02.4 · Fit

Match a workload to a store. The wrong family costs you a rewrite three requirements later.

02.5 · Quorum

Tune R, W and N against a failure schedule. Read a stale value and the round ends.

02.6 · Skew

One partition is taking 80% of the traffic. Reshard it live, without dropping a write.

Every track is free. Start anywhere.