BBuddyAI Learn
Databases · Beginner → Expert

🐘 PostgreSQL Developer and DBA Masterclass

Learn PostgreSQL SQL, data types, extensions, indexing, transactions, security, backup, replication, monitoring and production tuning.

Sign in to enroll

Course roadmap

Pass each module exam to unlock the next module.

Module 1 · Beginner

PostgreSQL Architecture, Installation and Tooling

Locked
Module 2 · Beginner

SQL Querying and PostgreSQL Data Types

Locked
Module 3 · Beginner

Joins, Aggregates, Windows, CTEs and Set Operations

Locked
Module 4 · Beginner

Schema Design, Constraints and Normalization

Locked
Module 5 · Intermediate

MVCC, Transactions, Isolation and Locking

Locked
Module 6 · Intermediate

Indexes, Planner Statistics and EXPLAIN

Locked
Module 7 · Intermediate

Functions, Procedures, Triggers and Extensions

Locked
Module 8 · Intermediate

JSONB, Arrays, Full-Text Search and Advanced Types

Locked
Module 9 · Advanced

Roles, Privileges, Authentication and Encryption

Locked
Module 10 · Advanced

Backup, Restore, PITR and Archiving

Locked
Module 11 · Advanced

VACUUM, Autovacuum and Storage Maintenance

Locked
Module 12 · Advanced

Monitoring, Logs and Query Troubleshooting

Locked
Module 13 · Expert

Streaming Replication and High Availability

Locked
Module 14 · Expert

Partitioning, Scaling and Connection Pooling

Locked
Module 15 · Expert

Migration, Import, Export and Upgrade Strategy

Locked
Module 16 · Expert

Expert Capstone: Production PostgreSQL Platform

Locked
Certification gate

Final course exam

Pass mark: 80%. Time limit: 360 minutes. All module exams must be passed first.

Locked until modules are passed