Cloud & DevOps · Specialist
Database Administration
Protect the data. Restore with confidence. Tune using evidence.
Operate secure, recoverable and high-performing databases under production pressure.
Advanced layer includedIndustry Edge tools and scenario-based labs beyond the recognized core. Curriculum v1.1 • Updated Jul 2026
Recognized curriculum, prerequisites, assessments, and public fees disclosed before counselling.
Industry Edge Lab includedAdvanced tools, emerging patterns, and scenario-based labs beyond the recognized core.Registration and admissions follow-up continue securely in BharatCampus ONE.
Included beyond the published curriculum
The recognized core is your foundation—not the finish line.
Every Database Administration cohort also enters the CohortAI Industry Edge Lab: an evolving layer of advanced tool categories, emerging architecture and production patterns, and scenario-based labs. A guided counselling preview connects the most relevant capabilities to your target role, followed by a release-governed lab sequence after enrollment.
Release-governed advanced tools Emerging architecture patterns Scenario-based labs
Fit before enrollment
Who should join
Graduates, support engineers and developers targeting database administration or production-support roles.
Role pathways
Your starting point
Basic computer usage and logical thinking. Linux and SQL foundations are included.
This is not an exclusion filter. It helps us confirm whether you can start directly or would benefit from a short bridge before the cohort.Recognized core
Skills and technology stack
These employability foundations are part of the public learning promise and remain visible before registration.
PostgreSQL SQL Linux MySQL/SQL Server comparison Backup and restore Monitoring Replication Security
Build-first curriculum journey
7 missions. One defensible portfolio.
Mentor-led hybrid learning with 1.5-hour live instruction, all-day supervised practice access, weekly build evidence and a version-locked capstone.
M012 weeks · 15 live hours
Relational model and SQL foundation
Data Integrity Challenge: make invalid business states impossible.
- Tables, keys, constraints and relationships
- DDL and DML
- Joins, subqueries and CTEs
- Transactions and isolation basics
Guided labDesign and implement a transactional schema with constraints, queries and test data.
Portfolio evidenceSchema diagram, SQL build script and query validation pack.
AssessmentSQL practical and data-integrity review.
M021 week · 7.5 live hours
Database architecture, installation and configuration
Cold Start Drill: recover a working database service from an empty host.
- Database processes, memory and storage architecture
- Installation and initialisation
- Configuration files and parameters
- Tablespaces/storage layout
Guided labInstall and configure isolated database instances for development and production-like workloads.
Portfolio evidenceInstallation runbook, baseline configuration and architecture diagram.
AssessmentBuild-from-scratch administration practical.
M031 week · 7.5 live hours
Security, users and permissions
Privilege Puzzle: satisfy business access without giving anyone superuser rights.
- Authentication and connection rules
- Roles, privileges and ownership
- Least privilege and separation of duties
- Encryption in transit and at rest concepts
Guided labImplement role-based access for application, analyst, DBA and auditor personas.
Portfolio evidenceAccess-control matrix, SQL grants and audit evidence.
AssessmentPrivilege-escalation review and security viva.
M042 weeks · 15 live hours
Backup, restore and disaster recovery
Restore Under Pressure: recover the right data, not simply a running server.
- Logical and physical backup
- WAL/log concepts and point-in-time recovery
- Retention and backup validation
- Restore drills and RTO/RPO
Guided labPerform full, incremental/log-based and point-in-time recovery drills against data-loss scenarios.
Portfolio evidenceTested recovery runbook, evidence pack and RTO/RPO report.
AssessmentTimed restore practical and failure postmortem.
M052 weeks · 15 live hours
Indexing, query and performance tuning
Performance Clinic: improve latency without hiding the root cause with hardware.
- Execution plans and cost concepts
- B-tree and specialised index fundamentals
- Statistics and cardinality
- Slow-query identification
Guided labDiagnose and tune a deliberately slow workload using plans, metrics and controlled changes.
Portfolio evidencePerformance report with baseline, intervention and measured result.
AssessmentQuery-plan interpretation and tuning demonstration.
M061 week · 7.5 live hours
High availability and replication
Zero-Surprise Failover: preserve integrity while changing leadership.
- Physical and logical replication
- Primary/standby operations
- Synchronous versus asynchronous trade-offs
- Failover, switchover and split-brain risks
Guided labBuild a primary/standby topology, simulate failure and execute a controlled failover.
Portfolio evidenceHA architecture, failover runbook and replication-monitoring dashboard.
AssessmentFailover simulation and recovery review.
M071 week · 7.5 live hours
Administration capstone
Database War Room: diagnose, restore, tune and explain under a fixed incident clock.
- Environment build and security baseline
- Backup/restore validation
- Performance incident investigation
- Replication and failover
Guided labOperate a production-style database environment through failure, recovery and performance scenarios.
Portfolio evidenceAdministration portfolio, runbooks, monitoring views and incident postmortem.
AssessmentOperations review board and DBA interview simulation.
The week feels different here
A repeatable rhythm from concept to evidence
Weekly rhythm
- 1Concept sprint and visual roadmap
- 2Guided implementation lab
- 3Independent build challenge
- 4Debug, review and production-pattern clinic
- 5Skill check, demo and learning reflection
Learner experience
CohortAI Skill Passport with milestone badges
Build-first weekly checkpoints rather than lecture-only completion
Peer demo and code/design review rituals
Mentor office hours and all-day practice-lab access
Capstone Demo Day with a business narrative, technical walkthrough and interview-style defence
Responsible AI-assisted learning policy: explain, verify and own every submitted artifact
Interview-ready proof
What you will be able to show—not merely claim
These are tangible outputs you can demonstrate, explain, and defend through a technical walkthrough, business narrative, or interview conversation.
Configured secure database environment
Tested backup, point-in-time recovery and disaster-recovery runbook
Performance diagnosis and tuning case
High-availability administration capstone
Transparent evaluation
How your progress is assessed
Completion standard
Minimum 70% overall, mandatory capstone pass, at least 80% lab submissions and versioned portfolio evidence.
CohortAI Industry Edge Lab
Your published curriculum is the foundation. The Industry Edge is what keeps it moving forward.
The Modern Database Operations Lab explores performance, vector search, automation and high-availability patterns through production-style scenarios.
Your counselling preview connects relevant capability categories to your target role. The complete release-governed lab sequence becomes part of the enrolled learning plan.Version-controlled learning promise
DBA@1.1.0
Released 24 July 2026 under catalog CAT-2026.09.1. This page presents the approved curriculum, learner outcomes, duration, and public fee for informed comparison.
Straight answers
Frequently asked questions
Who is the Database Administration program designed for?
Graduates, support engineers and developers targeting database administration or production-support roles.
What prerequisites do I need?
Basic computer usage and logical thinking. Linux and SQL foundations are included.
What is included in the public curriculum?
The public curriculum includes the recognized stack, all 7 module themes, guided labs, portfolio artifacts, assessment model, duration, and public fees. The Industry Edge Preview explains how advanced capability categories extend this foundation for your target role.
Where do counselling and enrollment happen?
CohortAI supports public discovery and program comparison. Registration, consent, counselling follow-up, application updates, and enrollment are managed securely in BharatCampus ONE.