PostgreSQL Advanced DBA Training Course

Course Code

postgresadmin2

Duration

14 hours (usually 2 days including breaks)

Requirements

It is recommended to attend this training only if you have a prior knowledge of PostgreSQL or have attended PostgreSQL Essentials Training

Overview

This training is designed for Database Administrators and Architects who want to learn the tools and techniques for implementing High Availability and Database Security in PostgreSQL.

You will also learn how to find slow queries, monitor database performance and tune PostgreSQL for Performance. 

Course Outline

  • Introduction
  • Database Security
    • Users and Groups
    • Access Control
    • Row Level Security 
    • Host Based Access Control
    • Data Encryption using pgcrypto
    • Demos and Labs
  • Performance Monitoring and Tuning
    • Monitoring Slow Queries
    • SQL Tuning
    • Table Partitioning
    • Operating System Best Practices
    • Parameter Tuning
    • Extensions
    • Benchmarking
    • Monitoring Best Practices 
    • Demos and Labs
  • High Availability
    • Transaction Log Archiving 
    • Streaming Replication
    • Connection Pooling and HA setup using pgpool-II
      • Installation
      • Configuration
      • Pool Setup
      • HA Setup
    • Demos and Labs
  • Database Upgrades
    • PostgreSQL Versioning
    • Plan for Upgrade
    • Upgrade using pg_dump
    • Upgrade using pg_upgrade
    • In Place or Not-in Place Upgrade
    • Post Upgrade Tasks

Testimonials

★★★★★
★★★★★

Related Categories

Related Courses

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in the US!

As a Business Development Manager you will:

  • expand business in the US
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!

This site in other countries/regions