---
title: "Track 1: Core Operations – Detailed Curriculum"
id: "1271"
type: "page"
slug: "track-1-core-operations-detailed-curriculum"
published_at: "2026-01-25T19:16:40+00:00"
modified_at: "2026-02-20T16:35:32+00:00"
url: "https://labs.postgreshelp.com/track-1-core-operations-detailed-curriculum/"
markdown_url: "https://labs.postgreshelp.com/track-1-core-operations-detailed-curriculum.md"
excerpt: "TRACK 1 OF 3 Core Operations Hands-On PostgreSQL DBA Training. Production Labs. Real-World Operations from Day 1. 18 Modules 4 […]"
---

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 structureM02**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 transactionsM09**Performance Lab: 6 Index Types** - B-tree, Hash, GiST, GIN, BRIN, partial/expression indexesM10**Query Optimization** - EXPLAIN ANALYZE, plan interpretation, join strategies, planner tuningM11**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 handlingM13**Triggers for Audit & Validation** - BEFORE/AFTER triggers, audit trails, data validationM14**VACUUM, ANALYZE & Bloat** - Autovacuum tuning, bloat detection, maintenance planningM15**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 indexesM17**AI-Powered Banking Chatbot** - OpenAI embeddings, FAQ vectors, RAG pattern, semantic searchM18**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](#enroll)