Learn PostgreSQL — Beginner to Advanced

PostgreSQL is the world's most advanced open-source relational database — and arguably the most beloved one. This free hands-on tutorial covers the SQL you'll write every day plus the Postgres super-powers: JSONB, arrays, CTEs, LATERAL joins, GIN/GiST indexes, and more.

The track is organised by topic, with concise explanations, real psql examples, and practice exercises. Use the sidebar to jump straight to the feature you need, or follow the curriculum in order from Introduction to PostgreSQL through to advanced performance topics.

What you'll learn in this PostgreSQL tutorial

• psql, connections, and the PostgreSQL CLI workflow
• Data types including arrays, JSONB, hstore, and ranges
• Joins, CTEs, window functions, and LATERAL queries
• INSERT, UPDATE, DELETE, UPSERT with ON CONFLICT
• Schemas, sequences, and B-tree / GIN / GiST indexes
• Transactions, isolation levels, and EXPLAIN ANALYZE