Specification :

------------------------------------------
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