PostgreSQL Administration

PT20615
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