Postgresql Plus Advanced Server Training Program

Course Description

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.

Training Curriculum

LESSONS ↓

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

Program Details

Duration

Self-Paced

Delivery Mode

Instructor-Led Online & Classroom

Enroll / Enquire Now →