PostgreSQL Advanced

Course on working with the PostgreSQL database in various environments. The course provides a deep dive into PostgreSQL to design databases so that you don't have to put out fires later as a result of suboptimal foundations. The goal of the course is to teach the student to work effectively with PostgreSQL in the clouds, to deploy fault-tolerant cluster solutions.

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

• Based on your own physical and virtual infrastructure,
• In clusters based on PostgreSQL: Patroni, Greenplum, CockroachDB, Citus, Yugabyte,
• In a Kubernetes cluster, in incl. GKE, postgres operator,
• In public clouds (GCP, YaO, SberCloud, VKCloud),
• Automate the installation and configuration of VMs and software.

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 database Postgres data using on-premise solutions, virtual and cloud infrastructures
• Conduct in-depth performance analysis. Profiling, monitoring and optimizing queries
• Create and maintain both fault-tolerant, highly available clusters, as well as horizontally scalable and massively parallel ones, and also understand the nuances of operation and use cases of a particular cluster
• 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
• Get skills work 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 for restoring a cluster after a failure
• Get acquainted with modern technologies for creating analytical reporting, compare the capabilities of cubes and the Clickhouse + Superset bundle
• Deploy fault-tolerant cluster solutions in Kubernetes
• Use Terraform to automate the installation and configuration of virtual machines in a production environment
• Use Ansible to automate routine software deployment tasks