Courses: RLPG201 - PostgreSQL Advanced DBA

This three-day course provides everything included in the standard DBA, with some more depth.

It also covers topics like replication, high availability clustering and tuning.

Course Format

This class is 90% theory and 10% informal labs. The course is held in local language or English. Documentation is only provided in English.

Agenda

Day 1: 

• Introduction and Architecture
• Installation of PostgreSQL
• PgAdmin and psql
• Data design and Data types
• Using large objects
• MVCC in PostgreSQL

Day 2:

• Basic configurations
• Security
• Logging and Monitoring
• Routine maintenance
• Indexing and fulltext indexing

Day 3:

• Partitioning 
• Backup and recovery 
  
• Performance and tuning 
• Basic high availability
• Warm standby and Slony
• SQL Optimization

Prerequisites

SQL, basic knowledge about database administration in any RDBMS.

Target audience

DBAs who administer and maintain installations of PostgreSQL.

Instructors

Magnus Hagander

Senior database architect, developer and systems administrator with a broad experience through most of the stack, from hardware to application development. Part of the core developer team for the PostgreSQL open-source relational database. Experienced course instructor and public speaker.

Instructors

Magnus Hagander

Senior database architect, developer and systems administrator with a broad experience through most of the stack, from hardware to application development. Part of the core developer team for the PostgreSQL open-source relational database. Experienced course instructor and public speaker.