Reading and quiz record
What you have covered, and what is next
Everything here is stored in your browser only. Nothing is sent anywhere.
Your marks appear here once scripts load. The full list of topics:
Start here
Fundamentals
Network & edge
Application
Data
Databases
- SQL playground
- How a table is stored
- B-tree indexes
- Designing indexes
- Scan types
- Reading EXPLAIN
- Join algorithms
- Planner statistics
- Pagination and N+1
- Common table expressions
- Window functions and materialized views
- Views, functions and triggers
- Transactions
- Isolation levels and MVCC
- Locks and deadlocks
- Connection pooling
- Partitioning
- Replicas and sharding
- Slow query checklist
- Database interview questions
- Query-tuning exercises