5 DAYS INTERMEDIATE & ADVANCED

Postgres1st Advanced Training

Scale, tune, and operate mission-critical Postgres

Take your database administration skills to the next level with an in-depth exploration of the techniques and tools required to manage, optimize, and scale enterprise-grade PostgreSQL environments. This course is designed for experienced DBAs looking to deepen their technical expertise — covering advanced administration responsibilities, performance tuning, and the strategies needed to keep mission-critical database systems running at peak efficiency.

Course at a Glance

Duration 5 Days
Level Intermediate & Advanced
Modules 21 across 5 days
Delivery Onsite, remote, or private team
Enroll Your Team

Curriculum

5 days of instruction, structured day-by-day.

21 Modules
1
DAY 1

4 Topics

  • Introduction
  • PostgreSQL System Architecture
  • Creating and Managing Databases
  • Installation
2
DAY 2

5 Topics

  • Configuration
  • Log Management
  • PSQL Commands
  • PgAdmin III
  • Tablespaces
3
DAY 3

4 Topics

  • Security
  • Online Backup & Point-in Time Recovery
  • Postgres Data Dictionary
  • Upgrade Best Practices
4
DAY 4

3 Topics

  • Performance Tuning
  • Routine Maintenance
  • Replication & Failover
5
DAY 5

5 Topics

  • Table Partitioning
  • Connection Pooling
  • Migration
  • Third-Party Tools
  • Extensions
back top