PostgreSQL Tutorial

Learn to use PostgreSQL's jsonb data type for flexible, schema-less data models. This lesson explains when and how to choose jsonb over traditional relational columns, with a hands-on example, performance considerations, and common pitfalls.

Design effective index strategies for PostgreSQL to speed up queries and keep writes fast. Learn when to use B-tree, GIN, or partial indexes, how to avoid common pitfalls like redundant or unused indexes, and how to monitor and adjust your design as your data grows.

Learn to monitor slow queries with pgBadger in this PostgreSQL tutorial. Practical steps, troubleshooting, and next steps included.

Learn how to back up PostgreSQL databases using pg_dump. This lesson covers the core concepts, step-by-step commands, practical examples, and common troubleshooting tips to ensure your data is safe.

Restore databases with pg_restore — PostgreSQL Tutorial. Hands-on steps, troubleshooting, and what to study next.

Learn to schedule PostgreSQL backups using cron and pg_dump. This tutorial covers the core concepts, step-by-step implementation, practical examples, and troubleshooting tips to automate your database backups effectively.

Configure PostgreSQL streaming replication for a standby server. Step-by-step setup, wal_level, primary_conninfo, and verification.

Use Patroni for high availability — PostgreSQL Tutorial. Learn core concepts, hands-on steps, troubleshooting, and what's next.

Load balance reads with HAProxy — PostgreSQL Tutorial.

Learn to partition tables by range and list in PostgreSQL — practical steps, troubleshooting, and what to study next.

Learn to use declarative partitioning in PostgreSQL. Understand the core concept, apply it in a hands-on exercise, and discover best practices for performance and maintenance.

Learn how to migrate data into PostgreSQL using pgloader. This hands-on tutorial covers the core concepts, step-by-step migration, troubleshooting, and what to explore next.