Database Administration
Program Code: DBADM
Short Course
8 weeks
Hybrid
Oracle
Program Overview
Master SQL, database design, backup and recovery, performance tuning, and database security. This online course requires a strong internet connection and a laptop.
Curriculum & Modules
Week 1: Database Concepts
- DBMS
- RDBMS
- Data Models
- Normalization
Week 2: SQL Fundamentals
- SELECT
- INSERT
- UPDATE
- DELETE
- JOINs
Week 3: Database Design
- ER Diagrams
- Schema Design
- Indexes
- Constraints
Week 4: Stored Procedures
- Procedures
- Functions
- Triggers
- Views
Week 5: Database Security
- User Management
- Roles
- Permissions
- Encryption
Week 6: Backup & Recovery
- Full Backup
- Incremental
- Point-in-Time Recovery
Week 7: Performance Optimization
- Query Tuning
- Index Optimization
- Monitoring
Week 8: Database Administration Project
- Deploy and manage a production database
Entry Requirements
Strong internet connection and a laptop are required as this is an online course.
