Week 1
1. Exploring the Oracle Database Architecture
2. Preparing the Database Environment
Week 2
1. Creating an Oracle Database
2. Managing the Oracle Instance
3. Using data dictionary and dynamic performance views
Week 3
1. Managing Database Storage Structures
2. Administering User Security
Week 4
1. Manage database user privileges
2. Managing Schema Objects
Week 5
1. Identify and administer PL/SQL object
2. Managing Data and Concurrency
3. Manage data using DML
4. Explain Oracle locking framework
5. Oracle DML locks
6. Explain Oracle dead locks
7. Monitor and resolve locking conflicts
Week 6
1. Managing Undo Data
Week 7
2. Implementing Oracle Database Security
3. Database Security and Principle of Least Privilege
4. Work with Standard Database Auditing
5. Value based auditing using database triggers
6. Explain Fine Grained Auditing (FGA)
Week 8
1. Configuring the Oracle Network Environment
Week 9
1. Database Maintenance
2. Use and manage optimizer statistics
3. Use and manage Automatic Workload Repository (AWR)
4. Use advisory framework
5. Manage Alerts and Thresholds
6. Performance Management
7. Use Automatic Memory Management
8. Use Memory Advisors
9. Troubleshoot invalid and unusable objects
10. Use the Enterprise Manager Support Workbench
11. Managing Patches
12. Managing Memory
13. Implement Automatic Memory Management
14. Manually configure SGA parameters
15. Configure automatic PGA memory management