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

  • Basics of databases
  • Basics of SQL
  • Basics of Systems Administration
  • Basics of Application Design

Topics

  • 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

Acquired Skills

  • 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 days

Upcoming related events