Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 14 hours
Course Outline
Introduction and Architecture
- Overview of PostgreSQL architecture: processes, memory management, and file structures
- Data organization: understanding databases, schemas, and tablespaces
- Exploring the PostgreSQL toolset and system tables
Installation and Configuration
- Process for installing PostgreSQL
- Detailed look at configuration files (postgresql.conf, postgresql.auto.conf, pg_hba.conf, pg_ident.conf)
- Tuning core parameters related to memory, logging, and connections
- Strategies for upgrading and migrating PostgreSQL installations
Security Management
- Defining user roles, groups, and privileges
- Implementing authentication methods: trust, password, MD5, and SCRAM
- Introduction to Row-Level Security and data access policies
- Setting up SSL/TLS for secure connections
Backup and Recovery
- Creating logical backups using pg_dump and pg_restore
- Executing physical backups with pg_basebackup
- Managing incremental backups and WAL archiving
- Performing full recovery and Point-in-Time Recovery (PITR)
Monitoring and Maintenance
- Understanding the autovacuum process
- Conducting routine maintenance and analyzing logs
- Leveraging PgBadger for comprehensive log analysis
Requirements
A foundational understanding of SQL
Testimonials (7)
The patiance and the style of teaching of Michał was nice.
Luiza
Course - PostgreSQL for Administrators - 2 Days
Michal was great at sharing his vast knowledge of postgres.
Matei
Course - PostgreSQL for Administrators - 2 Days
The training was interactive which made it interesting.
Priyanka Talwar - University of South Australia
Course - PostgreSQL for Administrators - 2 Days
Great lab setup. Very practical training which reinforced the material.
Brian - Verizon Connect
Course - PostgreSQL for Administrators - 2 Days
Practical exercises and suggestions given by the trainer.
Bruno - Verizon Connect
Course - PostgreSQL for Administrators - 2 Days
interaction was encouraged,Very useful practical approaches.
Farhan - Fast Lane Consulting and Education Services Limited
Course - PostgreSQL for Administrators - 2 Days
The versatility of the training.
