PostgreSQL Immersion

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 course has minimal prerequisites, making it ideal as a speedy introduction to PostgreSQL. It is suitable for a wide range of participants, such as: application developers with working knowledge of databases, system administrators, and database administrators having prior experience with any database software.

Prerequisites Topics Acquired skills

- Basics of databases

- Basics of SQL

- Basics of Systems Administration

- Basics of Application Design

- Introduction to PostgreSQL

- OmniDB

- Server Configuration

- Database Administration

- User Administration

- Understanding Database Object Types

- Monitoring

- VACUUM, Freezing & Avoiding Wraparound

- Managing Cloud Databases

- Server Architecture & Server Tuning

- Security

- Database Design Alternatives

- Advanced Development

- EXPLAIN and SQL Execution

- Workload Analysis

- Indexes

- Partitioning

- Replication Architecture

- Point-In-Time Recovery

- Logical Backup

- Logical Replication Overview

- Online Upgrade

- Bi-Directional Replication

- Replication Startup & Setup

- Disconnection & Reconnection

- Switchover, Failover & Failback

- Physical Streaming Replication & Hot Standby

- repmgr

- Physical Backup

- Barman

- Basics of PostgreSQL

- PostgreSQL Database Administration

- PostgreSQL Application Design

- PostgreSQL Tuning and Performance

- PostgreSQL Database Architecture

- Advanced PostgreSQL development

- PostgreSQL Replication

- PostgreSQL High Availability

- PostgreSQL Disaster Recovery

- Basics of PostgreSQL Scalability

Tags: PostgreSQL, Administration, Backup and Disaster Recovery

Code: PGIMMEN
Length: 5.00 days

Upcoming related events


Stay in touch with us

Subscribe to our monthly newsletter to hear the latest developments from 2ndQuadrant and related technologies.

We’ll also send you any important news or updates that we think you’ll find useful.

We value your privacy and will not pass your details on to anyone else.