Transactions and ACID properties: The four guarantees (atomicity, consistency, isolation, durability) that make a transaction feel like one indivisible unit.
NoSQL data models: Alternatives to tables: documents, key-value pairs, wide columns, or graphs, each suited to a different access pattern.
Related topics
Entity-relationship modeling: Sketching entities and their relationships as a diagram before turning them into tables.
Relational algebra: The formal, math-like operations SQL actually compiles down to under the hood.
NoSQL data models: Alternatives to tables: documents, key-value pairs, wide columns, or graphs, each suited to a different access pattern.