The ACID properties of transactions
ACID
Transaction isolation levels
Locking concepts
Using explicit table locks
Using advisory locks