Course Outline
Introduction and Architecture
- Overview of PostgreSQL architecture: processes, memory, and file structures
- Data structuring: databases, schemas, and tablespaces
- Exploring the PostgreSQL toolset and system catalogue tables
Installation and Configuration
- Deploying PostgreSQL
- Examining configuration files (postgresql.conf, postgresql.auto.conf, pg_hba.conf, pg_ident.conf)
- Optimising core parameters related to memory, logging, and connection limits
- Managing upgrades and migrating existing PostgreSQL installations
Security Management
- Defining user roles, groups, and access privileges
- Configuring authentication methods: trust, password, MD5, and SCRAM
- Reviewing Row-Level Security and data access policy frameworks
- Implementing SSL/TLS encryption
Backup and Recovery
- Executing logical backups using pg_dump and pg_restore
- Creating physical backups with pg_basebackup
- Managing incremental backups and WAL archiving
- Performing full restoration and Point-in-Time Recovery (PITR)
Monitoring and Maintenance
- Analysing the autovacuum mechanism
- Conducting routine maintenance tasks and log diagnostics
- Leveraging PgBadger for comprehensive log analysis
Requirements
Fundamental proficiency in SQL is expected
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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.
