Track 1: Foundations — PostgreSQL Production Labs
Track 1 of 4

Foundations
Track

Build a strong foundation in Linux, SQL, PostgreSQL, and database administration through hands-on labs — designed for beginners.

Built for: "I want to get a DBA job and I need to build from the ground up."

Track at a Glance
~42
Total Sessions
6
Linux & OS Prereq Sessions
27
PostgreSQL Core Sessions
7
Career Prep Sessions
Track Investment
₹15,000
EMI available · Live sessions only
Who is this for

This Track is For You If…

🎓 Fresh Graduate or Career Switcher

You want to enter the database engineering field and need to build your fundamentals from scratch — Linux, SQL, and PostgreSQL.

💻 Developer Who Wants to Go Deeper

You write SQL but have never administered a database server. You want to understand what happens underneath.

🔄 Oracle/MySQL DBA Moving to PostgreSQL

You have database experience but need a proper PostgreSQL foundation — installation, architecture, HA, and backup the right way.

📋 Anyone Without Linux Confidence

If you're not comfortable on a Linux terminal, this track starts there. No prior Linux knowledge required.

What You'll Achieve

Outcomes After This Track

Every outcome below is measurable — not a vague "understanding" of topics.

🐧 Linux Confidence

Navigate, manage, and troubleshoot a Linux server. Write shell scripts for backup, monitoring, and automation.

🗄️ SQL & PL/pgSQL Proficiency

Write complex queries, stored procedures, triggers, views, and partitioned table strategies.

🐘 PostgreSQL Administration

Install, configure, secure, and operate PostgreSQL. Perform backups, PITR recovery, and handle user administration.

🔄 Replication & HA

Set up streaming replication with Patroni automatic failover. Configure PgBouncer and Grafana monitoring.

📄 Interview-Ready Portfolio

Optimized LinkedIn, polished GitHub, DBA-ready resume, and mock interviews done before you apply.

💼 Target: First DBA Role

Walk out ready to take on a junior to mid-level DBA position with real hands-on evidence of your skills.

Full Curriculum

Every Session, Listed

~42 sessions. Live delivery. No pre-recorded content.

Phase 1
Linux, Networking & OS Fundamentals
6 sessions · Exclusive to Track 1 — covers what no other track does
01
OS Installation — Ubuntu & OEL (Oracle Enterprise Linux)
Track 1 Only
02
Linux Fundamentals — cp, mv, grep, df, tail, systemctl, wget, dnf, vi
Track 1 Only
03
Networking Fundamentals — IP Addressing, CIDR, Subnets, DNS, Public vs Private Networks
Track 1 Only
04
Database Fundamentals — OLTP vs OLAP, SQL Basics, PL/pgSQL Basics
Track 1 Only
05
Production Environments — DEV, UAT, STAGE, PROD explained
Track 1 Only
06
OS-Level Monitoring Basics — top, ps, OS logs, iostat, vmstat, sar
Track 1 Only
Phase 2
PostgreSQL Core — Architecture, Configuration & Security
Sessions 7–33 · Shared with Track 2 & Track 4
07
Why PostgreSQL — History, MVCC, WAL, Architecture Overview
Shared Core
08
Connection Establishment — The postmaster process
Shared Core
09
ACID Properties — Transactions, isolation, atomicity in depth
Shared Core
10
Installation Part 1 — Source Code, RPM, YUM Installations
Shared Core
11
Installation Part 2 — Extensions, Devel Module
Shared Core
12
Installation Part 3 — PostgreSQL on Ubuntu, EDB, Percona Distribution
Shared Core
13
Architecture — The CRUD Workflow end to end
Shared Core
14
Logger Process — How PostgreSQL logging works
Shared Core
15
Autovacuum Process Part 1 — What it does and why it matters
Shared Core
16
Autovacuum Process Part 2 — Tuning autovacuum parameters
Shared Core
17
Autovacuum Process Part 3 — Bloat detection and remediation
Shared Core
18
Post-Installation Steps — pg_hba.conf, authentication setup
Shared Core
19
Parameter Tuning Part 1 — postgresql.conf memory and performance
Shared Core
20
Parameter Tuning Part 2 — WAL, checkpoint, planner settings
Shared Core
21
psql — Command-line mastery for DBAs
Shared Core
22
Datafiles — Physical structure, data directory layout
Shared Core
23
WAL Files — Write-Ahead Logging internals and management
Shared Core
24
User Administration Part 1 — Roles, users, privileges
Shared Core
25
User Administration Part 2 — RBAC, row-level security
Shared Core
26
Logical Backups — pg_dump, pg_dumpall, restore strategies
Shared Core
27
Backup and Recovery Part 1 — pg_basebackup, WAL archiving
Shared Core
28
Backup and Recovery Part 2 — Point-in-Time Recovery (PITR) hands-on
Shared Core
29
Replication Part 1 — Streaming replication setup (sync vs async)
Shared Core
30
Replication Part 2 — Monitoring and troubleshooting replication
Shared Core
31
PgPool-II & PgBouncer — Connection pooling and load balancing
Shared Core
32
Patroni — Automatic failover and HA cluster setup
Shared Core
33
Grafana — Monitoring dashboards for PostgreSQL
Shared Core
Phase 3
Advanced Maintenance & Upgrades
2 sessions shared with Track 2 & Track 4
34
Upgradation and Logical Replication — pg_upgrade, major version upgrades
Shared Core
35
PT: pgBadger — Log analysis and query performance reporting
Shared Core
Phase 4
Career Preparation
7 sessions · Exclusive to Track 1 — job-readiness focus
36
LinkedIn Optimization — DBA-specific profile building and visibility
Career Prep
37
GitHub Profile Optimization — Showcasing your labs and scripts
Career Prep
38
Resume Optimization — DBA resume that gets interviews
Career Prep
39
Mock Interviews — Live technical interview practice
Career Prep
40
Weekly Real-Time Assignments — Recurring practical assignments
Career Prep
41
Knowledge Sharing Sessions (KSS) — Present and teach to solidify learning
Career Prep
42
Documentation Review — RFP, SOP, Escalation Matrix real-world docs
Career Prep
Investment

Enrol in Track 1: Foundations

₹15,000
≈ $180 USD
  • ~42 live sessions — no pre-recorded content
  • 6 Linux & OS foundation sessions (unique to this track)
  • Full PostgreSQL core: architecture through HA and Grafana
  • Career prep: LinkedIn, GitHub, Resume, Mock Interviews
  • Weekly assignments and Knowledge Sharing Sessions
  • Access to session recordings for revision
💳 EMI available: 2 × ₹7,500
Enquire & Enrol in Track 1
How Tracks Compare

Track 1 vs The Others

See exactly what's different before you decide.

What's Covered Track 1
Foundations		 Track 2
Production Engg		 Track 4
Prof Branding
Linux, Networking & OS Fundamentals✓——
SQL & PL/pgSQL Fundamentals✓——
PostgreSQL Core (Sessions 7–33)✓✓✓
AWS RDS, Aurora & Cloud—✓—
Performance Engineering & Tuning—✓✓
LinkedIn, Resume & Career Prep✓—✓
MVCC/WAL Internals & Case Studies——✓
Price₹15,000₹20,000₹25,000
Scroll to Top