Practice query planning, data consistency, migration safety, application caching, HTTP caching, and traffic shaping.
Practice path · 10 games
Data & Performance
Practice query planning, data consistency, migration safety, application caching, HTTP caching, and traffic shaping.
Useful before database, caching, and performance interviews.
Start this path01 Databases Intermediate
Choose the best database index for simplified schemas and queries while learning full scans, covering indexes, sort avoidance, and composite order.
- Time
- 7-10 minutes
- Concept
- Database indexing and query performance
- Data & Performance
- Algorithmic Reasoning
- SQL
- indexes
- performance
Play SQL Index Quest 02 Databases Advanced
Investigate PostgreSQL query plans, cardinality gaps, scan choices, join amplification, and rollout evidence.
- Time
- 9-12 minutes
- Concept
- SQL query planning and cardinality
- Data & Performance
- SQL Indexes
- Performance
- Databases
Play Query Plan Investigator 03 Databases Advanced
Choose composite and partial indexes while accounting for MVCC churn, bloat, and partition lifecycle.
- Time
- 8-11 minutes
- Concept
- Index and storage strategy
- Data & Performance
- SQL Indexes
- MVCC
- Databases
Play Index & Storage Strategy Lab 04 Reliability Advanced
Triage blocking chains, slow-query regressions, expand-contract changes, and resource-safe database rollouts.
- Time
- 10-12 minutes
- Concept
- Production database incident response
- Data & Performance
- Databases
- Incidents
- Schema Migrations
Play Slow Query & Change War Room 05 Databases Advanced
Defend database invariants from concurrent requests by choosing transactions, locks, constraints, snapshot reads, and optimistic concurrency.
- Time
- 7-10 minutes
- Concept
- Database transactions, isolation anomalies, locks, and invariant protection
- Data & Performance
- Database Reliability
- SQL
- transactions
- isolation
Play Transaction Isolation Arena 06 Databases Intermediate
Choose safe zero-downtime database migration steps for expanding schemas, backfilling data, rolling out indexes, enforcing constraints, and recovering from failures.
- Time
- 6-9 minutes
- Concept
- Zero-downtime schema migration planning and expand-contract releases
- Data & Performance
- Database Reliability
- migrations
- schema design
- backfill
Play Schema Migration Runbook 07 Caching Beginner
Predict cache hits and misses as requests flow through an LRU cache, then experiment with TTL behavior and stale data tradeoffs.
- Time
- 5-8 minutes
- Concept
- Cache hits, misses, LRU, TTL, and stale data
- Data & Performance
- Algorithmic Reasoning
- cache
- LRU
- TTL
Play Cache Eviction Lab 08 Scaling Intermediate
Choose rate limiting designs for realistic backend traffic patterns, from public APIs and login endpoints to queues, webhooks, and retry storms.
- Time
- 6-9 minutes
- Concept
- Rate limiting, fairness, backpressure, and abuse protection
- Data & Performance
- Rate limiting
- Scaling
- 429
Play Rate Limit Architect 09 HTTP Caching Intermediate
Choose browser and shared-cache policies for public, personalized, validated, and variant API responses.
- Time
- 7-10 minutes
- Concept
- HTTP cache policy and sensitive response boundaries
- Data & Performance
- http caching
- cache-control
- privacy
Play HTTP Cache Policy Lab 10 HTTP Caching Advanced
Follow validators through browser, CDN, and origin while handling 304 responses, representation variants, purge, and bounded staleness.
- Time
- 8-12 minutes
- Concept
- Conditional requests and CDN cache operation
- Data & Performance
- etag
- cdn
- conditional requests
Play ETag & CDN Revalidation Lab