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