TRACK 1 OF 3

Core Operations

Hands-On PostgreSQL DBA Training. Production Labs. Real-World Operations from Day 1.

18 Modules
4 Production Projects
4-6 Weeks
₹20,000

Who Is This Track For?

  • Mid-level DBAs (3-7 years) wanting production PostgreSQL expertise
  • DBAs from Oracle/MySQL transitioning to PostgreSQL
  • Engineers wanting hands-on production database operations training
  • Anyone who wants practical DBA skills with real labs and real tools

What You'll Achieve

🔧

Hands-On Practicals

ProductionDB: Full practical labs — install, configure, break, fix, deploy PostgreSQL

🎯

Production DBA Skills

Master HA with Patroni, PITR recovery, Pgpool-II, ora2pg migration, AWS RDS

📚

Production Codebases

Study 3 BankForge projects — real banking code, DBA operations, AI/ML integration

💼

Career Growth

Target ₹18-30 LPA mid-level DBA positions with real practical experience

Complete Module Breakdown

Phase 1: ProductionDB (Hands-On Practical) Week 1-3 | Full Labs

Core DBA training based on the PostgreSQL + AWS Aurora production course. Every module includes hands-on labs — you install, configure, backup, replicate, failover, migrate, and deploy on real PostgreSQL instances.

M01 PostgreSQL Fundamentals & Architecture
MVCC, WAL, shared memory, utility processes, initdb, pg_ctl, systemd, data directory structure
M02 Configuration & Security
postgresql.conf, pg_hba.conf, SCRAM-SHA-256, RBAC, psql, pgAdmin, system catalog views (pg_stat_activity)
M03 Backup & Recovery with pgBackRest
pg_dump, pg_basebackup, WAL archiving, full/differential/incremental backups, Lab: Point-in-Time Recovery (PITR)
M04 High Availability with Patroni
etcd cluster, automatic failover, streaming replication (sync/async), Lab: Setup HA cluster with automatic failover
M05 Connection Pooling & Load Balancing
Pgpool-II vs PgBouncer, pool modes, HAProxy, read/write splitting, Lab: Load balancer configuration
M06 Oracle to PostgreSQL Migration
ora2pg tool, PL/SQL → PL/pgSQL conversion, AWS DMS, data type mapping, Lab: Live migration demonstration
M07 AWS RDS & Aurora PostgreSQL
RDS setup, Aurora architecture, parameter groups, automated backups, read replicas, Multi-AZ deployment
Phase 2: BankForge Core (~100 Files) Week 3-4 | Study Production Code
M08 Banking Application Architecture - Schema design, REST APIs, admin dashboard, ACID transactions
M09 Performance Lab: 6 Index Types - B-tree, Hash, GiST, GIN, BRIN, partial/expression indexes
M10 Query Optimization - EXPLAIN ANALYZE, plan interpretation, join strategies, planner tuning
M11 Partitioning Strategies - Range, list, hash partitioning, partition pruning
Phase 3: BankForge-DBA-Operations Week 4-5 | DBA Operations & Maintenance
M12 Stored Procedures & Functions - PL/pgSQL, money transfer safety, error handling
M13 Triggers for Audit & Validation - BEFORE/AFTER triggers, audit trails, data validation
M14 VACUUM, ANALYZE & Bloat - Autovacuum tuning, bloat detection, maintenance planning
M15 Database Health Monitoring - pg_stat_* views, long queries, blocking sessions, growth tracking
Phase 4: BankForge-AI (pgvector & ML) Week 5-6 | AI-Powered Banking
M16 pgvector Extension - Vector types, similarity search, HNSW/IVFFlat indexes
M17 AI-Powered Banking Chatbot - OpenAI embeddings, FAQ vectors, RAG pattern, semantic search
M18 Fraud Detection with ML - Transaction patterns, anomaly detection, real-time scoring
Bonus: Essential Prerequisites (Self-Study) As Needed
✓ Linux for DBAs (commands, file system, SSH)
✓ Python for PostgreSQL (psycopg2, automation)
✓ Shell Scripting (bash, cron, log analysis)

How Track 1 Works

ProductionDB — You DO

Full hands-on practicals. Install PostgreSQL, configure HA with Patroni, perform PITR recovery, set up Pgpool-II, run ora2pg migrations, deploy on AWS RDS. You execute every lab.

BankForge Projects — You STUDY

Review 3 production codebases: BankForge Core (~100 files), BankForge-DBA-Operations, and BankForge-AI. Understand how production banking apps are built, monitored, and secured.

Want to build your own banking app from scratch? Track 2 includes everything in Track 1 + you build SampleBank end-to-end.

Investment

₹20,000
$288 USD | Fixed Price
EMI: 2 x ₹10,000

Start Mastering PostgreSQL Operations

Hands-on practicals. 18 modules. Real production tools. ₹20,000.

Enroll in Track 1: Core Operations
Scroll to Top