Oracle 10g OCP-DBA Certification
Oracle Certified Professional(OCP)
Database Administrator (DBA)
Why get OCP Certified?
To Demonstrate Skill
- Certifies your DBA skills with a world leading database
- Shows your depth of knowledge
- Demonstrates your Oracle DBA expertise in tuning and troubleshooting
- Proves your ability to keep a corporation's database running reliably and at peak performance
To Enhance Employment Opportunity
- Increases your earning potential
- Opens up careers in one of the hottest job markets
- Shows a measure of professional skill
- Industry now requires certification
- Increases job security
Oracle 10g
Database Administrator Certification Track
This program is designed for anyone interested in a career as an Oracle Database Administrator. The program prepares the student for the Oracle OCP exams. The program consists of three ten week classes.
These classes will provide the student with hands on training and cover the following subject areas:
- Architecture and Installation
- Administration of Oracle
- Tablespace Administration
- Administration of Object Tables and Indexes
- Administration of Table Clusters
- User and Security Administration
- Monitoring Database Tables, Indexes, Clusters and Objects
- Monitoring Users
- Performance Tuning
- Database Internals Tuning
- Distributed Database Management
- Backup and Recovery
Anyone interested in taking this program should have a basic understanding of relational databases. The program will provide an in-depth understanding of the Oracle Server installation, architecture, administration, tuning, backup and recovery. Participants will learn how to tune the database in order to achieve maximum throughput. The program will also cover Distributed Database Management and Parallel Server concepts.
How Do I Get OCP Certified?
For Oracle 10g OCP certification the student must take and pass the following exams given by Oracle:
- Exam 1: 1Z0-042 Oracle Database 10g: Administration I
- Exam 2: 1Z0-043 Oracle Database 10g: Administration II
Please call 978-837-5154 for further information.
ORC 2505 PL/SQL - This lecture/lab course gives students hand-on experience in developing and programming database objects and structures. The students will learn how to store, insert, retrieve, update, manipulate data, and display data in a relational database using procedural language SQL with Oracle9i, the internet-oriented object-relational database. The students will learn Sql*Plus command to communicate with Oracle database more efficiently. The students will learn to create PL/SQL blocks of application code that can be shared by multiple Forms, Reports, and data Management applications. Student will learn to write store procedures and functions, exception handling, cursors, and to create packages (PL/SQL libraries) and triggers. Finally, students will learn how to call Java programs from the database, publish HTML pages using PL/SQL Web Toolkit and PL/SQL Server Pages.
Please call 978-837-5154 for further information.
ON-SITE ORACLE TRAINING
Both Oracle 10g Systems Administration classes and the Oracle 10g SQL/PL/SQL class are available to employers for on-site training.
We can also customize an Oracle training class to suite you particular organizational need.
Please call 978-837-5154 for further information.
Dorothy Zanni
Director, Information Technology Programs
Dorothy.Zanni@merrimack.edu