Writing Data & Transactions

Changing data correctly under concurrency: inserting, updating, deleting and upserting rows; transactions and the ACID guarantees; isolation levels and the anomalies they prevent; and how locking and deadlocks really work.