🚀 PostgreSQL DBA Realtime Training
📢 New Batch Starts
From:
🗓 September 6th,
2025 (Saturday)
🕕 Time: 6:00 AM
– 7:00 AM IST
Zoom
Link: https://us02web.zoom.us/j/88095487436?pwd=ItUgbwNQ4l6qkGbGhmytwjyREENMAs.1
Meeting
ID: 880 9548 7436
Passcode: 257875
✅ 3 Days FREE – Attend,
Listen, and Decide
✅ Daily
Recorded Videos, Notes & Sample Resume
✅ Interactive
WhatsApp Group for Q&A & Discussion
✅ Basic
to Advanced PostgreSQL Training
✅ Real-time
Scenarios & Interview Preparation
📚 Comprehensive
Course Content
🧱 PostgreSQL Foundations
·
PostgreSQL History
·
Why PostgreSQL
required over other databases
·
PostgreSQL
Introduction
·
PostgreSQL Complete
Architecture
·
Linux Setup and Basics
·
PostgreSQL Source Code
Installation
·
PostgreSQL Yum
Installation
·
PostgreSQL Major and
Minor version upgrade
·
PostgreSQL Patching
·
Environment Variables
Setup
·
PostgreSQL Services
Auto startup
·
PostgreSQL Object
Management and database connectivity
·
PostgreSQL Audit
Logging and Housekeeping
·
Host Based
Authentication
·
PostgreSQL User Access
Management
·
PostgreSQL Metadata
Tables
·
PostgreSQL Physical
Structure
·
Table-space Management
·
Data Export and Data
Import
·
Logical and Physical
backups and Restore [20 to 25 scenarios]
·
->pg_dump
·
->pg_dumpall
·
->pg_restore
·
->pg_basebackup
🛠 Backup,
Restore & Recovery
- Physical
& Logical Backups:
- pg_dump,
pg_dumpall, pg_restore, pg_basebackup
- PITR
(Point-in-Time Recovery)
- Incremental
Backup (v17)
- Database Maintenance Activities
🔁 Replication
& High Availability
- Warm Standby
& Streaming Replication
- Multi-standby
(A←B,C), Cascading (A←B←C)
- Automatic
Failover with Auto Failover Extension
- Failover, Switchover & Node Rejoining
🧰 Tools & Utilities
·
Pgbadger
(LOG ANALYZER TOOL)
·
Pgbouncer
(CONNECTION POOLING/
RESERVED CONNECTIONS)
·
Pgadmin
(Graphical interface
to Access PostgreSQL Database)
· Pgbench (maximum what is our database capacity, how much load it can handle)
🧩 PostgreSQL Extensions
·
pg_stat_statements (to
track query execution statistics)
·
pg_passwd (to make
password more complex)
·
dblink (for cross
database connectivity)
·
pg_buffercache
(whether our getting data from cache or disk)
·
pg_hypopg (without
creating index, we can generate explain plan by assuming index is there)
·
pg_autoexplain
(explain plan will be recorded in the audit log automatically)
🖥
Monitoring & Performance Tuning
·
Tuning database level
parameters
·
Tuning the query
·
Optimize database for
loading
·
Default parameters for
tuning
·
Mount points designing
🔄 Oracle
to PostgreSQL Migration
☁ AWS RDS PostgreSQL
- Instance
Creation & Upgrades
- PITR Setup,
Monitoring, Connectivity
- Parameter & Security Groups
🔎 Advanced Topics
- PostgreSQL
Joins, Partitioning
- Inheritance
(Child/Parent Tables)
- Row Level
Security, MVCC
- Constraints
Management
📲 WhatsApp Support: +91
76039 01696 | +91 91820 68449
🌐 Website: https://sahasraittech.com/
✔ Learn
from real-time scenarios
✔ Get
job-ready with advanced concepts
✔ Limited
seats – Book your spot today!
