Foundations of Postgres Administration – PostgreSQL Users
Get started with Postgres by taking Enterprise DB’s Postgres Database Administration Foundations course. In only a few days, you will receive comprehensive training to maximize your understanding and usage of Postgres, the #1 enterprise-class open source database.
In this course 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. It is based on the latest version of PostgreSQL 9.4.
Topics tested in the PostgreSQL Associate Certification exam will be covered, including:
- System Architecture
- Installation
- Configuration
- Creating and Managing Databases
- User Tools: Command Line Interface
- GUI Tools
- Security
- SQL Primer
- Backup and Recovery
- Point in Time Recovery
- Routine Maintenance Tasks
- Postgres Data Dictionary
- Moving Data
Duration: Approx. 17 hours
Recommended Pre-requisites:
- Intermediate knowledge of RDBMS concepts
- Basic understanding of SQL
- Basic experience with use of the Linux operating system (helpful)