Certified OCP (Database Admnstrators provide comprehensive administration from installing, maintaining, troubleshooting and fine tuning an oracle database.

Course Benefits:
In this course certification, you will leverage the power of Oracle 9i/10g architecture to build and configure database, control user activity, monitor and optimize database storage, manage large objects; develop robust, high performance, and scalable applications.

This course is designed to fully certify an individual in Oracle9i/10g™. Students will learn about the new features in PL/SQL, the Oracle® features that support SQL9, and all features of the Oracle9i/10g™ database. The students will be provided with course materials, sample tests, and be able to take all tests associated with Oracle9i™ certification.

The tests include:

1Z0-007 -- Oracle9i™PL/SQL
1Z0-031 -- Oracle9i™ Fundamentals I
1Z0-032 -- Oracle9i™ Fundamentals II
1Z0-033 -- Oracle9i™ Tuning

Course Outline:
1: Oracle9i™ PL/SQL (1Z0-007)
- Writing basic SQL SELECT statements
- Restricting and sorting data
- Displaying data from multiple tables
- Outer Joins
- Single Row Functions
- Aggregating data using group functions
- Producing readable output with iSQL*Plus
- Subqueries
- Creating and managing tables
- Altering Table
- Creating Database Objects
- Manipulating Data
- Creating Views
- Controlling user access

2: Oracle9i™ Database Fundamentals I (1Z0-031)
- Basics of the Oracle® Database Architecture
- Oracle® Server Architecture
- Shared Memory Areas
- Universal Installer
- Managing an Oracle® Instance
- Oracle® Managed Files
- Server Side Parameter File
- Oracle® Data Dictionary
- Control Files
- Redo Log Files
- Managing the Physical Database Structure
- Managing Tablespaces and Datafiles
- Temporary Segments
- Storage Structures and Undo Data
- Block Utilization
- Undo Space Management
- Managing Database Objects
- Indexes
- Integrity Constraints
- Managing Database Users
- System Privileges
- Object Privileges
- Roles
- National Language Support

3: Oracle9i™ Database Fundamentals II (1Z0-032)
- Networking Features
- Simple Network
- Network Configurations
- Server Side Configuration
- Client Side Configuration
- Oracle® Net
- Oracle® Names
- Oracle® Net Features
- Listener Configuration
- External Names
- Connection Manager
- Shared Server
- Network Security
- Trouble Shooting the Network.
- Backup and Recovery Features
- Types of Failures
- Instance and Media Failures
- Database Files
- Redo Log Files
- Archivelog Mode
- Recovery Methods
- Hot Backups
- Cold Backups
- Incomplete Recovery
- Complete Recovery
- Oracle® Data Guard
- RMAN Features
- Recovery Catalog
- Logical Backups
- SQL*LOADER
- Flashback Query
- LogMiner Enhancements
- Skipping Redo Log Corruption
- Fast Start Time Recovery
- Block Media Recovery

4: Oracle9i™ Database Tuning: (1Z0-033)
- Tuning Methodology
- Tuning Tools
- Cached Executable Plans
- Dynamic Performance Views
- Statspack
- Analyze Command
- Optimizer Improvements
- SGA Structures
- Sort Operations
- I/O Structures
- Common SQL Parser
- Undo Segments
- Latch Contention
- Application Tuning
- SQL Statement Tuning
- Oracle® Blocks
- Resource Manager
- Bitmap Join Indexes
- Index Skip Scanning
- Cache Fusion Architecture
- HA Features

Oracle8i DBA track and the 1 Oracle9i DBA Upgrade exam:
1. Introduction to Oracle: SQL and PL/SQL
2. Oracle8i: Architecture and Administration
3. Oracle8i: Backup and Recovery
4. Oracle8i: Performance Tuning
5. Oracle8i: Network Administration
6. Oracle9i: New Features for Administrators

Contact us for course outline on +234-1-4926197, 0802-306 1095 or send an e-mail with subject Oracle Training to training@nhames.com

The Oracle Class:
We have put together a solid 7 day each for all oracle 9i modules. However, it could be extended based on individual performance in the test. Nhames aim is to tailor our students on having real hands-on and becoming experts.
 
 
Our Corporate training will give your personnel an edge over all the rest, and also helps them stand out from the crowd. Now you can be number one in your field when it comes to delevering solutions effectively and efficiently.
Attractive discounts on all VUE exams this holiday season and also in January. Give us a call at any time and your call on exams could win you quite good discount on any of the exams you desire.
   
 
We offer all available web solutions and our web development team are one of the best available anywhere. We deploy web solutions for e-commerce, online banking, online dating and a lots more. We have clients from all sectors and industries.
Call our 24-Hour customer care service for enquiries; Call 234-1-8049262, 234-(0)702-8048345, 234-(0)702-8357022.
Or you could just click below to apply online and we will get back to you within the next 12 hours.
Nhames Limited. Copyright (c) 1997 - 2009. All rights reserved.
Ikeja Office: 76, Adeniyi Jones Avenue, Ikeja, Lagos, Nigeria.
Ibadan Office: 2 Lakanmi close , behind Genesis pvt. school, Agodi-gate, Ibadan.

All products and company/corporations names mentioned are the trademarks of their respective owners.