PostgreSQL Introduction

Overview

The PostgreSQL Immersion course is a self-contained program, created by combining selected topics from three other comprehensive courses: Administration and Replication; 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
Course duration

2 Days

Course outline
  • 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

About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac
Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy