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
Introduction and Architecture
- High-level view of PostgreSQL architecture, including processes, memory structures, and file systems
- Data organization concepts: databases, schemas, and tablespaces
- Introduction to the PostgreSQL toolkit and system catalogs
Installation and Configuration
- Procedures for installing PostgreSQL
- Reviewing key configuration files (postgresql.conf, postgresql.auto.conf, pg_hba.conf, pg_ident.conf)
- Optimizing core parameters related to memory, logging, and connection limits
- Strategies for upgrading and migrating PostgreSQL environments
Security Management
- Managing user roles, groups, and granular privileges
- Exploring authentication mechanisms: trust, password, MD5, and SCRAM
- Introduction to Row-Level Security and data access policies
- Implementation of SSL/TLS encryption
Backup and Recovery
- Performing logical backups and restores using pg_dump and pg_restore
- Executing physical backups via pg_basebackup
- Managing incremental backups and Write-Ahead Log (WAL) archiving
- Implementing full recovery and Point-in-Time Recovery (PITR)
Monitoring and Maintenance
- Comprehending the autovacuum mechanism
- Conducting routine maintenance and performing log analysis
- Leveraging PgBadger for detailed log insights
Requirements
Fundamental 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.
