Oracle DBA

Oracle DBA

Over the past few years, Data Warehousing, Data Mining and Database Management have evolved into a fully developed branch of the software industry. Oracle is one of the foremost organizations pioneering such technologies. The Oracle Certified Professional (OCP) Program is designed to equip a candidate with skills specific to such applications. An Oracle Certification from Oracle Corporation, USA is a valuable, industry recognized credential that signifies a proven level of knowledge and ability.

What will you learn?

The expertise of Oracle database administrators( DBAs) is integral to the success of today's increasingly complex system environments. The best DBAs operate primarily behind the scenes. They are on watch for ways to fine tune day-to-day performances and to prevent unscheduled crises, such as a crashed database or hours of expensive downtime. This critical work requires a broad understanding of the architecture and processes of the Oracle database, as well as plenty of hands - on experience solving problems. The best DBAs know they stand between optimal performance and an event that could bring their company to a standstill. The Oracle 8i Certified Database Administrator Track is a certification path that results in the award of a credential to proven performers in the role of database administrator. The track consists of five tests designed so you can translate your knowledge and skills into a tangible, well-recognized professional certification.

Topic of Course

1Z0-007 Introduction to Oracle 9i: SQL Introduction

-Writing Basic SQL SELECT Statements
-Restricting and Sorting Data
-Single-Row Functions
-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
-Creating Other Database Objects
-Controlling User Access

1Z0-031 Oracle 9i Administration Fundamentals - I

-Oracle Architectural Components
-Getting Started with the Oracle Server
-Managing an Oracle Instance
-Creating a Database
-Data Dictionary Content and Usage
-Maintaining the Control File
-Maintaining the Redo Log Files
-Managing Tablespaces and Data Files
-Storage Structure and Relationships
-Managing Undo Data
-Managing Tables
-Managing Indexes
-Maintaining Data Integrity
-Managing Password Security and Resources
-Managing Users
-Managing Privileges
-Managing Roles
-Using Globalization Support

1Z0-032 Oracle 9i Administration Fundamentals - II

-Networking Overview
-Basic Oracle Net Architecture
-Basic Net Server-Side Configuration
-Basic Oracle Net Services Client-Side Configuration
-Usage and Configuration of the 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
-RMAN Complete Recovery
-User-Managed Incomplete Recovery
-RMAN Incomplete Recovery
-RMAN Maintenance
-Recovery Catalog Creation and Maintenance
-Transporting Data between Databases
-Loading Data into a Database

1Z0-033 9i Performance Tuning

-Overview of Oracle9i Performance Tuning
-Diagnostic and Tuning Tools
-Sizing the Shared Pool
-Sizing the Buffer Cache
-Sizing other System Global Area (SGA) Structures
-Database Configuration and I/O Issues
-Optimize Sort Operations
-Diagnosing Contention for Latches
-Tuning Rollback (or UNDO) Segments
-Monitoring and Detecting Lock Contention
-Tuning Oracle Shared Server
-Application Tuning
-Using Oracle Blocks Efficiently
-SQL Statement Tuning
-Tuning the Operating System and using Resource We have two time batches for Oracle 7:30 AM & 7:30 PM, Two hours every day Monday to Friday. 2 and 1/2 Month is Duration of Course.