Indexing & Optimization
B+ tree indexes and execution plans: why a query is slow and which index changes it.
B+ tree indexes and execution plans: why a query is slow and which index changes it.
Redis, MongoDB and Neo4j: the data models that justify giving up a relational schema.
PostgreSQL and MySQL: the relational model, the planner and the operational differences between them.
ACID, MVCC and isolation levels: what a transaction guarantees and what it costs.