EDB Postgres AI Database: Advanced (3 days)

What is it about?

This course provides practical knowledge for performing advanced administrative tasks in the EDB Postgres AI environment. During the training, participants will learn about performance tuning methods, the use of monitoring and benchmarking tools, the tools needed to set up replication and high availability, table partitioning, plugins, and connection management optimization options, the use of Transparent Data Encryption (TDE), and best practices for database upgrades.

Who is this course recommended for?

We recommend the EDB Postgres AI Database Advanced Course to IT professionals (database administrators (DBAs), database and system architects, database specialists, and performance optimization engineers) who already have at least a basic understanding of Postgres and database administration and wish to expand their knowledge to include advanced, enterprise-level DBA skills. The training is primarily aimed at those who wish to manage database performance tuning, high availability, replication, and security at a professional level.

Prerequisite for starting the course:

We recommend the EDB Postgres AI Database Advanced Course to IT professionals (database administrators (DBAs), database and system architects, database specialists, and performance optimization engineers) who already have at least a basic understanding of Postgres and database administration and wish to expand their knowledge to include advanced, enterprise-level DBA skills. The training is primarily aimed at those who wish to manage database performance tuning, high availability, replication, and security at a professional level.

Planned topics for the course

  • Introduction
  • Database Monitoring
  • SQL Tuning
  • Performance Tuning
  • Performance Benchmarking
  • Using Extensions
  • Table Partitioning
  • Connection Pooling
  • Cloning
  • Transparent Data Encryption (TDE)
  • Best Practices for Updates

Information about course dates can be found here. If you are interested in on-site or customized courses, would like to register for our courses, or would like to receive a quote, please contact us at training@ulx.hu and/or call us at +36 1 450 0921.