glossary
Transaction
Transaction is a SQL concept that helps learners reason about query meaning, result shape, and validation evidence before relying on a passing visible result.
Plain-language definition
Transaction means a practical SQL idea that changes how a learner should read tables, write queries, or interpret result shape.
In SQL Trail, the term is used only when it appears in lessons, feedback, reference pages, dataset notes, or mastery evidence.
Why it matters
Ignoring transaction can make a query look correct on a tiny visible dataset while failing hidden variants or edge cases.
The app therefore asks learners to connect definitions to output contracts, not just memorize vocabulary.
Tiny example
The small example below is a reading aid, not a full exercise. It shows how the concept changes the interpretation of a result.
BEGIN; UPDATE records SET reviewed = TRUE WHERE record_id = 1 RETURNING record_id; ROLLBACK;| Concept | Practical check |
|---|---|
| Transaction | Name the row meaning, edge case, or validation risk before trusting the output. |