dataiotech Labs
12-MODULE MASTER SYLLABUS

Modern DBA Academy Modules

12 comprehensive engineering modules spanning database fundamentals, performance tuning, SRE telemetry, and AI vector data architectures.

MDBA-FUND

1. Database Fundamentals & Storage Engines

Relational engine physics, disk page layout, ACID durability, and MVCC

Core Competencies:
  • ✓ACID principles at disk and WAL/redo log boundary
  • ✓B-Tree index page splits vs. LSM-Tree compaction mechanics
6 Active
View Syllabus
MDBA-PERF

2. Performance Engineering & Tuning

Query execution plans, memory allocation, lock contention, and bloat reduction

Core Competencies:
  • ✓Kernel Page Cache, Dirty Page Flushing, and Checkpoint sizing
  • ✓Autovacuum cost model, table bloat mitigation, and XID wraparound protection
7 Active
View Syllabus
MDBA-RELI

3. Reliability & Disaster Recovery (HA/DR)

Patroni HA, InnoDB Cluster, Always On, replication lag, and verifiable PITR

Core Competencies:
  • ✓PostgreSQL Patroni + etcd + HAProxy zero-downtime automatic failover
  • ✓MySQL InnoDB Cluster + Group Replication + MySQL Router topologies
8 Active
View Syllabus
MDBA-SECU

4. Database Security & Hardening

Authentication, RBAC/ABAC privileges, TDE encryption, and CIS benchmarks

Core Competencies:
  • ✓pg_hba.conf, SCRAM-SHA-256, and mandatory SSL/TLS connection hardening
  • ✓Principle of Least Privilege and dynamic role segregation
2 Active+1 Plan
View Syllabus
MDBA-OBSR

5. Observability & SRE

SLO/SLI targets, wait statistics, telemetry, and metric-to-runbook chains

Core Competencies:
  • ✓SRE Triad: Metric (M#) -> Runbook (R#) -> Script (S#) execution flow
  • ✓SQL Server sys.dm_os_wait_stats and Oracle V$SYSTEM_EVENT wait classification
3 Active+1 Plan
View Syllabus
MDBA-DEVO

6. Database Automation & DevOps

Dynamic configuration engines, automated maintenance, and CI/CD migrations

Core Competencies:
  • ✓Dynamic postgresql.conf and my.cnf parameter generator algorithms
  • ✓Automated index fragmentation and bloat maintenance scripting
1 Active+1 Plan
View Syllabus
MDBA-CLOU

7. Cloud & Platform Engineering

AWS Aurora vs. Patroni, Kubernetes operators, and managed DBaaS trade-offs

Core Competencies:
  • ✓AWS Aurora vs. Self-Hosted Patroni: RPO/RTO, SLA, TCO, and operational control
  • ✓Azure DP-300 and GCP Professional Database Engineer exam master guides
1 Active+1 Plan
View Syllabus
MDBA-DINT

8. Data Integration & CDC

WAL internals, logical replication slots, Debezium, and Kafka streaming

Core Competencies:
  • ✓WAL LSN ordering, Full Page Writes (FPW), and logical decoding plugins
  • ✓Active replication slot lag triage and unbounded WAL growth remediation
2 Active
View Syllabus
MDBA-MDAR

9. Modern Data Architecture

HTAP, distributed SQL consensus, sharding topologies, and polyglot storage

Core Competencies:
  • ✓PostgreSQL 17 vs. MySQL 8.4 LTS enterprise architectural decision matrix
  • ✓MongoDB sharded cluster chunk split failures and balancing bottlenecks
1 Active+1 Plan
View Syllabus
MDBA-AIVC

10. AI & Vector Database Engineering

pgvector HNSW, IVFFlat indexing, RAG memory systems, and vector tuning

Core Competencies:
  • ✓Enterprise RAG architecture blueprint design using PostgreSQL and pgvector
  • ✓HNSW (Hierarchical Navigable Small World) m and ef_search tuning
1 Active+1 Plan
View Syllabus
MDBA-GOVC

11. Data Governance & Compliance

GDPR/KVKK compliance, dynamic data masking, Go-Live, and pre-upgrade checklists

Core Competencies:
  • ✓25-point enterprise production Go-Live checklist management
  • ✓20-point major database upgrade compliance and readiness checks
2 Active
View Syllabus
MDBA-STRT

12. Architecture & Technology Strategy

Version lifecycles, TCO models, engineering career roles, and 90-day roadmap

Core Competencies:
  • ✓Authoritative lifecycle analyses for PostgreSQL, MySQL, SQL Server, and Oracle
  • ✓90-day senior DBA & SRE competency roadmap navigation
5 Active
View Syllabus