Tag: Tutorial

Intentionally add redundancy for read performance when justified.

Model one-to-one, one-to-many, and many-to-many relations.

Link two tables where each row pairs with at most one row in the other.

Permanently save the current transaction’s changes.

Undo uncommitted transaction work with ROLLBACK.

Create partial rollback points inside a transaction.

Speed up lookups with indexes on frequently filtered/joined columns.

Understand how clustered indexes organize table data vs secondary indexes.

Index multiple columns for multi-column WHERE/ORDER BY patterns.

Write selective queries, use indexes, and avoid unnecessary work.