ACID guarantees, isolation levels, deadlocks, and distributed transactions — keep data consistent.
Five passes over the same idea, each from a different angle. Do them in order, or jump to whichever you need.
Transactions ensure ACID properties: Atomicity, Consistency, Isolation, Durability. Isolation levels (Read Uncommitted → Serializable) trade consistency for concurrency. MVCC enables concurrent reads. Deadlock detection and prevention strategies. Distributed transactions use 2PC or saga patterns.
Where this topic shows up outside its home domain:
