01Database & SQL Foundations
- Relational concepts and normalisation
- SQL: queries, joins, subqueries, analytics
- PL/SQL fundamentals
- Data modelling basics
02Oracle Architecture
- Instance and database structure
- Memory: SGA and PGA
- Background processes
- Storage structures and tablespaces
03Core Administration
- Installation and database creation
- User, role and privilege management
- Managing tablespaces and datafiles
- Startup/shutdown and initialisation parameters
04Backup & Recovery
- Backup strategies
- RMAN: full, incremental, archived-log backups
- Complete and point-in-time recovery
- Recovery scenarios and drills
05Performance Tuning
- AWR, ADDM and ASH reports
- SQL tuning and execution plans
- Indexing strategies
- Memory and I/O tuning
06High Availability
- Data Guard: physical standby setup and switchover
- RAC concepts and architecture
- ASM storage management
- Patching and upgrades
07Linux for DBAs
- Essential Linux commands
- Shell scripting for automation
- Cron scheduling
- Storage and OS-level troubleshooting
08Cloud Databases
- Oracle on OCI: Base DB and Autonomous
- AWS RDS for Oracle overview
- Cloud migration methods
- Hybrid architectures
09Production Operations
- Real ticket scenarios from remote DBA practice
- Incident handling and escalation
- Documentation and runbooks
- On-call practices
10Capstone: Live Project
- Build, secure, back up and tune a production-style database
- Simulated failure-and-recovery exercise
- Interview preparation on your project
- Mock interviews with industry experts