Skip to main content
  • 4.7
  • 5.0

Official Learning Partner

PostgreSQL DBA Training

PostgreSQL DBA Training includes 100% practical, step-by-step training on Database management, Maintenance, Security, Optimization, Cloud Migrations, Monitoring, Data Recovery, Disaster Recovery, Automation, Updates, and more..! You also gain knowledge of advanced topics such as Replication, Clustering, and Cloud Monitoring Tools. By the end of the training, you can handle complex database environments effectively, ensuring reliability and performance. This PostgreSQL DBA Training is ideal for IT professionals seeking careers in database management.

Register Now
PostgreSQL DBA DemoPlay Video

Trainer: Mr. Srinivas S

14+ years of Experience

Training Highlights:

  • Introduction to PostgreSQL
  • Configuration
  • Backup/Restore Strategies
  • Performance Tuning
  • Replication
  • Database Security
  • Database Migration
  • Memory Architecture
  • CRUD Operations
  • Query Optimization
  • Troubleshooting
  • Extensions
  • Disaster Recovery
  • Cloud Integration
  • High Availability
  • Advanced SQL

PostgreSQL DBA Training Plans

Plan A

1. PostgreSQL DBA

Plan B

2. PostgreSQL DBA with Azure
Course CurriculumChapters 1 to 30Chapters 1 to 45
Duration6 Weeks8 Weeks
PostgreSQL: Archtiecture, Configurations✔✔
PostgreSQL: SQL Queries and Sub Queries✔✔
PostgreSQL: Constraints, Keys, Joins & Views✔✔
PostgreSQL: Stored Procedures and Functions✔✔
PostgreSQL DBA: Lock Management, Tuning✔✔
PostgreSQL DBA: Backups and Restores✔✔
PostgreSQL DBA: HA DR with Replication✔✔
PostgreSQL DBA: HA DR with Log Shipping✔✔
PostgreSQL DBA: Security Management✔✔
PostgreSQL DBA: Service Packs, Maintenance✔✔
PostgreSQL DBA: Common Issues, Solutions✔✔
PostgreSQL in Azure: Configurations, Migrations✖✔
PostgreSQL in Azure: Server Modes✖✔
PostgreSQL in Azure:Hybrid Cloud✖✔
PostgreSQL in Azure: Maintenance and Tuning✖✔
PostgreSQL in Azure: Server Failover✖✔
PostgreSQL in Azure: Server Maintenance✖✔
PostgreSQL in Azure: Security Management✖✔
Total Course Fee ( Payable in Installments)*INR 18000USD 220INR 24000USD 290

Completion of Course

"SQL certification course completion certificate with participant's name, issued by SQL School

PostgreSQL DBA Training Schedules

S NoTime (IST, Mon - Fri)Start DateRegister
28 PM - 9 PMFeb 18thRegister
16 AM - 7 AMJan 22ndRegister

Can’t find a batch you
were looking for?

CONTACT US

If you need self
paced videos

CONTACT US

CERTIFICATE OF COMPLETION

PostgreSQL DBA

PostgreSQL DBA Training
Course Contents:

Brochure DownloadRegister Now

Part 1: PostgreSQL DBA Training

Module 1

Ch 1: Introduction to PostgreSQL

  • Overview of PostgreSQL
  • History and Evolution of PostgreSQL
  • Features, Versions and Benefits of PostgreSQL
  • PostgreSQL Architecture

Ch 2: Installation

  • PostgreSQL on Windows
  • PostgreSQL on Linux using Yum repository and RPM
  • PostgreSQL on Linux using Source Code
  • PostgreSQL on Linux using Contrib Module

Ch 3: Configuration File & Directory Layout

  • Data Directory
  • Configuration Files
  • Other Physical Files
  • Database Directory Layout Base Directory

Ch 4: Database Cluster

  • PostgreSQL Cluster (Initdb, Start/Stop/Restart/Reload)
  • Start and stop using systemctl.
  • PostgreSQL Cluster Demo on Windows
  •  PostgreSQL Cluster Demo on Linux

Ch 5: Process & Memory Architecture

  • Postmaster Process
  • Utility Processes
  • Memory Segments & Memory Components

Ch 6: Create Objects and Privileges

  • Create/Drop Database
  • Create/Drop User
  • Create/Drop Schema and Search Schema Path
  • Grant/Revoke Privileges on Database Objects

Ch 7: Tools (psql & pgAdmin) and catalog

  • Using psql command line interface (CLI)
  •  pgAdmin(GUI) : Practical Use
  •  g_catalog : Realtime Usage
  • Information_Schema & Medata Audits

Ch 8: CRUD Operations

  • CRUD Introduction
  • Create Table, Data Types, Constraints, Functions and Operators
  • Retrieve Data in PostgreSQL
  •  Update Records in a Table
  •  Delete Records in a Table
  •  Truncate

Ch 9: Tablespaces

  • Tablespace Introduction
  •  Default Tablespace (pg_default & pg_global)
  •  Local & Global Tablespaces
  •  Create/Drop Tablespaces
  •  Temporary Tablespace

Ch 10: Backup and Restore

  • Introduction to PostgreSQL Backups
  • Backup using pg_dump and psql utilities
  •  Restore using pg_restore and psql utilities
  •  Offline Backups
  •  Online Backups
  •  pg_basebackup utility

Ch 11: Advanced Backup & Restore

  • pgBackRest
  • Point-In-Time-Recovery (PITR)

Ch 12: MVCC (Multi-Version Concurrency Control) in PostgreSQL

  • What is MVCC in PostgreSQL?
  •  How does MVCC work in PostgreSQL?
  •  Key Data Structures in MVCC
  •  Benefits of MVCC in PostgreSQL
  •  Transaction ID Wraparound

Ch 13: Database Maintenance, Vacuum and Analyze

  • Introduction to Maintenance
  •  Vacuum
  •  Analyze
  •  Statistics
  •  Clustering
  •  Auto-Vacuum

Ch 14: Joins and Constraints 

  • Introduction on Joins and Constraints
  •  Join Types (Inner, Equi and Outer)
  •  Constraints (Primary Key, Unique, Foreign Key and NOT NULL etc…)
  •  SERIAL Column
  •  ER Diagram

Ch 15: Indexing and Types

  • Introduction to Indexes
  •  Basic Index Types (B-Tree, Hash and Function/Expression)
  •  Advanced Index Types (GiST, SP-GiST, GIN and BRIN).

Ch 16: Performance Tuning – Part 1

  • Database Tuning 
  •  Query Tuning 

Ch 17: Performance Tuning – Part 2

  • Configuration Tuning
  •  Monitoring and Maintenance
  •  Hardware Tuning

Ch 18: Data Loading

  • Moving, Copying, Export, Import, copy etc…
  •  pgloader
  •  Foreign Data Wrappers (FDW)

Ch 19: Extensions

  • What are Extensions in PostgreSQL?
  •  Types of Extensions in PostgreSQL.
  •  Examples of Extensions in PostgreSQL.
  •  How to Install/Uninstall Extensions in PostgreSQL.

Ch 20: High Availability and Replication 2

  • High Availability Architecture
  •  Master/Primary and Slave/Standby
  •  HA step-by-step configuration using Streaming Replication
  •  Manual Failover and Switchover
  •  promote command

Ch 21-22: Advanced -1 High Availability Concepts

  • HA step-by-step setup using Streaming Replication
  • HA step-by-step using Logical Replication
  • Automatic Failover & Switchover

Ch 23-24: Advanced -2 High Availability Tools and Software

  • pgpool: A PostgreSQL-specific connection pooling and replication tool
  •  repmgr: A tool for managing PostgreSQL replication clusters
  •  Patroni: A PostgreSQL-specific high availability tool that provides automated failover and
    switchover

Ch 25-26: PostgreSQL HA and disaster recovery (DR) strategies

  • Introduction to disaster recovery (DR)
  •  High Availability Strategies (Master-Slave, Master-Master, Multi-Master)
  •  Disaster Recovery Strategies (PITR, Backup and Restore and Replication)
  •  Tools and Software required for DR

Ch 27: Performance Tuning Using Server Parameters and Partitioning.

  • Introduction to Server Parameters
  • Tune Server Parameters
  • Partitioning

Ch 28: Migration to PostgreSQL.

  • Manual Migration
  • Using pg_dump and pg_restore
  • Using Database Migration Tools
  • Using Third-Party Tools

Ch 29: Upgrade PostgreSQL

  • Upgrade Methods
  • Minor version upgrades
  • Major version upgrades

Ch 30: Monitoring and Reports

  • Monitoring using Grafana
  • Monitoring using pg_stat_statments
  • pgBadger

Part 2: Azure Database For PostgreSQL

Module 2

Chapter 31: Azure Cloud Introduction and Fundamentals

  • Cloud Fundamentals
  • Cloud Concepts, Benefits
  • IaaS, PaaS, SaaS Cloud Types
  • Azure Cloud Concepts
  • Azure Resources & Usage
  • Azure Services & Purpose
  • Azure Account & Subscription

Chapter 32: Benefits of Running PostgreSQL in Azure

  • Scalability
  • High Availability
  • Security
  • Cost-Effective

Chapter 33: Azure PostgreSQL Options

  • PostgreSQL database on Azure Virtual Machines
  • Fully Managed Azure Database for PostgreSQL
  • Azure Kubernetes Service (AKS

Chapter 34: Create Objects and CRUD operations in AZURE

  • Create/Drop Databases
  • Create/Drop Users
  • Create/Drop Tables
  • SELECT, INSERT, UPDATE, DELETE and TRUNCATE

Chapter 35-36: PostgreSQL DB Migrations in AZURE

  • Azure Database Migration Service (DMS)
  • Azure Data Factory (ADF)
  • pg_dump and pg_restore
  • Azure Database for PostgreSQL Migration Tool
  • Third-party tools

Chapter 37: Backup and Automated Backup in AZURE

  • Backup Options in Azure for PostgreSQL
  • Automated Backup Options in Azure for PostgreSQL
  • Configuring Automated Backups in Azure for PostgreSQL
  • Best Practices for Backing up PostgreSQL Databases in Azur

Chapter 38: Restore a Backup in AZURE

  • Restore Options in Azure for PostgreSQL
  • Restoring a Database using Backup Restore
  • Restoring a Database using pg_restore
  • Restoring a Database using Point-in-Time Restore (PITR)
  • Best Practices for Restoring PostgreSQL Databases in Azure

Chapter 39: Performance Tuning of PostgreSQL database in AZURE

  • Azure-Specific Performance Tuning
  • PostgreSQL Configuration Tuning
  • Query Optimization
  • Monitoring and Maintenance

Chapter 40: PostgreSQL HA in AZURE

  • HA Architectures
  • Azure Native HA Options
  • Third-Party HA Options
  • Best Practices

Chapter 41: PostgreSQL disaster recovery (DR) in Azure

  • Disaster Recovery Options
  • Disaster Recovery Strategies
  • Azure Services for Disaster Recovery
  • Best Practices

PostgreSQL DBA Training FAQs

What is Postgres?

Postgres is a opensource Platform to store, manage and administer databases.
Very easy and versatile. Easy to manage and operate

What is PostgreSQL DBA Job Role?

PostgreSQL Database Administrator (DBA) manages, maintains, and optimizes PostgreSQL
database systems. Key Responsibilities include:
1. Database Administration
2. Performance Tuning
3. Backup and Recovery
4. DB Security
5. Upgrades and Migrations
6. Database Design
7. Monitoring and Maintenance
8. Cloud Migrations
9. Cloud Management
10. Cloud Security & HA DR, more .. !

Who can join this course?

1. Existing Other Database Administrators (DBA)
2. Database Developers.
3. System Administrators.
4. Data Analysts/Scientists.
5. IT Professionals.
6. Students.
7. Developers
8. Data Engineers
9. Anyone who wanted to step into / start career in Database Platform

What about the Lab? What are the System Requirements?

Here are the system requirements to install PostgreSQL:
Hardware Requirements:
1. RAM: 8 GB or Higher
3. Storage: 10 GB or more of free disk space
Software Requirements:
Operating System: PostgreSQL supports various operating systems, including:
– Linux (Ubuntu, Red Hat, CentOS, etc.)
– Windows (10, 8, 7, Server 2019, etc.)
– macOS (10.12 or later)
– FreeBSD / OpenBSD / Solaris

What about Placement Assistance?

We train you with step-by-step activities, concept wise FAQs and Answers. Resume Guidance
and Placement Assistance part of this PostgreSQL DBA Course.

How do I join the course?

Reach us for free demo on +91 9666440801 or visit us on www.sqlschool.com/schedules

Why Choose SQL School

Azure DevOps and azure fundamentals video bannerPlay Video
  • 100% Real-Time and Practical
  • ISO 9001:2008 Certified
  • Concept wise FAQs
  • TWO Real-time Case Studies, One Project
  • Weekly Mock Interviews
  • 24/7 LIVE Server Access
  • Realtime Project FAQs
  • Course Completion Certificate
  • Placement Assistance
  • Job Support
  • Realtime Project Solution
  • MS Certification Guidance
×
Verified by MonsterInsights