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.
Course Outline
Foundations and System Design
- Overview of PostgreSQL internals: processes, memory structures, and file systems
- Organizing data: databases, schemas, and tablespace management
- The PostgreSQL toolset and internal system tables
Setup and Configuration
- Installing PostgreSQL
- Managing configuration files (postgresql.conf, postgresql.auto.conf, pg_hba.conf, pg_ident.conf)
- Tuning core parameters related to memory, logging, and connections
- Upgrading and migrating existing PostgreSQL installations
Security Administration
- Managing user roles, groups, and privilege hierarchies
- Authentication mechanisms: trust, password, MD5, and SCRAM
- Introduction to Row-Level Security and data access policies
- Implementing SSL/TLS encryption
Backup and Disaster Recovery
- Creating logical backups using pg_dump and restoring via pg_restore
- Executing physical backups with pg_basebackup
- Managing incremental backups and WAL archiving
- Full restoration and Point-in-Time Recovery (PITR) strategies
Monitoring and Upkeep
- Comprehending the autovacuum mechanism
- Regular maintenance routines and log inspection
- Leveraging PgBadger for detailed log analysis
Requirements
Foundational proficiency in SQL
14 Hours
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.
