Data Layer
10 questions drawn from the 5 chapters in this section. If most land on the first try, you are ready for the next section. If not, the explanation after each answer says which idea to revisit.
Checkpoint
10 questions · first-try answers earn the most XP
What this checkpoint covers
SQL vs NoSQL
When rows win, when documents/keys win.
Database Indexes & Slow Queries
Why a query goes from 8ms to 8 seconds, and how EXPLAIN tells you why.
Replication & Sharding
Read replicas vs split writes, hot keys.
Consistent Hashing
Why adding a server shouldn't reshuffle everything - ring hashing explained.
Full-Text Search Basics
Inverted index, ranking, and why SQL LIKE stops working.
Put it to work in a drill
Next section: Caching and Delivery