Oracle 9i Database Administrator
Oracle Certified Professional Database Administrator
|
|
~ |
PAPER I : SQL |
|
~ |
PAPER II : DBA I |
|
~ |
PAPER III : DBA II |
|
~ |
PAPER IV : Performance Tuning |
|
|
|
|
Paper I - IZ0-007 : SQL |
|
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. |
|
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. |
|
Application |
|
~
~
~
~
~
~ |
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. |
|
Paper II - IZ0-031 : DBA I |
|
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~ |
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 - IZ0-032 : DBA II |
|
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~ |
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 - IZ0-033 : Performance Tuning |
|
~
~
~
~
~
~
~
~
~
~
~
~
~
~ |
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 |
|
Certification Exam Fees |
|
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(IZ0-007) + DBA I(IZ0-031) + DBA II(IZ0-032) + Performance Tuning
(IZ0-033) Paper I To Paper IV |
|
Course Duration |
Fees (Indian RS.) |
Fees (US $) |
120 sessions of 1 hr. each |
25,000* |
715* |
|
|
* The course fee mentioned above does not include the Examination Fee. |
|
|
|