Transactions & Concurrency
ACID, MVCC and isolation levels: what a transaction guarantees and what it costs.
Indexing & Optimization
B+ tree indexes and execution plans: why a query is slow and which index changes it.
Ranking & Relevance
TF-IDF and BM25: the scoring functions behind a search result order.