Keterangan :
------------------------------------------
Oracle 9i DBA [Duration 72 hours]
Prerequisite: SQL
Course Content
------------------------------------------
Day-1
- Introduction to Oracle 9i
- Creating an Oracle Database
- Database Interfaces
Day-2
- Managing Oracle Instance
- Storage Structures
- Data Dictionary and Dynamic Performance Views
Day-3
- Maintaining Control Files
- Maintaining Redo Log Files
- Managing Tablespaces and Datafiles
- Managing Undo Data
Day-4
- Managing Tables
- Managing Indexes
- Managing Constraints
- Managing Users
- Password Management
Day-5
- Managing Privileges
- Managing Roles
- Auditing
- Loading Data into a Database
- Using Globalization Support
Day-6
- Networking Overview
- Oracle Net Architecture
- Net Configuration
Day-7
- Oracle Shared Server
- Backup and Recovery Overview
- Configuring Database Archiving Mode
Day-8
- RMAN Overview and Configuration
- Database Backups
- RMAN Backups
- User Managed Complete Recovery
- RMAN Complete Recovery
Day-9
- User Managed Incomplete Recovery
- RMAN Incomplete Recovery
- RMAN Maintenance
- Export-Import Utility