Database Transactions and ACID Properties
Transactions treat operations as single units—all succeed or all fail. ACID properties: Atomicity (all-or-nothing), Consistency, Isolation, Durability.
January 2026
Database Indexing Explained
Database indexes use B-tree structures maintaining sorted pointers to rows. Like book indexes, they enable fast lookups without scanning entire tables.