PostgreSQL Administration

PostgreSQL comes with many features aimed to help developers build applications, administrators to protect data integrity and build fault-tolerant environments, and help you manage your data no matter how big or small the dataset. In addition to being free and open source, PostgreSQL is highly extensible. For example, you can define your own data types, build out custom functions, even write code from different programming languages without recompiling your database!

Students taking this PostgreSQL Administration training class will learn to effectively administer PostgreSQL.

Delegates will learn

  • to compile source code.
  • about backup and disaster recovery.
  • about inheritance, partitioning, and Tablespaces.
  • to manage free space.
  • about security in PostgreSQL.
  • to create high availabilty and high performance solutions.

PostgreSQL Introduction & Architecture

PostgreSQL Data Types  

PostgreSQL Installation

PostgreSQL Configuration

Introduction to psql

Functions & Operators  

Managing PostgreSQL Databases

PostgreSQL Roles and Security

Moving Data with PostgreSQL

Tablespaces, Inheritance and Data Partitioning



Transactions & Concurrency Control

Routine DBA Tasks and Best Practices

Monitoring and Statistics

PostgreSQL Tools Overview

PostgreSQL Performance Tuning

PostgreSQL Backup and Recovery

PostgreSQL Upgrade Methods

PostgreSQL Streaming Replication



PostgreSQL High Availability

PostgreSQL and AWS  

PostgreSQL RDS Overview  

PostgreSQL Redshift Overview  

The PostgreSQL Contribs  

Program Details
Duration 5 Days
Capacity Max 12 Persons
Training Type Classroom / Virtual Classroom

Can't find what you're looking for? Let us know if you have a query or cannot find what you are looking for.