PG101 Foundations of PostgreSQL Administration

Date/Time
July 6, 2021 - July 8, 2021
09:00 - 17:00

Get started with Postgres by taking EnterpriseDB PostgreSQL Database Administration Foundations course

This course, PG101 Foundations of PostgreSQL Administration, presents the PostgreSQL database architecture and core administrative tasks. You will learn the essential details of Postgres Administration including architecture, configuration, maintenance, monitoring, backup, recovery, and data movement. It will also introduce you to enterprise class tools for Postgres administration and will prepare you to handle real time, production environments. It is designed for people with experience in database administration who are new to Postgres.

This class conveys the knowledge you will need to perform your duties as a Postgres DBA, and is the foundation for the advanced courses that follow in the DBA track.

This class is available in v10, v11 and v12.

Course Outline

• Postgres System Architecture
• Installation and Getting Started
• Configuration
• Creating and Managing Databases
• User Tools – Using PGSQL
• GUI Tools – Using pgAdmin 4
• Security Basics
• SQL Primer
• Backup and Recovery
• Routine Maintenance
• Postgres Data Dictionary
• Moving Data
• More: link

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.

Recommend Prerequisites

• Basic experience in database administration and knowledge of RDBMS concepts.
• Understanding of SQL.
• Basic experience with use of the Linux operating system (helpful).

Recommended next exam or course

• PG201 Advanced PostgreSQL Administration
• PG301 PostgreSQL for Developers and Architects
• PostgreSQL Associate Certification