PostgreSQL Performance

Course code: POSQLP

This training learns how to safely and effectively optimize the performance of PostgreSQL server. Students understand how to use the tools to monitor, evaluate and tune.

510 EUR

617 EUR including VAT

The earliest date from 10.10.2022

Selection of dates
daniel
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: 10.10.2022

Type: Virtual

Course duration: 2 days

Language: cz/sk

Price without VAT: 510 EUR

Register

Starting date: 17.10.2022

Type: Virtual

Course duration: 2 days

Language: en

Price without VAT: 510 EUR

Register

Starting date: 16.01.2023

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 510 EUR

Register

Starting date: 06.02.2023

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 510 EUR

Register

Starting date: 13.03.2023

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 510 EUR

Register

Starting date: 17.04.2023

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 510 EUR

Register

Starting date: 12.06.2023

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 510 EUR

Register

Starting date: 07.08.2023

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 510 EUR

Register

Starting date: 09.10.2023

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 510 EUR

Register

Starting date: Individual

Type: In-person/Virtual

Course duration: 2 days

Language: en/cz

Price without VAT: 510 EUR

Register

Starting
date
Place
Type Course
duration
Language Price without VAT
10.10.2022 Virtual 2 days cz/sk 510 EUR Register
17.10.2022 Virtual 2 days en 510 EUR Register
16.01.2023 In-person/Virtual 2 days en/cz 510 EUR Register
06.02.2023 In-person/Virtual 2 days en/cz 510 EUR Register
13.03.2023 In-person/Virtual 2 days en/cz 510 EUR Register
17.04.2023 In-person/Virtual 2 days en/cz 510 EUR Register
12.06.2023 In-person/Virtual 2 days en/cz 510 EUR Register
07.08.2023 In-person/Virtual 2 days en/cz 510 EUR Register
09.10.2023 In-person/Virtual 2 days en/cz 510 EUR Register
Individual In-person/Virtual 2 days en/cz 510 EUR Register
G Guaranteed course

Didn't find a suitable date?

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

Contact

Course description

This training learns how to safely and effectively optimize the performance of PostgreSQL server. Students understand how to use the tools to monitor, evaluate and tune. The course makes participants proficient in evaluating architecture, using tools, configuring databases, and tuning SQL code and applications.

Course structure

Hardware and Disks

  • Physical disk anatomy
  • Filesystems
  • Performance considerations with disks
  • Tuning disks for better performance

Transactions and locks

  • Locking and concurrency
  • Write ahead logs
  • Data sync options
  • Checkpoints

Operating system

  • Tuning operating system
  • Memory, work memory and index memory

Indexes and Query planner

  • Examining query planner
  • Index types and their usage
  • Full text searh
  • Planner statistics
  • Table partitioning

Replication overview

  • Log shipping and

Additional tools

  • pgbench

Follow-up courses

MongoDB Developer cz/sk en en/cz

Vendor: EDU Trainings

Area: Databases

Price from

1 080 EUR without VAT

MongoDB Administration en en/cz

Vendor: EDU Trainings

Area: Databases

Price from

1 080 EUR without VAT

MySQL Administration en/cz

Vendor: EDU Trainings

Area: Databases

Price from

510 EUR without VAT

MySQL Performance cz/sk en en/cz

Vendor: EDU Trainings

Area: Databases

Price from

510 EUR without VAT

PostgreSQL Administration cz/sk en en/cz

Vendor: EDU Trainings

Area: Databases

Price from

510 EUR without VAT

PostgreSQL for DB Developers cz/sk en en/cz

Vendor: EDU Trainings

Area: Databases

Price from

510 EUR without VAT

SQL for beginners en en/cz

Vendor: EDU Trainings

Area: Databases

Price from

300 EUR without VAT

Guaranteed

SQL for intermediate users cz/sk en en/cz

Vendor: EDU Trainings

Area: Databases

Price from

300 EUR without VAT

MS SQL Server administration comprehensively and efficiently en/cz

Vendor: EDU Trainings

Area: Databases

Price from

1 210 EUR without VAT

Optimization and monitoring of T-SQL queries cz/sk en en/cz

Vendor: EDU Trainings

Area: Databases

Price from

790 EUR without VAT

ComGate payment gateway MasterCard Logo Visa logo