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 to the PostgreSQL Database Server
- architecture (processes, files)
- administrative tools
- installation, upgrade, starting, stopping
- configuration (configuration files and parameters)
- tablespaces, databases, schemas
- basic maintenance operations (vacuum, analyze, reindex)
Managing User Accounts and Permissions
- authentication methods
- limiting network access to the server
- creating and modifying user account definitions
- creating groups/roles
- system and object permissions
Protecting Databases from Failure Effects - Backups and Replication
- database backups (logical: pg_dump, pg_dumpall, pg_restore; physical: pg_basebackup; incremental physical: pg_combinebackup)
- restoring the database after a failure
- archiving WAL files
- complete and partial recovery (to a point in time)
- standard physical replication
- standard logical replication
- auxiliary tools (barman, repmgr)
Managing PostgreSQL Database Server Performance
- query execution plans, introduction to the Query Planner, statistics for the Query Planner
- using indexes, types of indexes (B-tree, hash, BRIN)
- advanced table structures (partitioned, unlogged, temporary, materialized views)
- utilizing buffer memory (Buffer Cache, Work Memory, Maintenance Work Memory)
- parallel queries (Parallel Query): architecture, monitoring, configuration
- performance and load monitoring (logging long-running queries, analyzing table and index load)
- the PgBench tool
- other performance optimization techniques
35 Hours
Testimonials (2)
The provided examples and labs
Christophe OSTER - EU Lisa
Course - PostgreSQL Advanced DBA
1. A very well-structured training program 2. The warm atmosphere the trainer created, along with his outstanding personal professionalism 3. That the trainer explained everything as if he were talking to a complete beginner, without slipping into any technical jargon.
