Live online batches across IST, EST & GST — learners in 189+ countries
Home Courses Oracle PostgreSQL Database Administration (DBA)
Oracle Upskill with BISP Powered By AI

PostgreSQL Database Administration (DBA)

Get trusted PostgreSQL administration experts for your critical database and infrastructure. World-renowned experts will help maintain your database as well as handle advanced admin.

4.8  ·  Rated by learners Certificate of completion
Duration
25 Hours
Mode
Live + Recorded
Level
Beginner → Pro
Language
English / Hindi

Why learn with BISP

Trusted by professionals across 30+ countries.

Industry trainers

Certified consultants with 12+ years of real project experience.

Hands-on practice

Real-time scenarios & live project modules, not just slides.

Placement support

Resume building, mock interviews & job referrals.

Certification

BISP certificate + full guidance for official exams.

Course curriculum

Designed by real-time industry professionals around current job roles.

Download curriculum (PDF)
17 modules 113 topics
01 Introduction and Architectural Overview 4 topics
  • History of PostgreSQL
  • Major Features
  • Architectural Overview
  • Common Database Object Name
02 PostgreSQL System Architecture 13 topics
  • Architectural Summary
  • Process & Memory Architecture
  • Utility Processes
  • Connection Request-Response
  • Disk Read Buffering Disk
  • Write Buffering
  • Background Writer Cleaning Scan
  • Commit & Checkpoint
  • Statement Processing
  • Physical Database Architecture
  • Data Directory Layout
  • Installation Directory Layout
  • Page Layout
03 Installation 3 topics
  • OS User & Permissions
  • Installation Options
  • Installation of PostgreSQL
04 Database Clusters 4 topics
  • Database Cluster
  • Creating a Database Cluster
  • Starting and Stopping the Server (pg_ctl)
  • Connect to the Server Using psql
05 Configuration 7 topics
  • Setting PostgreSQL Parameters
  • Access Control
  • Connection Settings
  • Security and Authentication Settings
  • Memory Settings
  • Query Planner Settings
  • WAL Settings
06 Creating and Managing Databases 6 topics
  • Object Hierarchy
  • Creating Databases
  • Users
  • Access Control
  • Creating Schemas
  • Schema Search Path
07 Security 5 topics
  • Authentication and Authorization
  • Levels of Security
  • pg_hba.conf File
  • Object Ownership
  • Application Access Parameters
08 SQL: 6 topics
  • Data Types
  • Structured Query Language (SQL)
  • Tables and Constraints
  • Manipulating Data using INSERT,UPDATE and DELETE
  • Creating Other Database Objects: Sequences, Views and Domains
  • Overview of Table Partitioning
09 Backup and Recovery & Point-in Time Recovery 8 topics
  • Backup Types
  • SQL Dump Backups
  • SQL Dump Options
  • Handling Large Databases
  • Restoring SQL Dumps
  • Cluster Dump
  • Offline Backups
  • Recovering a Database using Offline
10 Routine Maintenance 6 topics
  • Database Maintenance
  • Maintenance Tools
  • Optimizer Statistics
  • Data Fragmentation
  • Routine Vacuuming
  • Vacuuming Commands
11 Data Dictionary 5 topics
  • The System Catalog Schema
  • System Information Tables
  • System Information Functions
  • System Administration Functions
  • System Information Views
12 Moving Data 3 topics
  • Loading flat files
  • Import and export data using COPY
  • Examples of COPY Command
13 SQL Tuning 10 topics
  • Statement Processing
  • Common Query Performance Issues
  • SQL Tuning Goals
  • SQL Tuning Steps
  • Identify slow queries
  • Review the query execution plan
  • Optimizer statistics and behavior
  • Restructure SQL statements
  • Indexes
  • Review Final Execution Plan
14 Performance Tuning 8 topics
  • Performance Tuning - Overview
  • Performance Monitoring using PEM
  • A Tuning Technique
  • Operating System Considerations
  • Server Parameter Tuning
  • Memory Parameters
  • Temporary File Parameters
  • WAL Parameters
15 Streaming Replication 17 topics
  • Data Replication
  • Data Replication in PostgreSQL
  • Sync or Async
  • Log-Shipping Standby Servers
  • Log-Shipping Architecture
  • Streaming Replication
  • Hot Streaming Architecture
  • Cascading Replication
  • Setup Replication Using Archive
  • Setup Streaming Replication
  • Prepare the Primary Server
  • Synchronous Streaming Replication Setup
  • Configure Authentication
  • Take a Full Backup of Primary Server
  • Setting up the Standby Server
  • Adding Cascading Replicated Standby Server
  • Monitoring Hot Standby
16 Upgrade 4 topics
  • Version Change and Upgrade
  • Need to Upgrade
  • Upgrade Plan
  • Upgrade Using pg_upgrade
17 GUI Tools: 4 topics
  • Overview of ORAp2G Tool
  • PGADMIN4
  • PgBouncer for Connection Pooler
  • PgBackRest for Backups

Course details

Who it is for, what you need, and how it is delivered.

Who should learn PostgreSQL Database Administration (DBA)?
  • Anyone who wants to add PostgreSQL DBA skills to their profile
  • Teams getting started on PostgreSQL DBA projects

 

Prerequisites

Mandatory

  • Understanding of SQL
  • Database concepts

Suggested

  • Knowledge of Linux environment

Certificate of completion

Earn an industry-recognised BISP Trainings certificate when you finish the course.

BISP Trainings Certificate of Completion
  • Verifiable certificate with a unique ID
  • Shareable on LinkedIn & your resume
  • Recognised by our hiring partners

Upcoming batches

Reserve your seat for the next live session.

SessionDateTimeReserve
D 25 Dec 2026 (Fri) 08:00 Reserve seat →
R 28 Dec 2026 (Mon) 08:00 Reserve seat →

Frequently asked questions

Everything you need before you enroll.

Can I attend a demo session before enrollment?

Yes. You may attend a demo class before enrollment for training quality evaluation, and interact one-to-one with the trainer for any specific requirement.

Can you schedule training as per my availability?

Yes. We discuss it with the trainer and schedule the training at a convenient time for you.

What if I miss a class?

You get the recorded session. You may also retake the whole training multiple times within a 6-month period with the same trainer.

Is there live project training?

Yes. The curriculum includes real-time scenarios and live project modules, with the trainer explaining every topic end-to-end.

How can I pay for the course?

Enroll securely via the payment gateway on this page using card, UPI or net-banking. EMI options are available.

More queries?

Call us at +91 769-409-5404 & +1 678-701-4914, or write to support@bisptrainings.com.

Case studies & learning PDFs

Free Oracle resources to explore.

Relevant courses

Learners who took this also explored these.

Not sure if this course is right for you?

Book a free 1-on-1 counselling call and get a personalised learning roadmap.

Book free trial →