🎁 New User? Get 20% off your first purchase with code NEWUSER20 Register Now →
Menu

Categories

Databases Intermediate

What is Transaction?

A sequence of database operations that are treated as a single unit — either all succeed or all are rolled back.

Transactions ensure data consistency through ACID properties: Atomicity (all or nothing), Consistency (valid state transitions), Isolation (concurrent transactions don't interfere), and Durability (committed data persists).

Commands include BEGIN/START TRANSACTION, COMMIT (save changes), and ROLLBACK (undo changes). Isolation levels (READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, SERIALIZABLE) balance consistency and performance.

Related Terms

PostgreSQL
An advanced open-source relational database known for its reliability, feature richness, and standards compliance.
Database Proxy
A middleware server that sits between applications and databases, providing connection pooling, load balancing, and query routing.
Stored Procedure
A precompiled collection of SQL statements stored in the database that can be executed as a single unit.
CTE (Common Table Expression)
A temporary named result set defined within a SQL statement using the WITH clause, improving query readability and enabling recursion.
Graph Database
A database that uses graph structures with nodes, edges, and properties to store and query highly connected data.
Primary Key
A column or set of columns that uniquely identifies each row in a database table.
 View All Databases Terms →