Oracle 10g OCP

Oracle 10g OCP

Course Content

Oracle 10g: Introduction to SQL

Introduction
» List the Oracle Database 10g main features
» Provide an overview of: components, internet platform, apps server and developer suite
» Describe relational and object relational database designs
» Review the system development life cycle
» Describe different means of storing data
» Review the relational database concept
» Define the term data models
» Show how multiple tables can be related

Retrieving Data Using the SQL SELECT Statement
Restricting and Sorting Data
Using Single Row Functions to Customize Reports
Reporting Aggregated Data Using the Group Functions
Displaying Data From Multiple Tables
Using Sub queries to Solve Queries
Using the SET Operators
Manipulating Data
Using DDL Statements to Create and Manage Tables
Creating Other Schema Objects
Managing Objects with Data Dictionary Views
Controlling User Access
Manage Schema Objects
Manipulating Large Data Sets
Generating Reports by Grouping Related Data
Managing Data in Different Time Zones
Searching Data Using Advanced Sub queries
Hierarchical Data Retrieval
Performing Regular Expression Support and Case Insensitive

Oracle 10g: Administration I

Introduction (Database Architecture)
» Describe course objectives
» Explore the Oracle 10g database architecture
» Installing the Oracle Database Software
» Explain core DBA tasks and tools
» Plan an Oracle installation
» Use optimal flexible architecture
» Install software with the Oracle Universal Installer (OUI)
» Creating an Oracle Database
» Create a database with the Database Configuration Assistant (DBCA)
» Create a database design template with the DBCA
» Generate database creation scripts with the DBCA
» Managing the Oracle Instance
» Start and stop the Oracle database and components
» Use Enterprise Manager (EM)
» Access a database with SQL*Plus and iSQL*Plus
» Modify database initialization parameters
» Understand the stages of database startup
» View the Alert log
» Use the Data Dictionary

Managing Database Storage Structures
Administering User Security
Managing Schema Objects
Managing Data and Concurrency
Managing Undo Data
Implementing Oracle Database Security
Configuring the Oracle Network Environment
Proactive Maintenance
Performance Management
Backup and Recovery Concepts
Performing Database Backups
Performing Database Recovery
Performing Flashback
Moving Data

Oracle 10g: Administration II

Introduction
» Grid Computing
» Oracle Enterprise Manager 10g Product Controls
» Database Architecture Review

Configuring Recovery Manager
Using Recovery Manager
Oracle Secure Backup
Recovering from Non-critical Losses
Incomplete Recovery
Flashback
Dealing with Database Corruption
Monitoring and Managing Memory
Automatic Performance Management
Monitoring and Managing Storage I
Monitoring and Managing Storage II
Automatic Storage Management
VLDB Support
Managing Resources
Automating Tasks with the Scheduler
Database Security
Data Movement
Using Globalization Support
Workshop

Standard Training Dates

Start Date Time Duration
07/07/2009 6.00-9.00pm 7 Weeks (Tues & Thurs)
25/08/2009 6.00-9.00pm 7 Weeks (Tues & Thurs)
12/09/2009 9.30-3.30pm 7 Weeks (Sat)
13/10/2009 6.00-9.00pm 7 Weeks (Tues & Thurs)
31/10/2009 9.30-3.30pm 7 Weeks (Sat)

Oracle 10g OCP Boot Camp

Candidates will be mentored well before the starting dates and be prepared for the fast track training.

Booking must be made at least one month prior to the starting dates.

Boot Camp Dates

City Dates
Birmingham 20 - 24 July 2009
London 10 - 14 August 2009
London 17 - 21 August 2009
Birmingham 24 - 28 August 2009