Free
5h · 5 lessons
Overview
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.
This module is 02.2 of the 6 in Data Storage & Retrieval. It runs about 5 hours across 5 lessons, and closes with Seek — Eight slow queries, one index budget. Spend it where it changes the plan, not where it looks obvious.
Lessons
1. B-trees, and what an index really is
Concept · 40 minutes
2. Composite indexes and column order
Concept · 35 minutes
3. Covering indexes and index-only scans
Concept · 30 minutes
4. LSM trees and write-optimized storage
Concept · 40 minutes
5. Read a query plan and fix the scan
Lab · 60 minutes
Before this
Module information
Duration
5 hours
Lessons
5
Level
Beginner
Track
Data Storage & Retrieval
Drill
Seek
Price
Free
Related modules
