Course: Oracle Database Administrator (DBA) Duration: 12 Months

Course-1

Introduction to Oracle 9i SQL

* Database Management Basics
* Restricting and Sorting Data
* Displaying Data from Multiple Tables
* Aggregating Data by using group functions
* Producing Readable output with iSQL*Plus
* Manipulating Data using Data Manipulation Language
* Creating and Managing Tables
* Manipulating Data Using views
* Other Database Objects
* Creating Maintaining and Using Sequences, indexes
* Controlling User access
* Oracle 9i Datetime functions
* Advance Subqueries
* Hierarchical Retrieval
* Oracle 91 Extensions to DML and DDL statements

Course 2

* Oracle 91 Database Administration Fundamentals 1
* Oracle Architectural Components
* Identifying the features of the Universal Installer.
* Defining the Optimal flexible Architecture.
* Creating a Database during installation.
* Identifying Database Administrative users.
* Managing and Oracle Instance.
* Creating a Data Dictionary.
* Using the Data Dictionary.
* Maintaining the Control file.
* Maintaining Redo Log files.
* Describing storage hierarchy.
* Storage structures and Relationships.
* Managing Undo Data.
* Understanding the difference between automatic Undo Management and

Manual Undo Management.

* Managing Tables & Indexes.

Course 3

* Oracle 9i Database Administrations Fundamentals II.
* Oracle Net Architecture.

Oracle Net Services Server & Client side Configuration.

* Usage and Configuration of the Oracle Shared Server.
* Backup and Recovery.
* Instance and Media Recovery Structure.
* Configuration of the Database Archiving Mode.
* Oracle Recovery Manage (RMAN).
* User Manage Backups.
* RMAN Backups.
* User Manage Complete Recovery.
* RMAN Complete Recovery.
* RAMN Repository Maintenance.
* RMAN Catalog Creation and Usage.
* Transporting Data between Database

Course 4

Oracle 9i Database performance Tuning
Oracle 9i  performance Tuning.
Diagnostic and Tuning Tools.
Sizing the Buffer Cache.
Database Configuration and I/O Issues.
Optimize Sort Operation.
Diagnostic Contention for Latches.
Monitoring and Detecting Lock contention.
Tuning Oracle  Shared Server.
Application Tuning.
SQL Statement Tuning.
Tuning the Operating System and Using Resource Manager.