Using transactions and isolation levels

To ensure data integrity, it is essential that you can identify states in which the information in your database is consistent. The concept of consistency is best illustrated through an example:

 Consistency example
 Transactions are logical units of work

Using transactions
Introduction to concurrency
Savepoints within transactions
Isolation levels and consistency
Transaction blocking and deadlock
How locking works
Choosing isolation levels
Isolation level tutorials
Primary key generation and concurrency
Data definition statements and concurrency
Summary