PostgreSQL in Depth: From Basics to Practice

This book is an introductory-to-intermediate hands-on tutorial on PostgreSQL, written for PostgreSQL 10 and organized around a "theory plus practice" approach. Through numerous runnable examples, it explains PostgreSQL's SQL features, parameter configuration, backup and recovery, performance tuning, server-side programming, and high-availability solutions. The book follows a five-part learning path. Part 1, "Preparation," introduces PostgreSQL's origins, basic concepts, architecture, major new features in version 10, and installation, startup, and shutdown on Windows and Linux. Part 2, "Getting Started," begins with creating databases and tables and then covers data types and operators, common functions, and querying, inserting, updating, and deleting data, including table joins, subqueries, fuzzy matching, and window functions. Part 3, "Advanced," explains indexes (including distinctive types such as GiST, SP-GiST, GIN, and BRIN), views and materialized views, triggers, table inheritance and declarative table partitioning, user privileges and schema management, server configuration management, and backup and recovery. Part 4, "Expert," discusses transactions, SQL statement optimization, server-side performance optimization, and PL/pgSQL programming. Part 5, "In Practice," presents high-availability solutions and examples of logical database design, closing with the complete design of a product management database. The book is clearly structured and rich in examples, with accompanying sample materials and source code. It suits database developers, operations and maintenance staff, and university students and teachers in related fields as a self-study tutorial or teaching reference.