Oracle OCP-DBA Training

Oracle Certified Professional(OCA/OCP)

Database Administrator (DBA)

Why get OCA/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 11g

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 OCA/OCP Certified?

For Oracle 11g OCA certification the student must take and pass the following two exams given by Oracle:

• Exam 1: 1Z0-051 Oracle Database 11g: SQL Fundamentals
• Exam 2: 1Z0-052 Oracle Database 11g: Administration I

For Oracle 11g OCP certification the student must also pass the following exam:

• Exam 3: 1Z0-053 Oracle Database 11g: Administration II

For Oracle 10g OCA/OCP certification the student must take and pass three exans the:  1Z0-041, 1Z0-042, and 1Z0-043

The four classes listed below are offered for Oracle training.

Please call 978-837-5154 for further information.

ORC 2505 Oracle 11g SQL Programming with an introduction to PL/SQL

 

This lecture/lab course gives students hands-on experience in developing and programming database objects and structures. The course focuses on ANSII/ISO standard SQL with Oracle specific extensions. The students will learn how to create tables and other relational objects. They will learn how to add, edit, manipulate and report data.  Instruction lectures, demonstrations and labs will use the Oracle SQL*Plus interface to access and control  the database.

The course will provide a good foundation for students who wish to prepare for the Oracle Certified Professional (OCP) certification examination.

In addition to SQL, the course will provide an introduction to PL/SQL, Oracle's procedural language.

Block structures, procedures, functions, packages and triggers will be covered.

 

Oracle 2507 Oracle 11g PL/SQL

 

PL/SQL is Oracle’s procedure language that extends the functionality of ANSII standard SQL.

It is a well structured strongly typed language that supports relational database concepts and includes many features of object databases.  SQL is embedded and tightly linked to optimize performance.  The course covers block structures, functions, procedures and packages.  DML, view and event triggers are covered with many examples.  User defined record, array and nested table types are included.  Nested procedures and pipelined functions are covered. Some of the Oracle supplied PL/SQL packages like DBSM_OUTPUT, UTL_FILE, DBMS_RANDOM and DBMS_UTILITY are covered.

  

  ORC 2510 Oracle System Administration I

 

This course will cover Oracle 11g features. This course is the first step toward success as an Oracle professional, designed to give students a firm foundation in basic Oracle database administrative tasks. This class presents an in-depth coverage on Oracle internal structures, the database administrative tools, user management, and management of database logical and physical layouts. Students are also introduced to networking concepts and configuration parameters, as well as how to solve some common network problems. Includes a review of SQL and some advanced SQL concepts including SQL tuning.

 

 

  Oracle 2520 Oracle 11g Advanced System Administration II

This course will cover Oracle 11g features. Students will develop abilities to manage the industry’s most advanced information system. This course teaches the Oracle database administrator (DBA) to perform backup and recovery operations, to tune performance and to control resource utilization. This course addresses manual backup and recovery techniques as well as the use of Oracle Recovery Manager RMAN. It examines various backup, failure, restore and recovery scenarios. The students gain the necessary knowledge and skills to effectively tune SQL against the Oracle 11g Server. Students gain a conceptual understanding of the Oracle 11g/10g Ruled-Based and Cost-Based Optimizers, and reinforce instructor-led learning with structured hands-on practices. The students learn to use the Oracle diagnostic tools and facilities; EXPLAIN, SQL Trace, TKPROF and SQL*Plus AUTROTRACE. In addition, the participants learn to influence the behavior of the Optimizer by changing the physical schema and modifying SQL statement syntax. The use of flashback database tools is covered.  Automatic Storage Management is introduced.  Globalization techniques are covered.

Please call 978-837-5154 for further information.

ON-SITE ORACLE TRAINING

Both  Oracle 11g/10g Systems Administration classes and the Oracle 11g/10g SQL/PL/SQL class are available to employers for on-site training.
We can also customize an Oracle training class to suit your particular organizational need.

Please call 978-837-5154 for further information.

Dorothy Zanni
Director, IT & Industry Programs
Dorothy.Zanni@merrimack.edu