EDB101 Postgres Advanced Server DBA Essentials

Date/Time
June 29, 2021 - July 1, 2021
09:00 - 17:00

Get started with Postgres by taking EnterpriseDB Postgres Advanced Server DBA Essentials course

This course,  EDB101 Postgres Advanced Server DBA Essentials gives students a unique opportunity to get trained and certified on the essentials for EDB Postgres Advanced Server database administration, to enhance skill proficiency using the latest and most powerful version of EDB Postgres Advanced Server.

Upon course completion, you will have the essential skills required to successfully install, configure, manage and maintain EDB Postgres Advanced Server and will be prepared to manage large, highly available databases and their technical requirements with confidence. You will learn the best practice approach for migrating Oracle objects to EDB Postgres and the powerful tools available to support the migration process.

*Note: This class is the foundation for the advanced courses that follows in the DBA track. It is based on the latest version of PostgreSQL and EnterpriseDB Postgres Advanced Server.

This class is available in v10, v11 and v12.

Course Outline

• Introduction to EDB Postgres Advanced Server.
• System Architecture.
• EDB Postgres Advanced Server Installation.
• Databases Clusters.
• Configuration.
• Creating and Managing Databases.
• User Tools: Command Line Interface.
• GUI Tools.
• Security.
• SQL Primer.
• Backup and Recovery and PITR.
• Performing Routine Maintenance Tasks.
• Data Dictionary.
• Moving Data Using COPY Command.
• EDB*Plus.
• Tablespaces.
• Oracle Compatibility.
• Migrating Oracle Objects to EDB Postgres Advanced Server.
• Data Loader.
• More: link

Target Audience

• Class is designed for DBAs, System Administrators, IT Professionals, who are responsible for administration and maintenance of EDB Postgres Advanced Server and need to understand how to use the primary features. It is supplemented with hands-on exercises that reinforce the material covered, and includes the ability to validate your skills, helping you to be more effective and get certified on EntepriseDB Postgres Advanced Server Associate Certification.

Recommended Prerequisites

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

Recommended next exam or course

• EDB201 Postgres Advanced Server DBA Advanced
• EntepriseDB Postgres Advanced Server Associate Certification