Specification :
---------------------------------------------
Oracle 10g DBA [Duration 64 hours]
Prerequisite: SQL
Course Content
---------------------------------------------
Day-1
- Introduction to Oracle 10g
- Installing Oracle Database 10g Software
- Creating an Oracle Database
Day-2
- Database Interfaces
- Managing Oracle Instance
- Storage Structures
- Administering Users
Day-3
- Managing Schema Objects
- Managing Data
Day-4
- PL/SQL
- Oracle Database Security
Day-5
- Oracle Net Services
- Performance Monitoring
- Proactive Maintenance
- Undo Management
- Monitoring and Resolving Lock Conflicts
Day-6
- Backup and Recovery
- Database Backups
- Database Recovery
Day-7
- Configuring Recovery Manager
- Using Recovery Manager
- Advanced Database Recovery
- Using Globalization Support
- Oracle Listener
Day-8
- Flashback Database
- Recovering from User Errors
- Dealing Database Corruption
- Automatic Management
- Automatic Tasks with the Scheduler