EDB Postgres Fundamentals (4 days)
What is it about?
The EDB Postgres Fundamentals course is designed to provide comprehensive knowledge of the installation, configuration, management, and maintenance of enterprise-level database solutions in the EDB Postgres Advanced Server environment. During the training, participants will learn about the EDB Postgres system architecture, command-line administration tools, security settings, backup and recovery options, and tools that ensure high availability. The course prepares participants to confidently install, configure, and securely operate EDB Postgres Advanced Server in an enterprise environment, including the management of large-scale, high-availability databases.
Who is this course recommended for?
We recommend this course primarily to professionals working in the following fields:
- For database administrators (DBAs)
- For IT professionals involved in the design and operation of database infrastructures
- For developers and DevOps engineers who use PostgreSQL in backend systems
- For teams switching from Oracle or other RDBMSes to EDB Postgres
Prerequisite for starting the course:
The training is not tied to any specific degree, but a degree in computer science (at the secondary or higher education level) may be an advantage; in addition, basic database administration experience and an intermediate understanding of relational database management are recommended for successful participation, basic knowledge of the SQL language, and basic knowledge of the Linux operating system or equivalent skills.
Planned topics for the course
- Introduction and Architectural Overview
- System architecture
- Installing EDB Postgres Advanced Server
- Command-line administration tools
- Managing Database Clusters
- Configuration settings
- Using the Data Dictionary
- Creating and managing databases
- Database Security and Access Management
- Monitoring and Administration Tools
- SQL Basics (SELECT, INSERT, UPDATE, etc.)
- Backup, Restore, PITR
- Routine maintenance tasks
- Loading a large amount of data
- Replication and High Availability Tools
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.