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.

 

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.