PostgreSQL Administration

Summary

This course is designed for PostgreSQL administration and configuration. It will cover specific PostgreSQL configurations and processes. It will address specific PostgreSQL utilities, commands, and security. It is designed for experienced DBA’s and developers.

Prerequisites

There are no prerequisites for this course.

Duration

5 Days/Lecture & Lab

Audience

This course is designed for experienced DBA’s and developers.

Topics

• Introduction
• Installation
• Configuration
• PSQL
• Roles and Security
• Managing PostgreSQL Databases
• Postgres Tablespaces
• Moving Data with PostgreSQL
• Routine Tasks
• Monitoring Statistics
• Performance Tuning
• Backup and Recovery
• PostgreSQL Upgrade
• Replication
• Triggers
• Rules
• PL/pgSQL
• Other Procedural Languages

Related Scheduled Courses