Duration 5 days – 35 hrs
Overview
This training provides a practical foundation in database administration and management, covering the essential responsibilities of a DBA—from installation and configuration to user access control, backup and recovery, performance tuning, monitoring, and basic troubleshooting. Participants will learn how to manage databases reliably in both on-premise and cloud environments while applying industry best practices for security, availability, and operational stability.
Objectives
- Understand DBA roles, database architecture, and key operational responsibilities
- Install and configure a database environment using best practices
- Create and manage users, roles, permissions, and database security controls
- Perform routine DBA tasks including maintenance, monitoring, and housekeeping
- Implement reliable backup and recovery strategies (including disaster recovery basics)
- Optimize performance using indexing, query tuning, and resource monitoring
- Troubleshoot common database issues (locks, slow queries, storage, errors)
- Apply operational discipline using documentation, checklists, and standard procedures
Target Audience
- Junior / Aspiring Database Administrators (DBAs)
- System Administrators managing database servers
- Application Support / Production Support Engineers
- DevOps / SRE Engineers handling database operations
- Backend Developers supporting database performance & availability
- IT Operations Teams (Infra / Monitoring / Service Management)
Prerequisites
- Basic understanding of databases and SQL (SELECT, JOIN, WHERE, GROUP BY)
- Familiarity with OS concepts (Windows/Linux basics)
- Basic networking knowledge (ports, connectivity, firewall concepts)
- Optional (recommended): prior exposure to any DB platform (MySQL, PostgreSQL, SQL Server, Oracle)
Course Outline
Day 1 — DBA Foundations & Database Architecture
- DBA responsibilities and operational lifecycle
- Database types: RDBMS vs NoSQL (high-level comparison)
- Core architecture concepts: storage, memory, processes, logs
- Database objects overview: schema, tables, indexes, views
- Environments: Dev / QA / UAT / Production
- Hands-on: exploring database structure and metadata
Day 2 — Installation, Configuration & Database Administration Basics
- Database server setup checklist (best practices)
- Configuration fundamentals (memory, storage, connections)
- Database creation, schemas, tablespaces/filegroups (conceptual)
- Managing services, startup, and basic instance settings
- Tools overview: CLI vs GUI admin tools
- Hands-on: create DB, configure settings, create schemas/objects
Day 3 — User Management, Security, and Access Control
- Authentication vs authorization concepts
- Users, roles, privileges, and least-privilege design
- Password policies and account governance
- Auditing basics: tracking users and database activity
- Security best practices (encryption overview, masking concepts)
- Hands-on: user provisioning + role-based access setup
Day 4 — Backup, Recovery & Business Continuity
- Backup types: full, incremental/differential, transaction logs (conceptual)
- Recovery models and restore strategies
- RPO / RTO fundamentals (what business expects)
- Restore validation and testing (restore drills)
- Introduction to replication, clustering, and HA concepts
- Hands-on: backup and restore scenarios + failure simulation
Day 5 — Monitoring, Performance Tuning & Troubleshooting
- Performance bottlenecks: CPU, memory, I/O, locks, poor indexing
- Indexing fundamentals and execution plan concepts
- Query tuning workflow (identify → analyze → optimize)
- Monitoring and alerting (KPIs and thresholds)
- Routine DBA maintenance tasks & scheduling
- Troubleshooting guide: slow queries, deadlocks, disk full, connection issues
- Hands-on: tuning exercises + incident response mini-lab
