BONUS! Cyber Phoenix Subscription Included: All Phoenix TS students receive complimentary ninety (90) day access to the Cyber Phoenix learning platform, which hosts hundreds of expert asynchronous training courses in Cybersecurity, IT, Soft Skills, and Management and more!
Course Overview
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.
Schedule
Currently, there are no public classes scheduled. Please contact a Phoenix TS Training Consultant to discuss hosting a private class at 301-258-8200.
Program Level
Intermediate
Prerequisites
- 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.
Target Audience:
- 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
Course Outline
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
BONUS! Cyber Phoenix Subscription Included: All Phoenix TS students receive complimentary ninety (90) day access to the Cyber Phoenix learning platform, which hosts hundreds of expert asynchronous training courses in Cybersecurity, IT, Soft Skills, and Management and more!
Phoenix TS is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints re-garding registered sponsors may be submitted to the National Registry of CPE Sponsors through its web site: www.nasbaregistry.org
