Database Administration · PPL

PostgreSQL Administration Certification

A specialist program designed to develop practical PostgreSQL administration skills in installation, configuration, security, backup, recovery, monitoring, optimization, and database maintenance.

  • ⏱3 DaysDuration
  • ◈PPLAccredited
  • ◐3 LanguagesArabic · English · Hindi
  • ◆₹12,999.00 Per delegate

This course is accredited by PPL

This is for all ppl accredited courses
2M+ Delegates trained worldwide
15,000+ Corporate clients
490+ Training locations
4.8 ★ Average learner rating
20% OFF Limited-time launch offer
— The journey

Course Outline

What the programme covers, module by module.

Module 1: Introduction to PostgreSQL Administration

  • PostgreSQL overview
  • Database administration responsibilities
  • PostgreSQL ecosystem
  • Database environments
  • Administration lifecycle
  • Common DBA activities

Module 2: PostgreSQL Architecture

  • Client-server architecture
  • PostgreSQL processes
  • Shared memory
  • Background processes
  • Database clusters
  • Architecture components

Module 3: Installing PostgreSQL

  • System requirements
  • Installation planning
  • PostgreSQL installation
  • Database cluster initialization
  • Server startup
  • Installation verification

Module 4: PostgreSQL Server Configuration

  • postgresql.conf
  • Server parameters
  • Connection settings
  • Memory settings
  • Configuration reload
  • Configuration management

Module 5: PostgreSQL Administration Tools

  • psql
  • pgAdmin
  • Command-line administration
  • Server connections
  • Database navigation
  • Administrative commands

Module 6: Database & Schema Management

  • Creating databases
  • Database properties
  • Schemas
  • Search paths
  • Database objects
  • Object organization

Module 7: Roles & User Management

  • PostgreSQL roles
  • Creating roles
  • Login roles
  • Role membership
  • Password management
  • Account administration

Module 8: Privileges & Database Security

  • Object privileges
  • GRANT
  • REVOKE
  • Ownership
  • Role-based access
  • Least-privilege principles

Module 9: Client Authentication

  • pg_hba.conf
  • Authentication methods
  • Host-based authentication
  • Connection rules
  • Access restrictions
  • Authentication troubleshooting

Module 10: PostgreSQL Storage Management

  • Tablespaces
  • Database files
  • Data directories
  • Storage allocation
  • Disk utilization
  • Capacity planning

Module 11: Transactions & Concurrency

  • ACID properties
  • Transactions
  • COMMIT
  • ROLLBACK
  • MVCC
  • Transaction isolation

Module 12: Locking & Deadlocks

  • Locking concepts
  • Row locks
  • Table locks
  • Blocking
  • Deadlocks
  • Lock monitoring

Module 13: Backup Strategies

  • Backup planning
  • Logical backups
  • pg_dump
  • pg_dumpall
  • Physical backup concepts
  • Backup validation

Module 14: Restore & Recovery

  • pg_restore
  • Database restoration
  • WAL concepts
  • Point-in-time recovery
  • Recovery procedures
  • Recovery validation

Module 15: Index Administration

  • Index fundamentals
  • B-tree indexes
  • Hash indexes
  • GIN indexes
  • GiST indexes
  • Index management

Module 16: Query Performance Analysis

  • EXPLAIN
  • EXPLAIN ANALYZE
  • Query plans
  • Sequential scans
  • Index scans
  • Query bottlenecks

Module 17: PostgreSQL Performance Tuning

  • Query optimization
  • Memory configuration
  • Index optimization
  • Statistics
  • Planner configuration
  • Performance improvement

Module 18: VACUUM & Database Maintenance

  • VACUUM
  • VACUUM ANALYZE
  • Autovacuum
  • Dead tuples
  • Table bloat
  • Routine maintenance

Module 19: PostgreSQL Monitoring

  • Database activity
  • pg_stat views
  • Sessions
  • Connections
  • Resource utilization
  • Performance metrics

Module 20: Replication

  • Streaming replication
  • Primary and standby servers
  • Write-ahead logging
  • Replication slots
  • Replication monitoring
  • Failover concepts

Module 21: High Availability & Troubleshooting

  • High availability concepts
  • Standby databases
  • Failover strategies
  • Connection issues
  • Performance issues
  • Root cause analysis

Module 22: Practical PostgreSQL Administration Workshop

  • Server configuration
  • Role and privilege management
  • Backup and recovery
  • Query analysis
  • Performance monitoring
  • Troubleshooting scenarios
— 01.2 · Is it right for you?

Who it's for & what's included

Pick a delivery method to see exactly who it suits and everything you receive.

Who it's for

Classroom

Best for learners who want face-to-face tuition and to network with peers in person.

What's included

Everything you get

  • ✓ Live instructor on-site
  • ✓ Printed workbook & materials
  • ✓ Group exercises & case studies
Who it's for

Online Instructor-Led

Best for learners who want a live instructor and a fixed schedule, without the travel.

What's included

Everything you get

  • ✓ Live instructor via video call
  • ✓ Digital workbook & resources
  • ✓ Session recordings
Who it's for

Self-Paced

Best for self-motivated learners who need maximum flexibility around work and life.

What's included

Everything you get

  • ✓ On-demand video lessons
  • ✓ Interactive quizzes
  • ✓ 24/7 access on any device
— What you will master

Course Objectives

01

Understand PostgreSQL architecture and core database administration concepts.

02

Install, initialize, and configure PostgreSQL database environments.

03

Manage databases, schemas, roles, privileges, and authentication controls.

04

Implement effective backup, restore, and point-in-time recovery strategies.

05

Manage transactions, concurrency, locking, and deadlock scenarios.

06

Analyze execution plans and optimize PostgreSQL query performance.

07

Perform VACUUM, monitoring, storage management, and routine maintenance.

08

Configure replication and apply high-availability and troubleshooting techniques.

— Questions answered

Frequently Asked Questions

What is PostgreSQL Administration?
PostgreSQL Administration involves configuring, securing, monitoring, maintaining, backing up, recovering, and optimizing PostgreSQL database environments.
Who should attend this course?
The course is suitable for PostgreSQL administrators, database administrators, database engineers, backend developers, IT professionals, and technical working professionals.
Do I need previous PostgreSQL experience?
Basic SQL and relational database knowledge is recommended. The program introduces PostgreSQL administration fundamentals before progressing to specialist operational topics.
Which PostgreSQL administration areas are covered?
The course covers architecture, configuration, roles, security, storage, transactions, backup, recovery, indexing, VACUUM, performance tuning, monitoring, replication, and high availability.
What practical skills will I develop?
You will develop skills in configuring PostgreSQL servers, managing users and databases, performing backup and recovery, optimizing queries, monitoring database health, maintaining databases, and managing replication.
— Trusted by learners

What our delegates say

★★★★★

"The structure, the practice exams, the instructor — all top tier. Passed first try."

AS
Aarti SharmaSenior Project Manager · TCS
★★★★★

"Best training I have attended. The content is exactly what modern projects need."

JD
James DonovanProgramme Director · Capgemini
★★★★★

"24/7 support actually means 24/7 — got help on my mock exam at 2am. Worth every dollar."

MO
Maya OkaforPMO Lead · Standard Bank

★ 4.8 / 5 from 12,000+ verified learner reviews on Trustpilot & Google.

PPL Academy enquiry form

Get the course
that's right for you.

Our advisors respond within one business day.

Full name
Work email
Contact number
Message (optional)
Your details are never shared with third parties.
< 24h Response
Live & online Delivery
Certified Instructors