About This Book
PART I — GETTING STARTED 01 Installation & Setup Linux · macOS · Windows · Docker 02 First Steps with PostgreSQL psql · pgAdmin · Connections 03 Databases & Schemas Create · Manage · Namespaces PART II — DATA DEFINITION 04 Data Types Numeric · Text · Date · JSON · Arrays 05 DDL: Tables & Constraints CREATE · ALTER · DROP · Constraints 06 Indexes B-Tree · Hash · GIN · GiST · BRIN PART III — QUERYING DATA 07 Basic SELECT Queries Filtering · Sorting · Limiting 08 Joins INNER · LEFT · RIGHT · FULL · CROSS · SELF 09 Aggregation & Grouping GROUP BY · HAVING · Aggregate Functions 10 Subqueries & CTEs Correlated · WITH · Recursive CTEs PART IV — ADVANCED SQL 11 Window Functions ROW_NUMBER · RANK · LAG · LEAD · OVER 12 DML: Modifying Data INSERT · UPDATE · DELETE · UPSERT 13 Transactions & Concurrency ACID · Isolation Levels · Locks 14 Views & Materialized Views CREATE VIEW · REFRESH · Partitioned PART V — PROGRAMMABILITY 15 Functions & Procedures PL/pgSQL · Parameters · Returns 16 Triggers Row-level · Statement-level · Event Triggers 17 JSON & JSONB Operators · Functions · Indexing JSON PART VI — PERFORMANCE & OPS 18 Query Optimisation EXPLAIN · ANALYZE · Planner Statistics 19 Full-Text Search tsvector · tsquery · GIN Indexes 20 Partitioning Range · List · Hash · Inheritance 21 Security & Roles Users · GRANT · Row-Level Security 22 Replication & Backup Streaming · Logical · pg_dump
What You'll Learn
Reader Reviews
No reviews yet
Be the first to share your thoughts!

