Foundations of Postgres Administration

This course presents the PostgreSQL database architecture and core administrative tasks including configuration, maintenance, monitoring, backups, recovery, and moving data. It also introduces learners to enterprise class tools for Postgres administration and prepares them to handle real time, production environments. Upon course completion, the learners will be prepared to manage large, highly available Postgres databases with confidence.

Skip to Available Dates

Learning Objectives

This certification exam assesses and certifies a database professional to demonstrate the fundamental skills necessary to maintain and manage a PostgreSQL server and applications in a production environment.

 

Course Details

Course Outline

1 - Introduction and Architectural Overview
  • 2 - System Architecture
  • 3 - PostgreSQL Installation
  • 4 - EDB Postgres Advanced Server Installation
  • 5 - Database Clusters
  • 6 - Configuration
  • 7 - Creating and Managing Databases
  • 8 - Command Line User Tools
  • 9 - GUI Tools
  • 10 - Security Basics
  • 11 - SQL Primer
  • 12 - Backup, Recovery, and PITR
  • 13 - Routine Maintenance
  • 14 - Data Dictionary
  • 15 - Moving Data
  • Actual course outline may vary depending on offering center. Contact your sales representative for more information.

    Who is it For?

    Target Audience

    This course is intended for DBAs and IT Professionals who are responsible for administration and maintenance of PostgreSQL or EDB Postgres Advanced Server. It teaches the essential skills required by Postgres DBAs to be successful.

    Foundations of Postgres Administration

    Call
    Course Length : 2 Days

    There are currently no scheduled dates for this course. Please contact us for more information.

    Need Help Picking the Right Course? Give us a call! +359 2 421 0040