PostgreSQL Administration Training

PostgreSQL Administration Training

4.5 out of 5 - Read Testimonials
Course Length: 4 days
Delivery Methods: Available as private class only
Course Overview

Students taking this PostgreSQL Administration training class will learn to effectively administer PostgreSQL.

Course Benefits
  • Learn to install PostgreSQL server and client.
  • Learn to use psql and other PostgreSQL command line utilities.
  • Learn to configure a a PostgreSQL cluster.
  • Learn about PostgreSQL data types.
  • Learn to create and use views.
  • Learn to manage cluster security.
  • Learn to create users and assign roles.
  • Learn backup and recovery methods.
  • Learn to optimize PostgreSQL.
  • Learn about replication.
  • Learn to upgrade PostgreSQL.
  • Learn about continuous archiving and point-in-time recovery.
Course Outline
  1. Installing PostgreSQL Server and Client
    1. Comparison of installation methods
    2. Demonstration of installation
    3. Hands-on installation exercise
  2. Administration Tools and Options
    1. psql options
    2. Other PostgreSQL command line utilities
  3. Configuring a PostgreSQL Cluster
    1. Review components of a PostgreSQL cluster
    2. Initialize and run a cluster
  4. SQL in PostgreSQL
    1. DDL
    2. DML
    3. Running queries in psql
    4. PostgreSQL data types
    5. Creating and using views
  5. Cluster Security
    1. Enabling remote connections to cluster
    2. Host-based authentication (pg_hba.conf)
  6. User Security
    1. Creating users
    2. Using and assigning user roles
    3. User authentication
  7. Backup and Recovery Methods
    1. Selecting an effective backup approach
    2. Logical backup
    3. Offline Physical backup
  8. PostgreSQL Optimization
    1. EXPLAIN
    2. Configuring PostgreSQL system logs
  9. High Availability Configuration and Operation
    1. Setting up streaming replication
    2. Master-Standby replication
  10. Upgrading PostgreSQL
    1. Minor version upgrades
    2. Major version upgrades
    3. pg_upgrade utility
  11. Logical Replication
    1. Setting up logical replication
    2. Publisher/Subscriber configuration
  12. Continuous Archiving and Point-in-Time Recovery (PITR)
    1. Setting up WAL archiving
    2. Running an online physical backup
    3. Recovery from a continuous archive
Class Materials

Each student will receive a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this PostgreSQL class:

  • Familiarity with databases.
Request a Private Class
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors
Request Pricing