Comprehensive PostgreSQL Administration Training

Manila, Philippines

This course is designed for people with experience in database administration but who are new to PostgreSQL. Taking up this training will help will help the learner prepare for day-to-day Administrative and Management tasks to be performed as a PostgreSQL DBA and slowly scale up to manage large and highly available databases.

Pre-requisites: Basic experience in database administration and understanding of Relational Database concepts will be helpful.

Date: November 6 – 10 ,2017
Time: 9am – 5pm
Duration: 5 Days
Venue: 2/F Topy Main Building, Alcos Global IT Park #3 Industria St. cor Economia St., Bagumbayan, Quezon City, Metro Manila, Philippines 1110

Course content summary

  • Introduction and Architectural (Overview)
  • PostgreSQL System Architecture
  • Installation
  • Database Clusters
  • Configuration
  • Creating and Managing Databases
  • User Tools
  • SQL Primer
  • Backup and Recovery & Point-in-Time Recovery
  • Routine Maintenance
  • Data Dictionary
  • Moving Data
  • SQL Tuning
  • Performance Tuning
  • Streaming Replication
  • Connection Pooling
  • Table Partitioning
  • Extension Modules
  • Monitoring
  • Upgrading Best Practices