Category: SQL

Understand SQL injection as a risk and prevent it with safe query patterns.

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

Ensure atomic values and no repeating groups in 1NF.

Remove partial dependencies on composite keys for 2NF.

Remove transitive dependencies for 3NF.

Intentionally add redundancy for read performance when justified.

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

Permanently save the current transaction’s changes.

Undo uncommitted transaction work with ROLLBACK.

Create partial rollback points inside a transaction.