What you'll learn

Properly deploying and maintaining PostgreSQL is essential for creating a stable, secure, and high-performing data platform. In this course, PostgreSQL Core Administration and Operational Maintenance, you’ll learn the foundational skills every PostgreSQL DBA needs to manage production environments with confidence. First, you’ll start by installing PostgreSQL on Linux and performing the initial configuration. Next, you’ll implement reliable backup and recovery strategies using both logical and physical methods, including write-ahead logging and continuous archiving for point-in-time recovery. Finally, you’ll explore how to keep the environment healthy and performant through routine maintenance. By the end of this course, you’ll be able to install, configure, secure, back up, and maintain PostgreSQL instances, giving you the practical skills needed to create stable and resilient database environments.