EDB Postgres AI Database Fundamentals Course (4 days)

What is it about?

The training provides a comprehensive yet practical introduction to EDB Postgres AI Enterprise Postgres administration. Participants will learn how to design and deploy an enterprise Postgres environment; configure and operate EDB Postgres AI infrastructure; ensure high availability and operational reliability; manage security settings, monitoring, and administrative tools; perform backups, restores, and point-in-time recovery (PITR); and manage, maintain, and migrate large enterprise databases. The training covers all the basic knowledge necessary to build a robust, scalable, and secure EDB Postgres environment. Translated with DeepL.com (free version)

Who is this course recommended for?

The EDB Postgres AI Database Fundamentals course is recommended for IT professionals (database administrators (DBAs), IT operators who perform corporate data management or data platform tasks, system engineers, and infrastructure operators who want to learn about EnterpriseDB (EDB) Oracle-compatible Postgres solutions) who are responsible for operating, designing, and maintaining enterprise-level PostgreSQL-based databases. The course is ideal for those who want to operate reliable, secure, and highly available Postgres systems in a large enterprise environment. Translated with DeepL.com (free version)

Prerequisite for starting the course:

The EDB Postgres AI Database Fundamentals course is recommended for IT professionals (database administrators (DBAs), IT operators who perform corporate data management or data platform tasks, system engineers, and infrastructure operators who want to learn about EnterpriseDB (EDB) Oracle-compatible Postgres solutions) who are responsible for operating, designing, and maintaining enterprise-level PostgreSQL-based databases. The course is ideal for those who want to operate reliable, secure, and highly available Postgres systems in a large enterprise environment.

Planned topics for the course

  • Introduction and Architecture Overview
  • System architecture
  • Installing EDB Enterprise Postgres
  • User tools, command line interface (CLI) options
  • Database clusters
  • Main configuration files, performance tuning, and environment settings
  • Data Dictionary
  • Creating and managing databases
  • Database security
  • Monitoring and administration tools
  • SQL primer
  • Backup, Recovery, and Point-in-Time Recovery
  • Runtime maintenance tasks
  • Data transfer with the COPY command
  • Advanced replication and high availability

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.