Engineering craft
Databases
SQL, indexes, transactions.
- •150 XPRelational ModelTables, keys, and the rules that keep data sane.
- •175 XPQueriesSELECT everything you need to know.
- •175 XPIndexesFrom full scan to seek: how engines find rows fast.
- •200 XPTransactionsACID, isolation, and what can go wrong when two queries run at once.
- •225 XPScalingRead replicas, sharding, pools, and caches — when one server is not enough.