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 (5)
The knowledge and manner of conducting the training by the instructor, answering all questions, and the approach to participants.
Anna Knap - Intel Technology Poland sp. z o.o.
Course - PostgreSQL 16 for Developers and Administrators
Machine Translated
Amount (a lot) of knowledge provided. Cheerful aprroach to the subject.
Oskar Debowski - Asseco Poland S.A
Course - PostgreSQL Administration, Optimization and Replication
advance topics hands on + discussion like timescaleDB and hypertable , trainer's knowledge on the subject :)
Shivam - Paessler LLC
Course - PostgreSQL Fundamentals
Andres consistently ensures that he addresses all attendee questions and strives to ensure everyone comprehends his teachings. I admire his expertise and proficiency in the subject matter
Ryan - Questronix Corporation
Course - PostgreSQL for Administrators - 3 Days
Method of translation
Michal Borkowski - Telbud S.A.
Course - Implementing High Availability in PostgreSQL
Machine Translated
