Project 18: Account Verification Transaction
SQL Architect
Builds on these lessons
Query Task
Objective
A transaction groups statements together: BEGIN starts one, COMMIT makes every change inside it permanent at once. (ROLLBACK, the other option, would undo everything since BEGIN instead — useful the moment something inside the transaction goes wrong.)
You're given an accounts table with columns id and is_verified.
Task: inside a transaction, mark the account with id of 501 as verified, then commit it.
query.sql
BEGIN;
UPDATE accounts SET is_verified = true WHERE id = 501;
COMMIT;
* Hint: Correct characters turn green, incorrect ones turn red.
Query Results
🗄️
Execute your query to see results