🗄️ Database & SQL Language
7 exercise sets. Master the English vocabulary backend developers, DBAs, and data engineers use in schema reviews, query optimization discussions, and database incident communication.
SQL Query Description
Describing SQL operations in English: joins, aggregations, subqueries, filters, and window functions.
Schema Design Vocabulary
Normalization, denormalization, relationships, constraints, and data modelling vocabulary.
Database Migration Language
Migration vocabulary: up/down migrations, zero-downtime, backfill, breaking vs. non-breaking schema changes.
Query Optimization Discussion
EXPLAIN output, sequential scan, index scan, N+1 problem, query plan vocabulary for reviews and discussions.
Indexing Strategy Language
B-tree, partial, composite, covering index types — when to use each and how to discuss trade-offs.
Database Incident Language
Replication lag, deadlock, connection pool exhaustion, failover — communicating database incidents.
Transactions & Concurrency
ACID, isolation levels, optimistic vs. pessimistic locking, phantom reads — advanced database vocabulary.