What are Transactions?
The ACID properties of SQL Transactions, What are the different ACID properties of a transaction how they ensure that data is Atomic, Consistent, Isolated, and Durable.
ACID
Transactions and Errors
SQL Transaction and Error Handling? What is the difference between Auto-Commit and Explicit Transactions and how transaction affect Errors and Exception Handling?
What are Locks?
What is a Lock? What is the process that transactions use to lock records to provide transaction isolation.