PostgreSQL 11.4 Programming (Advanced)

Geometric Types, Composite Types, and Arrays, Using Transactions and Deferrable Constraints, Relations and Joins, Analytic, Ranking, and Aggregated Functions, Recursive CTE, Table Inheritance and Partitioning, Grouping Sets and Ranges, Managing NULLs, Joins