Course in Oracle 9i DBA
Course
In Chennai
Price on request
Description
-
Type
Course
-
Location
Chennai
Facilities
Location
Start date
Chennai
(Tamil Nādu)
See map
Vadapalani E-Block C, Basement Doshi Garden No. 174, Arcot Road, (Opp Vadapalani Bus Depot) , 600026
Start date
On request
Reviews
Have you taken this course?
Course programme
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
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
Course in Oracle 9i DBA
Price on request