This module introduces the essential concepts and practices for backing up and recovering PostgreSQL databases. Learners will explore strategies to ensure data safety and continuity, gaining practical skills to manage and restore database systems effectively.

This module guides learners through the essentials of PostgreSQL backup, recovery, and replication, including configuration, transaction log management, and failover strategies. You will explore both physical and logical replication, learn to optimize system availability, and implement best practices for data durability and disaster recovery.

This module introduces key PostgreSQL extensions, focusing on their practical uses for database management and optimization. Learners will explore contrib modules, investigate caching with pg_buffercache, and analyze storage issues such as table bloat using pgstattuple. By the end, you'll be equipped to leverage extensions for enhanced database performance and diagnostics.

This module guides learners through systematic approaches to diagnosing and resolving common PostgreSQL performance issues. You will explore techniques for identifying slow queries, interpreting log files, addressing commit log corruption, and managing database connections effectively. By the end, you'll be equipped with practical troubleshooting skills to optimize PostgreSQL deployments.

This module guides learners through the process of migrating databases to PostgreSQL, highlighting common troubleshooting strategies and compatibility considerations. It covers key differences in SQL feature support, such as the FILTER clause, and provides practical insights for transitioning from Oracle to PostgreSQL.