EDB201 Postgres Advanced Server DBA Advanced

Date/Time
June 21, 2021 - June 23, 2021
09:00 - 17:00

Increase your knowledge and enhance your skill proficiency using the latest and most powerful version of Postgres Advanced Server

This training, EDB201 Postgres Advanced Server DBA Advanced,  takes the Postgres database administrator beyond the basics covered in the Essentials, EDB101 Postgres Advanced Server DBA Essentials, class. You will learn how to best fulfil the more advanced DBA responsibilities including database tuning and benchmarking, monitoring, setting up high availability and replication, and more. The concepts and architecture that support these more in-depth topics, along with the options available to carry them out, are covered in detail. This includes how to make the best use of tools available to more efficiently perform these tasks.

Training gives you a unique opportunity to get trained and certified on advanced database administration for EnterpriseDB Postgres Advanced Server.

This class is available in v10, v11 and v12

Course Outline

• Introduction.
• Database Monitoring – Collecting Statistics, Monitoring Processes, Using EDB Postgres Enterprise Manager.
• SQL Tuning – Common Issues, the Tuning Process and How-to Steps:
  • Identifying Slow Queries, Reviewing the Query Execution Plan.
  • Optimizer Hints.
  • Restructuring SQL Statements.
  • Indexes.
• Performance Tuning – Techniques, OS and Server Parameter Tuning.
• Performance Benchmarking – How, Why, Tools, Testing.
• Extensions – Installing and Using Available Extension Modules.
• Table Partitioning – Benefits, Methods/Types, Syntax.
• Connection Pooling – pgpool-II, pgbouncer, Configuration and Use.
• Cloning a Database.
• High Availability – Streaming Replication Architecture, Types and Use.
• Database Security.
• Upgrading Best Practices.
• More: link

Target Audience

• Course is designed for DBAs, Architects, and Database Professionals who are responsible for ongoing and advanced administration and maintenance of EDB Postgres Advanced Server, including implementing strategic database solutions for the enterprise.
• Class is supplemented with hands-on exercises that reinforce the material covered, and includes the ability to get certified, validating your skills and helping you to be more effective.

Recommended Prerequisites

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

Recommended next exam or course

• EntepriseDB Postgres Advanced Server Professional Certification