EDB for Postgres and Oracle DBAs (2 days)
What is it about?
This course is specifically designed for experienced Oracle DBAs who want to quickly and efficiently learn how EnterpriseDB Postgres Advanced Server (EPAS) works and how to operate it. The goal of the training is to build upon existing Oracle knowledge and, drawing on that foundation, introduce the specific features, architecture, command-line tools, configuration, and maintenance of the EDB Postgres environment. Special attention is given to migrating Oracle objects to Postgres, as well as a detailed comparison of the similarities and differences between EPAS and Oracle.
Who is this course recommended for?
We recommend this course primarily to professionals working in the following fields:
- For experienced Oracle database administrators (DBAs)
- For professionals who are migrating from Oracle to EDB Postgres or planning to switch
- For corporate IT professionals looking to implement a more cost-effective, open-source database solution
- For Oracle-focused IT professionals and consultants who wish to expand their existing knowledge
Prerequisite for starting the course:
The training is not tied to any specific degree, but a degree in computer science (at the high school or college level) may be an advantage. To ensure successful participation, we recommend practical experience in managing Oracle databases, including administrative and maintenance tasks, as well as knowledge of SQL and a basic understanding of Oracle database architecture and tools.
Planned topics for the course
- Introduction to EDB Postgres
- System architecture
- Creating and Managing Database Clusters
- Creating and managing databases
- System Configuration and Performance Tuning
- Command-line user tools (psql, EDB Plus, etc.)
- SQL Tuning – Performance Optimization in a Postgres Environment
- Data transfer (import, export, move)
- Backup and Restore, PITR, and Incremental Backups
- Routine maintenance tasks (e.g., VACUUM, ANALYZE)
- Migrating Oracle Objects to EDB Postgres Advanced Server
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.

