PostgreSQL Administrator Training Course

PostgreSQL Administration Training Course

PostgreSQL Admin training is for system administration and covers Postgres administration,  setup and configuration including clustering, point-in-time recovery and performance tuning. Postgres is a sophisticated open source relational database management system. Postgres supports the structured query language (SQL) with a wide variety of data types and support for: triggers, a number of embedded programming languages, and full transactional processing.

Postgres is the choice of enterprises looking for a robust open source solution for their database needs. With large scale industry acceptance and cutting edge features database administrators with Postgres skills are in demand. This postgres admin training course ensures you have the skill to expertly manage your Postgres clusters.

 

Description Days Price(exc vat)
Postgres Administration Training Course 2 ZAR USD
R8,000 $700
  • Lunch, refreshments and training material included.
  • Class start at 9:00am for 9:30am
  • South Africa training locations: Johannesburg, Cape Town, Durban
  • Global training locations: USA, Candana, UK, Dubai, Europe

Please contact us if you are looking to book a training sessions for Postgresql Admin Training.

 

Course Outline

Introduction to  PostgreSQL

  • A Brief History of PostgreSQL

  • Getting StartedPostgresql Administrator Training

  • Installation

  • Architectural Fundamentals

  • Using the psql terminal based client

PostgreSQL SQL Language specifics

  • Creating a Database

  • Accessing a Database

  • Creating a New Table

  • Populating a Table With Rows

  • Querying a Table

  • Joins Between Tables

  • Aggregate Functions

  • Updates

  • Deletions

Advanced SQL

  • Views

  • Foreign Keys

  • Transactions

  • Window Functions

  • Inheritance

Indexes

  • Multicolumn Indexes 

  • Indexes and ORDER BY

  • Combining Multiple Indexes

  • Unique Indexes

  • Indexes on Expressions

  • Partial Indexes

  • Setting up a Partial Index to Exclude Common Values

  • Setting up a Partial Index to Exclude Uninteresting Values

  • Setting up a Partial Unique Index

  • Operator Classes and Operator Families

  • Examining Index Usage

  • Full Text Search  

Transaction Isolation and Concurrency

  • SQL Transaction Isolation Levels

  • Read Committed Isolation Level

  • Serializable Isolation Level

  • Serializable Isolation versus True Serializability

  • Explicit Locking

  • Table-Level Locks

  • Table-level lock modes

  • Conflicting lock modes

  • Row-Level Locks

  • Deadlocks

  • Advisory Locks

  • Using EXPLAIN

Server Set-up and Operation

  • The PostgreSQL User Account

  • Creating a Database Cluster

  • Starting the Database Server

  • Server Start-up Failures

  • Client Connection Problems

  • Shutting Down the Server

Server Configuration

  • Setting Parameters

  • File Locations

Security

  • Preventing Server Spoofing

  • Encryption Options

  • Secure TCP/IP Connections with SSL

  • Using client certificates

  • SSL Server File Usage

  • Creating a Self-Signed Certificate

  • Connections and Authentication

  • Connection Settings

  • Security and Authentication

Resource Consumption

  • Memory

  • Kernel Resource Usage

  • Cost-Based Vacuum Delay

  • Background Writer

  • Asynchronous Behaviour

  • Write Ahead Log

  • Settings

  • Checkpoints

  • Archiving/ Log shipping

  • Point-in-time-recovery

  • Query Planning

  • Planner Method Configuration

  • Planner Cost Constants

  • Genetic Query Optimizer

  • Other Planner Options

Error Reporting and Logging

  • Where To Log 

  • When To Log

  • Message severity levels

  • What To Log

  • Using CSV-Format Log Output

  • Run-Time Statistics

  • Query and Index Statistics Collector

  • Statistics Monitoring

Description Days Price(exc vat)
Postgres Administration Training Course 2 ZAR USD
R8,000 $700

* Includes text book, lunch and tea. All Classes start at 09H00-09H30 unless pre-arranged.

Please contact us if you are looking to book a training sessions for Postgresql Admin Training.