PostgreSQL Administration - 2 days (Wellington)

Thursday, 21st Feb 2019
10am start - 2 days
$1,620.00 per person (excl. GST)
Wellington

About the course

This course shows you how to use the PostgreSQL database system from a DBA perspective.  We'll cover installation, configuration and tuning.

Course outline
  • Introduction
  • Installation
  • Post installation setup
  • System components
  • Administration tasks
  • System monitoring
  • Locking and concurrency
  • Internals
  • Tuning

Note: These are the topics normally covered but might alter slightly depending on the needs of the attendees.

Target Audience

The course is aimed at those who need to administer PostgreSQL databases and want to learn best practices.

Prerequisites

A level of fluency using terminal, Linux (Unix) shells and (non graphical) editors is essential. In addition attendees should meet one of the following criteria:

  • DBAs with experience administering another database product e.g. MySQL
  • System administrators experienced using Linux (Unix)
  • Developers experienced using PostgreSQL