Oracle DBA Database Administrator course for beginners by MITTI

Part I: VMware Workstation
Introduction
Installing VMware Workstation
Creating Virtual Machine
Installing OS in Virtual Machine
Managing Virtual Machine

[Note] For Oracle we need multiple systems for practicing Backup Restoration and Cloning. Since arranging multiple physical systems with complete network and KVM connectivity is out of scope well create virtual machines with VMware.

Part II: Oracle
1. Introduction to DBMS and RDBMS
2. Brief History of Oracle
3. Oracle Architecture
4. Oracle Installation
5. Optimal Flexible Architecture
6. SQL Query/Statement types
7. Oracle Administration
- SQL Queries and Parameters
- Creating database with DBCA
- Creating database manually
- Enabling/Disabling Archive logs
- Creating Pfile and SPfile
- Adding Control file
- Adding Redo log file
- Adding Tablespace
- Adding Temporary Tablespace
- Adding Datafile
- Creating Table and adding Records
- User Authorization
8. Oracle Net Listener
9. Advance Oracle Administration
- Changing Archived logs destination
- Increasing number of Processes and Sessions
- Changing Redo logs file size
- Changing Database SID
10. Backup and Restore
- Offline (Cold) Backup
- Online (Hot) Backup
- Restore and Recovery
11. Database Cloning and Disaster Recovery
12. RMAN (Recovery Manager)
- Configuring Recovery Catalog Database
- RMAN Parameters
- Offline and Online Backup
- Restore and Recovery
- Disaster Recovery
13. Enterprise Manager (EM)
14. Troubleshooting