ORACLE 9i DATABASE PERFORMANCE TUNING



LESSON 1 : Overview of Oracle 9i Database Performance Tuning
LESSON 2 : Diagnostic and Tuning Tools
LESSON 3 : Database Configuration and I/O Issues
LESSON 4 : Tuning the Shared Pool
LESSON 5 : Tuning the Buffer Cache
LESSON 6 : Dynamic Instance Resizing
LESSON 7 : Sizing Other SGA Structures
LESSON 8 : Tuning the Oracle Shared Server
LESSON 9 : Optimizing Sort Operations
LESSON 10 : Using Resource Manager
LESSON 11 : SQL Statement Tuning

ORACLE 9i DBA FUNDAMENTALS-II



LESSON 1 :Networking Overview
LESSON 2 : Oracle Net Architecture
LESSON 3 : Basic Oracle Net Server Side Configuration
LESSON 4 : Naming Method Configuration
LESSON 5 : Usage and Configuration of the Oracle Shared Server
LESSON 6 : Backup and Recovery Overview
LESSON 7 : Instance and Media Recovery Structures
LESSON 8 : Configuring the Database Archiving Mode
LESSON 9 : Oracle Recovery Manager and Configuration
LESSON 10 : User Managed Backups
LESSON 11 : RMAN Backups
LESSON 12 : User-Managed Complete Recovery
LESSON 13 : RMAN Complete Recovery
LESSON 14 : User-Managed Incomplete Recovery
LESSON 15 : RMAN Incomplete Recovery
LESSON 16 : RMAN Maintenance
LESSON 17 : Recovery Catalog Creation and Maintenance
LESSON 18 : Export and Import Utilities

ORACLE 9i DBA FUNDAMENTALS-I



LESSON 1 : Oracle Architectural Components
LESSON 2 : Getting Started with the Oracle Server
LESSON 3 : Managing an Oracle Instance
LESSON 4 : Creating a Database
LESSON 5 : Using Data Dictionary & Dynamic Performance views
LESSON 6 : Managing the Control File
LESSON 7 : Maintaining bOnline Redo Log Files
LESSON 8 : Managing Tablespaces and Data Files
LESSON 9 : Storage Structure and Relationships
LESSON 10 : Managing Undo Data
LESSON 11 : Managing Tables
LESSON 12 : Managing Indexes
LESSON 13 : Maintaining Data Integrity
LESSON 14 : Managing Password Security and Resources
LESSON 15 : Managing Users
LESSON 16 : Managing Privileges
LESSON 17 : Managing Roles
LESSON 18 : Auditing
LESSON 19 : Loading Data into a Database

ORACLE 9I DATABASE TRAINING

Introduction to Oracle 9i SQL

INTRODUCTION:

LESSON 1 : Writing Basic SQL Select Statements

LESSON 2 : Restricting and Sorting Data

LESSON 3 : SQL - Functions

LESSON 4 : Displaying Data From Multiple Tables

LESSON 5 : Group Functions

LESSON 6 : Sub Queries

LESSON 7 : Producing Readable Output with iSQL*Plus
LESSON 8 : Data Manipulation Language (DML)
LESSON 9 : Creating and Managing Tables
LESSON 10 : Table Constraints

LESSON 11 : Creating Views

LESSON 12 : Other Database Objects
LESSON 13 : Controlling User Access
LESSON 14 : Using Set Operators
LESSON 15 : Enhancement to the GROUP BY Clause
LESSON 16 : Advanced Subqueries