Course in Oracle 9i DBA

In Chennai

Price on request
You can also call the Study Centre
44450... More
Want to speak to an Advisor about this course?
Students that were interested in this course also looked at...
See all

Important information

  • Course
  • Chennai

Important information

Where and when

Starts Location
On request
Vadapalani E-Block C, Basement Doshi Garden No. 174, Arcot Road, (Opp Vadapalani Bus Depot) , 600026, Tamil Nadu, India
See map

Course programme


Writing Basic SQL Statement
Restricting & Sorting Data
Single Row Functions
Displaying Data from Multiple Tables
Aggregating Data using Group Functions
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

Achievements for this centre

Students that were interested in this course also looked at...
See all