Oracle DBA Certified Professional (DBA OCP)
Oracle 9i Database Administrator Certification combines training, experience, and testing to ensure that you have a strong foundation and expertise in Oracle9i Database techniques, including backup and recovery, performance tuning, and administration.
Oracle9i Database provides efficient, reliable and secure data management for high-end applications such as high-volume online transaction processing (OLTP) environments, query-intensive data warehouses, and demanding Internet applications.
Finishing and passing the Oracle Exam for first two modules will lead to an Oracle Certified Associate (OCA) Title
Pre-requisite: Knowledge in Windows and Database Management Systems
Target Audience:
This course is specifically designed for individuals who are interested in acquiring an Oracle DBA Certified Professional certification.
They work as:
- Technical Support
- Oracle database administrators
In:
- IT Consulting Companies
- The IT Department of a company
- The Academe
Modules:
- Introduction to Oracle9i: SQL
- Oracle 9i Database: Fundamentals I
- Oracle 9i Database: Fundamentals II
- Oracle 9i Database: Performance Tuning
General Outline:
- Introduction to Oracle9i: SQL
- Writing Basic SQL Select Statements
- Restricting and Sorting Data
- Displaying Data from Multiple Tables
- Aggregating Data using Group Functions
No. of Hours: 39 Hours
- Oracle 9i Database: Fundamentals I
- Oracle Architectural Components
- Getting Started With the Oracle Server
- Managing an Oracle Instance
- Creating a Database
No. of Hours: 39 Hours
- Oracle 9i Database: 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
No. of Hours: 39 Hours
- Oracle 9i Database: Performance Tuning
- Overview of Oracle9i Performance Tuning
- Describe the roles associated
- Diagnostic and Tuning Tools
- Sizing the Shared Pool
No. of Hours: 39 Hours