Course in Oracle 9i DBA

SQL:

Introduction
Writing Basic SQL Statement
Restricting & Sorting Data
Single Row Functions
Displaying Data from Multiple Tables
Aggregating Data using Group Functions
Sub_Queries
Producing Readable Output with iSQL* plus
Mainpulating Data
Creating and Managing Tables
Oracle 9i Extensions to DML and DDL statements

DBA Fundamental - I :

Oracle Architectural Components
Getting started with Oracle Server
Managing an Oracle Instance, Creating a Database
Data ictionary Contents and Usage
Maintaining the Control File,Redo Log Files
Managing Tablespaces and Data Files
Storage Structures and Relationships
Managing Undo Data, Tables, Indexes
Maintaining Data Integrity,Managing Password
Loading Data into a Database & Globalization Support

DBA Fundamental - II

Basic Oracle Net Architechture , Server- side configuration
Basic Oracle Net Services Clinet - side Configuration
Usage and Configuration of the Orcle shared server
Backup and Recovery Overview
Instance and Media Recovery structures
Configuring the Database Archiving Mode
Oracle Recovery Manager Overview and Configuration
User managed backups,RMAN backup
User managed complete & Incomplete Recovery
RMAN Complete Recovery, Incomplete Recovery&Maintenance
Recovery Catalog Creation and Maintenance
Transporting Data between Databases

Performance Tuning :

Overview of Oracle9i Performance Tuning
Diagnostic and Tuning Tools
Sizing the other SGA Structures
Sizing the Shared Pool & the Buffer Cache
Database Configuration and I/O Issues
Monitoring and Detecting Lock Contention
Application Tuning, Using Oracle Blocks efficiently
SQL Statement Tuning , Tuning the OS and Using Resource manager
Optimizing Sort Poerations
Tuning Rollback Segments