oracle certified professional database administrator training program

Oracle 9i Database Administrator

Oracle Certified Professional Database Administrator

                                               For Corporate Training in this course CLICK HERE

Our Programming Student's Review

Programming Review

1

2

3
4 5

Our Programming Student's Video Review

Oracle Certified Professional Database Administrator

Enquire About This Course

Name :

*Country Name :

e.g.India, UK, ....

Residence / Office Number :

Country Code City Code Number

(Number-Coutry code & city code)
e.g. +91-22-23676218

Mobile Number :

*Email :

*Course Of Interest :

Enquiry :

(*) Signed fields are mandatory.

PAPER I(IZ0-007) : SQL (40 HOURS)

Oracle9i is a Relational Database Management System(RDBMS) with Object Relational Database Management(ORDBMS) futures. Oracle9i is the latest technology, which has many new features over previous versions like 8i and 8. Oracle9i comes with new SQL enhancements.

SALIENT FEATURES

Oracle has sophisticated security mechanisms control access to sensitive data by an assortment of privileges.

Oracle provides sophisticated backup & recovery routines. Backup creates a second copy of Oracle Data, recovery restores a copy of data from back up.

Oracle provides flexible space management. It has special abilities that are capable of handling very large databases.

Oracle provides open connectivity to & from other vendors software.

Oracle server supports a wide range of Development tools, end user query tools, off the shelf applications & office wide information tools.

APPLICATIONS

Education Industry

Software Development Industry

Data warehouse and maintenance

Domestic Air Services

Production Industry

Banking Industry

TOPICS COVERED

Writing Basic SQL Select Statement.

Restricting and Sorting Data.

Displaying Data from Multiple Tables.

Aggregating Data Using Group Functions.

Sub queries.

Producing Readable Output with iSQL*Plus.

Manipulating Data.

Creating and Managing Tables.

Including Constraints.

Creating Views.

Other Database Objects.

Controlling User Access.

SQL Workshop.

Using Set Operators.

Date time Functions.

Enhancements to Group by Clause.

Advanced Sub queries.

Hierarchical Retrieval.

Extensions to DML and DDL Statements.

SQL (Paper I)

TOPICS COVERED

SQL as an extension of SQL

Stored Procedures

Packages

Tools for Creating a Stored Procedures

Visual Database Tools

Oracle Procedure Builder

Error Handling in SQL

Creating Stored Procedures
   (a) SQL Data Types
   (b) Declaring Variables
   (c) Statements and Assignments
   (d) Flow Control Statements
   (e) Loops

Using SQL Statement in SQL

SQL Cursors

User Defines Data Types

SQL Tables and Collections

Cursor Variables

Using Triggers

Course Duration Fees (Indian RS.) Fees (US $)

40 sessions of 1 hr. each 7,000 200

Paper II : DBA I (40 Hours)

Oracle architectural components.

Getting started with oracle server.

Managing Oracle instance.

Creating a database.

Using data dictionary and dynamic performance views.

Maintaining Control File.

Maintaining Redo Log Files

Managing tablespaces & datafiles.

Storage structure and relationship.

Managing Undo Data.

Managing Indexes and tables.

Managing password security and resources.

Managing users .

Managing privileges.

Managing Roles.

Auditing.

Loading data into database.

sing globalization support.

Paper III : DBA II (40 Hours)

Networking Overview.

Oracle Net Architecture

basic Oracle Net Server Side Configuration.

Naming Method Configuration

Usage and Configuration of Oracle 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 Backups

User-Managed Complete Recovery

User-Managed Incomplete Recovery

RMAN Incomplete Recovery

RMAN Maintenance

Recovery Catalog Creation and Maintenance

Transporting Data Between Databases

Paper IV : Performance Tune(40 Hours)

Overview of Oracle 9i Performance Tuning.

Diagnostic and Tuning Tools

Sizing the Shared Pool

Sizing the Buffer Cache

Sizing Other SGA Structures

Database Configuration and I/O Issues

Optimizing Sort Operations

Diagnosing Contention for Latches

Monitoring and Detecting Lock Contention

Tuning the Oracle Shared Server

SQL Statement Tuning

Using Oracle Blocks Efficiently

Application Tuning

Tuning the Operating System and Using Resource Manager

Exam details:

Certification Exam
US $

PAPER I : SQL - 1Z0-007
95

Paper II : DBA I - 1Z0-031
125

Paper III : DBA II - 1Z0-032
125

Paper IV : Performance Tuning - 1Z0-033
125

SQL + DBA I + DBA II + Performance Tuning Paper I To Paper IV

Course Duration Fees (Indian RS.) Fees (US $)

160 sessions of 1 hr. each 33,500 950

Overseas students can complete this course in 1 month if they take
this course 5-8 hours daily.