Transactions and ACID

Understand the idea

In this lesson, explore transactions and acid. Study the SQL example, run it in the lab when applicable, and consider how it relates to real database systems.

BEGIN; UPDATE students SET score=score+1 WHERE id=1; ROLLBACK;