PostgreSQL Professional

PostgreSQL Professional

This course provides a deep insight into advanced PostgreSQL topics like indexing, storage parameters, optimization, replication, monitoring, etc. It covers the technical foundations required for replication, scaling, point-in-time recovery, and the successful operation of synchronous and asynchronous replication solutions. Moreover, details of processing that are essential for optimization and performance tuning are highlighted, so that you can get the most out of your system and queries.

Information about the course

Designed for the product: PostgreSQL
Group size: Group of up to 15 students
Type of exam: 30 min, theoretical
Requirements: None
Next level: PostgreSQL – administration and performance tuning
Previous level: Introduction to PostgreSQL
Course language: English
Available online: Yes
Course length: 3 DAYS
Course price: € 1,500 excluding VAT

Course content

Day 1

 
  • Installation
  • Advanced psql
  • Advanced indexing: Multi column indexes, GIN indexes, GiST indexes
  • Full text search
  • Exclusion Constraints
  • Range data types
  • Arrays and JSON in the database
  • Transactions: isolation levels, serialization
  • Prepared transactions, two-phase commit

Day 2

 
  • Physical Backup: Low-level API
  • Autovacuum: advanced tuning
  • Streaming replication
  • Synchron replication
  • Hot Standby and conflict management
  • Failover
  • High Availability, Patroni
  • Logical replication

Day 3

 
  • Partitioning
  • Parallel queries
  • Foreign Data Wrapper
  • Functions
  • Statement tuning: finding slow statements
  • EXPLAIN (ANALYZE, BUFFERS)
  • Extended Statistics
Jakub Zemanek

Jakub Zemanek

Technical Consultant & DBA
Jakub's main interests in the OpenSource world are advanced PostgreSQL configuration and database troubleshooting, followed by automation using Ansible, and last but not least the ELK Stack (LOG Management) and the security product Wazuh (SIEM). As Jakub likes to say about himself: "I'd rather do it best than somehow." This is also why he is constantly educating himself and pushing the boundaries of his capabilities.

Additional information

Each participant will be provided with a PDF of the presentations

Certificate

  • After successfully passing the exam, you will obtain the offical Cybertec certification
initMAX - certificate
Other courses

Course certificates and gifts

For all attendees

Dárek ke kurzu
Course attendance certificate
Dárek ke kurzu
Mastering PostgreSQL book

For passing the exam

Dárek ke kurzu
Cybertec PostgreSQL Professional certificate

Registration

"(Vyžadováno)" indicates required fields

GDPR(Vyžadováno)
This field is for validation purposes and should be left unchanged.

×Shopping Cart

Your cart is empty.