PostgreSQL Database Administration
Advanced Development & Performance
This class covers important Intermediate and Advanced level details for developers interacting with PostgreSQL. The course begins with the overall database architecture, followed by details about crucial features like MVCC or locking and what consequences that has on applications or maintenance.
The PostgreSQL Immersion course is a self-contained program, created by combining selected topics from three other comprehensive courses: Administration and Replication; Advanced Development and Performance; and Backup & Disaster Recovery.
This training course highlights the importance of database security within an enterprise. We will discuss how to identify and secure database breach points.
Introduction to PostgreSQL and Kubernetes
This course introduces the paradigm of immutable infrastructure as a new way of thinking applications, IT processes and systems in general, using Kubernetes, the open source container orchestration platform.
Replication, Backup & Disaster Recovery
This class covers the basics of replication, backup and recovery through administration and application of design.
This course covers the basic concepts of Bi-Directional Replication for PostgreSQL. BDR is the first open source multi-master replication system for PostgreSQL to reach full production status.
Linux for PostgreSQL DBAs
PostgreSQL Data Warehousing & Partitioning
This course discusses how to design Data Warehouse solutions based on PostgreSQL, starting from the basics and then moving to specific aspects such as partitioning, data loading, scalability and performance optimization for analytic queries.
PostgreSQL for Developers
This class covers important basic and intermediate level details for developers interacting with PostgreSQL. Suitable for developers using Java, PHP, Python, perl, .Net and other client languages.
PostgreSQL Immersion for Cloud Databases
The PostgreSQL Immersion for Cloud Databases is a shorter version of the Immersion course, covering topics that are more relevant for users of Cloud Databases.
This course covers SQL language starting from the basics, and touching fundamental constructions such as data selection and modification, joins and aggregation.
An in-depth and practical course covering this horizontally scalable extension to PostgreSQL. This course will help delegates understand and implement massively parallel databases using Postgres-XL.