Tag: Tutorial

Inspect query plans with EXPLAIN / EXPLAIN ANALYZE.

Organize schemas to reduce redundancy and update anomalies.

Name intermediate result sets with WITH … AS clauses.

Walk hierarchies with recursive common table expressions.

Create saved queries as views for reuse and security layering.

Encapsulate multi-statement logic in stored procedures.

Create reusable scalar/table functions inside the database.

Run automatic actions on INSERT/UPDATE/DELETE events.

Group statements into all-or-nothing units of work.

Write subqueries that reference outer query rows.