Making Intellectuals Meet Excellence!
Postgresql Plus Advanced Server
Intermediate
Postgresql Plus Advanced Server
The Postgresql Plus Advanced Server certification verifies expertise in working with the Advanced Server database management system of Postgresql. This course affirms a professional’s understanding in implementing and managing the database system efficiently and effectively. Many industries use it to validate their IT professionals' proficiency in handling data management, backups, security and performance tuning in database operations.
Course Prerequisites
• Basic understanding of SQL database management
• Familiarity with Postgres implementation and usage
• Knowledge of database design and system performance optimization
• Prior experience in creating and managing databases
• Proficiency in backup strategies, partitioning, and security aspects
• Understanding of SQL, PL/pgSQL, triggers & stored procedures.
• Familiarity with Postgres implementation and usage
• Knowledge of database design and system performance optimization
• Prior experience in creating and managing databases
• Proficiency in backup strategies, partitioning, and security aspects
• Understanding of SQL, PL/pgSQL, triggers & stored procedures.
Curriculum
- 1 Section
- 20 Lessons
- 0 Quizzes
- 40h Duration
LESSONS
20 Lessons0 Quizzes
- Introduction
- PostgreSQL System Architecture
- Installation
- Configuration
- Creating and Managing Database
- Postgres Data Dictionary
- Introduction To PSQL
- pgAdmin III
- Security Basics
- SQL
- Backup and Recovery & Point-in-Time Recovery
- Routine Maintenance
- PostgreSQL API Connectivity
- Transaction & Concurrency
- Performance Tuning
- Replication and Failover
- Table Partitioning
- Connection Pooling
- Database Monitoring
- EDB Tools