 O racle Database 10G OCP Certification
 During our 9 day Oracle Database 10g Administrator Certification combines training, experience, and testing to ensure that you have a strong foundation and expertise in the industry’s most advanced database management system.
To achieve OCP™ certification, candidates are required to attend one instructor led training course from Oracle. See the Oracle University website for more information.
Prerequisites
To participate in this class, you should have 1 year or more in Oracle and SQL database administration in an enterprise environment.
Our Oracle Database 10g Administrator Certification Program includes:
- Intensive Hands-on Training Utilizing our (Lecture | Lab | Review)™ Delivery
- Comprehensive Study Materials and Pre-Class Mentoring, Program Courseware, and Self-Testing Software
- Deluxe Package of Nine (9) Days of Hotel Accommodations, Breakfast and Lunch, Unlimited Beverages, Snacks, and Freshly-brewed Coffee
- 24-Hour Lab and Instructor Access
- Examination Voucher & On-site Certification Testing
- Examination Passing Policy
Oracle OCP Schedule of Classes - 2010
1/11/2010 1/19/2010 Orlando, FL
2/8/2010 2/16/2010 Bushkill, PA
3/22/2010 3/30/2010 Washington, D.C. Metro
4/19/2010 4/27/2010 Los Angeles Metro
5/17/2010 5/25/2010 Chicago, IL
6/14/2010 6/22/2010 Bushkill, PA
7/19/2010 7/27/2010 San Francisco, CA
8/23/2010 8/31/2010 Bushkill, PA
9/20/2010 9/28/2010 Dallas, TX
10/18/2010 10/26/2010 Orlando, FL
11/15/2010 11/23/2010 Atlanta, GA
12/6/2010 12/14/2010 Bushkill, PA
Course Outline
Day 1
Retrieving Data Using the SQL SELECT Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Using Conversion Functions and Conditional Expressions
Reporting Aggregated Data Using the Group Functions
Displaying Data from Multiple Tables
Using Subqueries to Solve Queries
Using the Set Operators
Day 2
Manipulating Data Using DDL Statements to Create and Manage Tables
Creating Other Schema Objects
Practical Exercises
Exam number: 1Z0-0511 SQL Fundamentals I
Day 3
Basic Oracle Concepts
Installing Oracle Database 10g
Creating an Oracle Database
Interfacing with the Oracle Database
Managing Oracle Processes
Managing Oracle Storage Structures
Day 4
Administering Users
Managing Database Objects
Manipulating Database Data
Programming Oracle with PL/SQL
Securing the Database
Configuring Oracle Networking
Managing Shared Servers
Day 5 Managing Database Performance
Monitoring Oracle
Managing Undo
Dealing with Locking
Configuring the Database for Backup and Recovery
Backing Up Oracle Databases
Recovering Oracle Databases
Recovering from User Errors
Tools for Oracle Database 10g Tuning
Day 6 Managing Globalization in Oracle Databases
Configuring Security for the Listener
Day 7 Practical Exercises
Exam 1Z0-042 Oracle 10g Administration I
Getting Started with Oracle Recovery Manager (RMAN)
Using RMAN to Back Up Oracle Databases
Diagnosing Oracle Database Issues
Recovering from Noncritical Losses
Incomplete Database Recovery
Using Flashback Database
Day 8 Detecting and Recovering from Database Corruption
Monitoring and Managing Storage
Managing Storage with Automatic Storage Management
Monitoring and Managing Memory
Managing Oracle Database Resources
Day 9 Automating Administrative Tasks
Practical Exercises
Exam 1Z0-043 Oracle 10g Administration II
|
