Technologies / Data & Analytics

PostgreSQL - administration, optimization and replication

An advanced training course that comprehensively covers administration, optimization and replication in PostgreSQL. The workshop program focuses on the practical aspects of database management in a production environment, with an emphasis on performance and high availability. Participants work on real cases and scenarios.

Issues

Advanced PostgreSQL configuration
Performance optimization
Data replication
High availability
Monitoring and diagnostics
Space management
Partitioning
Backup and recovery
Disaster recovery
Scaling databases
Security
Production scenarios

Benefits

The participant will develop advanced PostgreSQL database administration skills
Configuring and managing replication
Will learn to implement high availability solutions
Will learn advanced performance optimization techniques
Will master methods for effective monitoring and diagnostics
Will develop the ability to solve complex production problems
Will gain knowledge of best practices in managing large databases

Who is this training for?

Experienced database administrators

DevOps Engineers

Database solution architects

Systems administrators

Database performance specialists

Reliability engineers

Administrators of high availability environments

Prerequisites

Experience in PostgreSQL administration
Knowledge of Linux/Unix systems
Practical knowledge of SQL
Experience in a production environment

Training program

Disk space management
Autovacuum and maintenance

Performance optimization
Query analysis and tuning

Partitioning of tables
Configuration optimization
Replication and high availability
Replication configuration

Failover and switchover
Load balancing
Monitoring and diagnostics
Monitoring tools
Performance analysis

Auditing and logging
Production scenarios
Migrations and upgrades

Scaling databases
Optimization in practice

Delivery Methods

Online

Convenience of participating from anywhere
Interactive live sessions with trainer
Materials available for 30 days
No travel costs

On-site

Direct contact with trainer and group
Intensive hands-on workshops
Networking with other participants
Full focus on learning

Frequently asked questions

Who is the PostgreSQL - administration, optimization and replication training for?

This training is designed for professionals looking to develop skills in postgresql - administration, optimization and replication. Required level: advanced.

How long is the PostgreSQL - administration, optimization and replication training?

The training lasts 5. Available in online or on-site format.

Will I receive a certificate?

Yes — every participant receives a completion certificate confirming acquired competencies. EITT holds ISO 9001 accreditation.

Can this training be conducted for a closed group?

Yes — we offer dedicated closed trainings for companies. We customize the program to your team's needs. Contact us for an individual quote.