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 Structure
- Overview of PostgreSQL structure: processes, memory usage, and file organization
- Organizing data: working with databases, schemas, and tablespaces
- Exploring the PostgreSQL toolset and system-level tables
Setup and Setup Configuration
- Process of installing PostgreSQL
- Working with configuration files (postgresql.conf, postgresql.auto.conf, pg_hba.conf, pg_ident.conf)
- Modifying key settings related to memory, logging, and connections
- Handling version upgrades and migrating existing installations
Managing Security
- Defining user roles, groups, and their associated privileges
- Reviewing authentication options: trust, password, MD5, and SCRAM
- Understanding Row-Level Security and data access policies
- Setting up SSL/TLS for secure connections
Data Protection and Restoration
- Creating logical backups using pg_dump and pg_restore
- Performing physical backups with pg_basebackup
- Implementing incremental backups and WAL archiving
- Executing full recoveries and Point-in-Time Recovery (PITR)
Monitoring and Upkeep
- Understanding how the autovacuum process works
- Conducting routine maintenance and analyzing logs
- Utilizing PgBadger for detailed log analysis
Requirements
A foundational understanding of 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.
