Postgres by Example

"Postgres by Example" is a hands-on, free learning resource that teaches PostgreSQL through short, annotated SQL lessons paired with runnable code examples. The guide covers essential topics from basic queries and data modeling to advanced features like transactions, stored functions, and full-text search, requiring PostgreSQL 14 or newer and progressing from foundational concepts to day-to-day database operations. Readers can work through lessons sequentially or browse specific topics, with each lesson including explanations, executable SQL files, and exercises to reinforce learning.