PostgreSQL

PostgreSQL from basics to advanced features. JSONB, full-text search, window functions, partitioning, indexing strategies, and production tuning.

BeginnerTopics 1–10

·What Is PostgreSQL?
·Install & psql
·Databases & Schemas
·CREATE TABLE & Types
·INSERT & RETURNING
·SELECT & Filtering
·UPDATE & DELETE
·WHERE & Operators
·JOINs: Linking Tables
·Indexes: Performance

Start Beginner →

IntermediateTopics 1–10

·EXPLAIN & Query Plans
·Transactions & Isolation
·CTEs: Clean Queries
·Window Functions
·JSONB: NoSQL in SQL
·Arrays & Composites
·Full-Text Search
·Triggers & Functions
·Roles & Row-Level Security
·Table Partitioning

Start Intermediate →

AdvancedTopics 1–10

·Query Planner Deep Dive
·Parallel Query
·Index Types: GIN, GiST, BRIN
·Custom Types & Domains
·MVCC Internals
·Vacuuming & Bloat
·Extensions: pgvector & PostGIS
·Foreign Data Wrappers
·Logical Decoding & Replication
·Advisory Locks

Start Advanced →

ProductionTopics 1–10

·HA with Patroni
·pgBouncer Pooling
·PITR & WAL Archiving
·pgBackRest Backups
·Monitoring & Stats
·Zero-Downtime Migrations
·Security & pg_hba.conf
·Vacuuming Strategy
·Cloud Postgres Options
·Streaming Replication

Start Production →