Intro & Setup
The relational model, run Postgres with Docker, psql + pgAdmin, databases & schemas, connecting drivers. Start →
PostgreSQL — From Zero to Hero
A standalone, beginner→advanced course on PostgreSQL. From the relational model and SQL through joins, indexing, transactions & MVCC, JSONB and full-text search, to production scaling — every operation shown in psql, Node.js, Python, Go, and Rust, with pgAdmin tours and a Docker setup.
What you’ll learn
Section titled “What you’ll learn”Tables & Types
CREATE TABLE, the type system (JSONB, arrays, UUID, enum), constraints (PK/FK/CHECK), schema migrations. Model →
CRUD & SQL
INSERT, SELECT & filtering, UPDATE/DELETE with RETURNING, ON CONFLICT upsert. Query →
Joins & Relationships
INNER/LEFT/RIGHT/FULL joins, aggregates & GROUP BY, subqueries & CTEs, window functions. Combine →
Indexes & Performance
B-tree & specialized indexes (GIN/GiST/BRIN), EXPLAIN ANALYZE, query plans, VACUUM & statistics. Speed up →
Transactions & Concurrency
BEGIN/COMMIT/ROLLBACK, isolation levels, MVCC, row locking & deadlocks. Stay correct →
Advanced PostgreSQL
JSONB, full-text search, views & materialized views, PL/pgSQL functions & triggers. Go deeper →
Operations & Scaling
Replication, connection pooling (PgBouncer), partitioning, backup/PITR & security (roles, RLS). Run it →
How this course works
Section titled “How this course works”Five ways to run every query
Each operation is shown in psql, Node.js, Python, Go, and Rust — synced tabs, so pick your driver once and follow it through.
See the result set
Queries show their actual output as psql-style result tables, so you always know exactly what comes back.
Diagrams + pgAdmin + Docker
Theme-aware Mermaid diagrams (joins, query plans, MVCC, replication), pgAdmin GUI tours, and a Docker setup to run it locally.
Bilingual + read mode
English and ไทย, quizzes with saved progress, and a distraction-free read mode.