For More Information: Kindly fill the form below with your details to help us get back to you. * Marked fields are required !
	Name*
	Country*
	City*
	Zip / Post Code*
	Phone*
	Mobile No
	Email - Id*
	When do you want to join the training program?
	Other Courses/ Remarks

Oracle 9i DBA Track (160 Hrs)

ORACLE 9i SQL: (40 Hrs)

Introduction to Oracle9i: SQL
Writing Basic SQL Select Statements
Restricting and Sorting Data
Single Row Functions
Displaying Data from Multiple Tables
Aggregating Data Using Group Functions
Subqueries
Producing Readable Output with iSQL*Plus
Manipulating Data
Creating and Managing Tables
Including Constraints
Creating Views
Creating Other Database Objects
Controlling User Access
Using SET Operators
Oracle 9i Date time Functions
Enhancements to the Group By Clause
Advanced Sub-queries
Hierarchical Retrieval
Oracle 9i Extensions to DML and DDL Statements

NOTE: To be offered to Enquiries, who wants to do OCP (DBA).

Fundamental I
Oracle Architectural Components (40 Hrs)
Getting Started with the Oracle Server
Managing an Oracle Instance
Creating a Database
Data Dictionary Contents and Usage
Maintaining the Control File
Maintaining Redo Log Files
Managing Tablespaces and Data Files
Storage Structure and Relationships
Managing Undo Data
Managing Tables
Managing Indexes
Maintaining Data Integrity
Managing Password Security and Resources
Managing Users
Managing Privileges
Managing Roles
Using Globalization Support

OCA completed

Fundamental II

Networking Overview (20 Hrs)

Basic Oracle Net Architecture
Basic Oracle Net Services Server-Side Configuration
Basic Oracle Net Services Client-Side
Usage and Configuration of the Oracle Shared Configuration
Usage and Configuration of the Oracle Shared Server

Backup and Recovery Overview (20 Hrs)

Instance and Media Recovery Structures
Configuration of the Database Archiving Mode
Oracle Recovery Manager (RMAN) Overview and Configuration
User-Managed Backups
RMAN Backups
User-Managed Complete Recovery
User-Managed Incomplete Recovery
RMAN Incomplete Recovery
RMAN Repository Maintenance
RMAN Catalog Creation and Usage
Transporting Data Between Databases

Oracle Performance Tuning Methodology (40 Hrs)

Oracle Alert and Trace Files
STATSPACK UTLBSTAT/UTLESTAT scripts and report.txt
Library cache tuning
Sizing the Buffer Cache
Database Configuration and I/O Issues
Small/Large Block Size Advantages and
Optimize Sort Operations
Introducing Latches
Rollback Tuning
Shared Server Tuning Issues
Index Organized Tables
Explain Plan and Auto Trace