Making Intellectuals Meet Excellence!
EDB Postgres Advanced Server v14
Intermediate
EDB Postgres Advanced Server v14
EDB Postgres Advanced Server v14 course is a validation of expertise and knowledge in the PostgreSQL-based Database Management System. This course is all about ensuring professionals possess the necessary skills to effectively manage and operate EDB Postgres Advanced Server. It encompasses concepts such as relational database fundamentals, managing database objects, and exploiting advanced features of EDB Postgres Advanced Server.
Course Prerequisites
• Prior knowledge of PostgreSQL or any equivalent database management system
• Basic understanding of SQL and relational database concepts
• Experience with Linux, Unix or Windows operating systems
• Familiarity with command line interfaces and scripting languages
• Background in computer science or related fields
• Basic understanding of SQL and relational database concepts
• Experience with Linux, Unix or Windows operating systems
• Familiarity with command line interfaces and scripting languages
• Background in computer science or related fields
Curriculum
- 1 Section
- 20 Lessons
- 0 Quizzes
- 40h Duration
LESSONS
20 Lessons0 Quizzes
- Introduction
- PostgreSQL System Architecture
- Creating and Managing Database
- Installation
- Configuration
- Log Management
- PLSQL Commands
- pgAdmin III
- Tablespaces
- Security
- Backup and Recovery & Point-in-Time Recovery
- Postgres Data Dictionary
- PostgreSQL API Connectivity
- Performance Tuning
- Routine Maintenance
- Replication and Failover
- Table Partitioning
- Connection Pooling
- Database Monitoring
- Migration