EDB Postgres Advanced Server v14

This five day, instructor led EDB Postgres Advanced Server v14 certification is a validation of expertise and knowledge in the PostgreSQL-based Database Management System. This certification is all about ensuring professionals possess the necessary skills to effectively manage and operate EDB Postgres Advanced Server. Industries utilize this certification to verify objective measurements of their employees’ abilities in database management, ensuring efficiency and data security. It encompasses concepts such as relational database fundamentals, managing database objects, and exploiting advanced features of EDB Postgres Advanced Server. This certification is a benchmark of proficiency, helping the industries in recruiting capable individuals and aiding in the evolution of their database infrastructure. At the completion of this certification course, participants will be able to:

• Understand the architecture and components of PostgreSQL System to manage databases effectively.
• Master the creation and management of databases, including configurations and installations.
• Learn the intricacies of log management for maintaining reliable database operations.
• Develop proficiency in using PSQL commands and pgAdmin III for database interaction and management.
• Acquire the ability to design and implement tablespaces for optimized data storage.
• Explore advanced security measures to protect data integrity and access within Postgres.
• Gain the skills necessary for effective backup, recovery, and point-in-time recovery procedures.
• Understand the Postgres Data Dictionary for better insight into metadata management.
• Learn about PostgreSQL API connectivity for application integration and data manipulation.
• Enhance database performance through tuning and routine maintenance while understanding replication, failover, and table partitioning for scalability and high availability.

• Basic understanding of relational database concepts: Familiarity with the core concepts of database systems, including tables, primary and foreign keys, and SQL (Structured Query Language).
• Fundamental SQL knowledge: Ability to write and understand simple SQL queries, such as SELECT, INSERT, UPDATE, and DELETE statements.
• General knowledge of operating systems: Comfortable with basic operations in either a Windows or Linux environment, as the course may cover installation and configuration on these platforms.
• Basic command-line interface skills: Knowing how to navigate and execute commands in a terminal or command prompt, which is essential for working with PostgreSQL.
• Basic familiarity with PostgreSQL: While not mandatory, having prior exposure to PostgreSQL or another SQL database will be helpful.

• ​Database Administrators (DBAs)
• System Architects
• Data Analysts
• IT Managers overseeing database systems
• Developers working with PostgreSQL databases
• Data Engineers
• Software Engineers looking to expand their database expertise
• IT Professionals involved in database migration projects
• DevOps Engineers responsible for database setup and maintenance
• Technical Support Specialists who troubleshoot database issues
• Security Professionals focused on database security
• Those pursuing a career in database management or looking for a specialization in Postgres servers

​

DAY ONE

• Part 1: Introduction
• Part 2: PostgreSQL System Architecture
• Part 3: Creating and Managing Databases
• Part 4: Installation

DAY TWO

• Part 5: Configuration
• Part 6: Log Management
• Part 7: PSQL Commands
• Part 8: pgAdmin III
• Part 9: Tablespaces

DAY THREE

• Part 10: Security
• Part 11: Backup and Recovery & Point-in Time Recovery
• Part 12: Postgres Data Dictionary
• Part 13: PostgreSQL API Connectivity

DAY FOUR

• Part 14: Performance Tuning
• Part 15: Routine Maintenance
• Part 16: Replication & Failover

DAY FIVE

• Part 17: Table Partitioning
• Part 18: Connection Pooling
• Part 19: Database Monitoring
• Part 20: Migration

​