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 two 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?
The above program is designed to prepare students for Oracle 9i OCP certification.
To achieve Oracle 9i OCP certification the student must take and pass the following exams given by Oracle:
- Exam 1: 1Z0-007 Introduction to Oracle9i SQL
- Exam 2: 1Z0-031 Oracle 9i Database Fundamental I
- Exam 3: 1Z0-032 Oracle 9i Database Fundamental II
- Exam 4: 1Z0-033 Oracle 9i Database Performance Tuning
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.
- ORC 2550 Oracle 10g - New Features - Attend this one-day workshop to learn about all the new capabilities that exist within the Oracle 10g release.
- Oracle 10g, both Standard Edition and Enterprise Edition with grid capabilities, is now available.
Please call 978-837-5154 for further information.
Instructor Profile
Yazdan Shaghaghi
Mr. Shaghaghi has been teaching Oracle 9i and 10g, Oracle database administration, Java Programming, .Net programming web services, Unix operating system, Advanced database, JavaScript, etc. at Northeastern University. As adjunct faculty at Boston University he also taught various computer science subject matters.
Mr. Shaghaghi is also a skilled project manager and a software engineer with more than 5 years of Java application development and Oracle database development. He gained his experience from working with multi million dollar commercial companies and as a contractor of Department of Defense in Cambridge, Massachusetts.
Mr. Shaghaghi has published various research papers such as Security System Applied to Multicast Networking Application, GPS: A revolution in navigational application, and the future of GPS.
Mr. Shaghaghi is a volunteer with the Association for Computing Machinery (ACM). He has been seminar chair for the Real Time System, and the Aspect-Oriented programming for Java.
Mr. Shaghaghi holds a Master degree in computer science from Boston University and a Master Certificate in Oracle Database Administration.
ON-SITE ORACLE TRAINING
Both the Oracle 9i/10g Systems Administration class and the Oracle 9i & 10g update class are available to employers for on-site training. We can customize the Oracle training to suite you particular organizational need.
Please call 978-837-5154 for further information.
Dorothy Zanni
Director, Information Technology Programs
Dorothy.Zanni@merrimack.edu