• Kemps Corner (H.O) - +91 9820134058

  • Bandra (W) - +91 9322755916

  • Andheri (Lokhandwala) - +91 9820494017

  • Thane (Ghodbunder Rd.) : +91 9808777778

Oracle 9i Database Administrator
Oracle Certified Professional Database Administrator

Compufield's Oracle 9i Database Administrator Oracle Certified Professional Database Administrator in Mumbai aims at providing individuals advanced training in the field of Web designing & Digital Marketing.This course can be taken up by students after 12th, HSc or any such equivalent.Compufield's Oracle 9i Database Administrator Oracle Certified Professional Database Administrator is a professional course and has numerous career options in the It industry.

 

Compufield provides individual based training at our centers, No batches , students can schedule their training as per their time schedule and then mantain the same. This course could take approx one year for completition , however a fast-track option is also avaliable. We also assist with placement options after completion of this Advance Diploma Course in Computer Application.

COURSE
MODULE

PAPER I : 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. 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
After Effects Different from Avid, Final Cut Pro, and Premiere.
 
Application:
Education Industry Software Development Industry Data warehouse and maintenance Domestic Air Services Production Industry
Banking Industry

Paper II - IZ0-031 : DBA I

 
Topics Covered
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

 
Topics Covered
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.

Course Fee

Oracle 9i
Course Duration Course Fees Fees (US $)
120 sessions of 1 hr. each 40,000* $ 830*
* The course fee mentioned above does not include the Examination Fee.
Certification Exam Fee
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
Enquire About The Course