Database Transactions (ACID)

This computer science lesson covers the principles of database transactions with some simple examples. The ACID properties of a typical database transaction are described including Atomic, Consistent, Isolated and Durable. This tutorial briefly introduces the code of a Transact SQL (T-SQL) stored procedure that defines a transaction, including use of the commands BEGIN TRANSACTION, COMMIT TRANSACTION and ROLLBACK TRANSACTION.

Chapters:
00:00 ACID database transactions introduction
00:07 Example of a database transaction (bank accounts)
01:51 Definition of a database transaction
02:52 Example of a database transaction (archive students)
03:38 Implementing database transactions with SQL stored procedures
05:44 ACID properties of data transactions