PostgreSQL Advanced - free course from Otus, training 4 months, Date: December 2, 2023.

The course takes a deep dive into PostgreSQL so you can design databases without having to put out fires later as a result of suboptimal foundations.

The goal of the course is to teach the student how to effectively work with PostgreSQL in the clouds and deploy fault-tolerant cluster solutions.

As a result of the training, you will learn to work with PostgreSQL in various environments:

• Based on our own physical and virtual infrastructure,
• In PostgreSQL-based clusters: Patroni, Greenplum, CockroachDB, Citus, Yogabyte,
• In the Kubernetes cluster, incl. GKE, postgres operator,
• In public clouds (AWS, GCP, Azure, YaO, SberCloud).

The course is suitable for:

• DevOps engineers
• SRE
• data architects
• database administrators
• developers

On the course you will learn:

• How to create and run a Postgres database using on-premise, virtual and cloud infrastructure solutions
• Save on IT infrastructure administration
• Bring products to market faster
• Deploy Postgres instances and clusters for development and testing with minimal costs for infrastructure and technical support
instagram viewer
• Gain skills in various virtual and cloud environments
• You will know how clouds differ from each other (including features and nuances) and how to work in each of them
• Consider modern backups using pg_probackup and Wal-G, pg_rewind utility to restore a cluster after a failure
• Deploy fault-tolerant clustering solutions in Kubernetes

As a graduation project, each student will create a fault-tolerant, geographically distributed PostgreSQL cluster.

Evgeny Aristov

6

courses

I have been developing software in Java/Spring, C#, PHP for over 20 years. Database architect PostgreSQL, MongoDB, MSSQL, Oracle, MySQL, MariaDB, Couchbase, etc. Deploy database as on-premise Google Cloud Platform, AWS, Azure,...

Andrey Osipuk

5

courses

Graduated from Astrakhan State Technical University with a degree in Computers, Complexes, Systems and Networks. Currently a senior developer at OOO Seldon, developing services for Rostelecom and other companies. Previously participated in...