Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
Course Outline
- Introduction
- Architectural Overview
- Lab Machine Setup
- Performance Monitoring and Tuning
- Monitoring Slow Queries
- SQL Tuning
- Table Partitioning
- Operating System Best Practices
- Parameter Tuning
- Extensions
- Benchmarking
- Monitoring Best Practices
- Demos and Labs
- Database Backups and Restores
- Logical or SQL Dump Backups
- Restoring SQL Dumps
- Physical Backups - Offline
- Restoring Offline Backups
- Physical Backups - Online
- Write Ahead Log(WAL) Archiving
- Recovery configuration
- Point in Time Recovery using WAL Archives
- High Availability
- Transaction Log Archiving
- Streaming Replication
- Connection Pooling and HA setup using pgpool-II
- Installation
- Configuration
- pgpool Setup
- HA Setup
- Demos and Labs
- Database Security
- Users and Groups
- Access Control
- Row Level Security
- Host Based Access Control
- Data Encryption using pgcrypto
- Demos and Labs
- Database Upgrades
- PostgreSQL Versioning
- Plan for Upgrade
- Upgrade using pg_dump
- Upgrade using pg_upgrade
- In Place or Not-in Place Upgrade
- Post Upgrade Tasks
Requirements
It is recommended to attend this training only if you have a prior knowledge of PostgreSQL or have attended PostgreSQL Essentials Training
Testimonials
the pace and the knowledge of the trainer.
Ashneet Maharaj, Auckland Council
interactive (participation) and checking with audience on what to cover the entire time
Ashneet Maharaj, Auckland Council
The way it was presented Getting "under the hood" information on Postgres. The topics on vacuum, backups and replication were very useful.
Greg Albrecht - Ashneet Maharaj, Auckland Council
The trainer has a very good knowledge and was able to transmit this to the trainees.
Sopra Steria
The trainer was very knowledgeable in the subject, answered every question and kept the engagement of the participants. Some topics were explained in great depth, which I found really good.
Sopra Steria
Michal was very knowledgable and engaging as a teacher.
Nate Clifton - NIIT (USA) Inc.
Michal is a knowledgeable and experienced trainer. It's good to have trainers who have industry experience. I also liked the hands-on exercises with remote VMs.
NIIT (USA) Inc.
Related Courses
PostgreSQL for Developers
14 hours
PostgreSQL Essentials
14 hours
PostgreSQL Performance Tuning
14 hours
PostgreSQL with Python
21 hours
Data Management
35 hours
SAP ASE for Database Administrators
28 hours
Pivotal Greenplum for Developers
21 hours
MarkLogic Server
14 hours