PostgreSQL Professional

Course code: PROFSQL

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.

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: Czech
Course length: 3 DAYS

Additional information

Each participant will be provided with a PDF of the presentations
1 500 EUR

1 815 EUR including VAT

The earliest date from 08.07.2024

Selection of dates
onas
Do you have a question?
+420 731 175 867 edu@edutrainings.cz

Professional
and certified lecturers

Internationally
recognized certifications

Wide range of technical
and soft skills courses

Great customer
service

Making courses
exactly to measure your needs

Course dates

Starting date: 08.07.2024

Type: In-person/Virtual

Course duration: 3 days

Language: cz/sk

Price without VAT: 1 500 EUR

Register

Starting date: 16.09.2024

Type: In-person/Virtual

Course duration: 3 days

Language: cz/sk

Price without VAT: 1 500 EUR

Register

Starting date: 18.11.2024

Type: In-person/Virtual

Course duration: 3 days

Language: cz/sk

Price without VAT: 1 500 EUR

Register

Starting date: Upon request

Type: In-person/Virtual

Course duration: 3 days

Language: cz/sk

Price without VAT: 1 500 EUR

Register

Starting
date
Place
Type Course
duration
Language Price without VAT
08.07.2024 In-person/Virtual 3 days cz/sk 1 500 EUR Register
16.09.2024 In-person/Virtual 3 days cz/sk 1 500 EUR Register
18.11.2024 In-person/Virtual 3 days cz/sk 1 500 EUR Register
Upon request In-person/Virtual 3 days cz/sk 1 500 EUR Register
G Guaranteed course

Didn't find a suitable date?

Write to us about listing an alternative tailor-made date.

Contact

Course structure

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
ComGate payment gateway MasterCard Logo Visa logo