SQL Fundamentals

Basic Transactions: Next

INSERT, UPDATE, DELETE Statements Transaction Control (ACID) Isolation Levels Transfer money between accounts using transaction Test UPDATE with ROLLBACK before

INSERT, UPDATE, DELETE Statements

Transaction Control (ACID)

Isolation Levels

Transfer money between accounts using transaction

Test UPDATE with ROLLBACK before committing

Handle error with ROLLBACK

Batch insert with periodic commits

Describe when to COMMIT, when to ROLLBACK, and how long transactions affect concurrency.

Transaction Control (ACID)

Isolation Levels

Database Engines & ACID Properties