logo
LAHE
LAHE
 
 
   
     
 
International Students
London academy for Higher Education Fill the application form
London academy for Higher Education Talk to our advisor
London academy for Higher Education Request more info
London academy for Higher Education Intranet
London academy for Higher Education News
 
 
Undergraduate courses
London academy for Higher Education
London academy for Higher Education
London academy for Higher Education
London academy for Higher Education
London academy for Higher Education
London academy for Higher Education
London academy for Higher Education
 
Postgraduate
London academy for Higher Education PgD/MBA Business Administration.
London academy for Higher Education DMS in Strategic Management.
   
 
business
 
 
   
London Academy for Higher Education
 

ORACLE OCP Certification
Oracle Certified Professional

Oracle Course Overview

Our Oracle DBA (Database Administrator) courses will help you become a seasoned OCP (Oracle Certified Professional). This course includes the coursework for the exams one needs to take for the OCP Certification (Oracle Certified Professional) Database Administrator credential. Our Oracle courses are lead by highly qualified instructors who have undergone Oracle training themselves and have years of experience working and consulting in various corporations in London.

Course content  
Writing Basic Oracle SQL Select Statements
Restricting and Sorting Data
Single-Row Functions
Displaying Data from Multiple Tables
Aggregating Data using Group Functions
Using Sub queries
Producing Readable Output with Oracle iSQL*Plus
Manipulating Data
Creating and Managing Tables
Including Constraints
Creating Views in Oracle Database
Creating Other Oracle Database Objects
Controlling User Access

DBA Fundamentals I

Oracle Architectural Components
Getting Started With the Oracle Database Server
Managing an Oracle Database Instances
Creating a Oracle Database
Data Dictionary Content and Usage in Oracle Database
Maintaining the Oracle Control File
Maintaining Redo Log Files in Oracle Database Server
Managing Table spaces and Data files in Oracle Server
Storage Structure and Relationships
Managing Undo Data in Oracle Database
Managing Tables in Oracle Database
Managing Indexes in Oracle Database
Maintaining Data Integrity
Managing Password Security and Resources
Managing Oracle Users
Managing Privileges
Managing Roles
Using Globalization Support in Oracle Database

DBA Fundamentals II

OCP Exam #1Z0-032 is part of oracle OCP courses

Oracle Networking Overview
Basic Oracle Net Architecture
Basic Oracle Net Server-Side Configuration
Basic Oracle Net Services Client-Side Configuration
Usage and Configuration of the Oracle Shared Server
Instance and Media Recovery Structures
Configuring the Database Archiving Mode
User-Managed Backups
RMAN Backups
User-Managed Complete Recovery
RMAN Complete Recovery
User-Managed Incomplete Recovery
RMAN Incomplete Recovery
RMAN Maintenance
Recovery Catalogue Creation and Maintenance
Transporting Data Between Databases
Loading Data into a Database

Oracle Performance Tuning

Overview of Oracle9i Performance Tuning
Diagnostic and Tuning Tools
Sizing the Shared Pool
Sizing the Buffer Cache
Sizing other SGA Structures
Database Configuration and I/O Issues
Optimize Sort Operations
Diagnosing Contention For Latches
Monitoring and Detecting Lock Contention
Tuning Oracle Shared Server
Application Tuning
Using Oracle Blocks Efficiently
SQL Statement Tuning
Tuning the Operating System and Using Resource Manager

Duration

Course Dates and Fees
Contact

Start: July/sep 06
Duration: Three - Six month
Cost: £949
London Academy for Higher Education IT Department
+44 (0) 208 534 9941



 
London Academy for Higher Education
 

"We want you to succeed, and our mission is that you will shine."
The Registrar
----------------------------------------------
Send us your CV, job preference or aspiration, strengths and talents then we will evaluate and advice on the best career path
London Academy for Higher Education
   
 
   
  *According to IT Job Watch as of June 18th, 2008  
Copyright © 2008 London Academy For Higher Education. All Rights Reserved
bac logo abe BCS oracle edexcel edexcel  
LAHE is registered with the Department for Education and Skills (DfES) on its Register of Education and Training Providers at. The Register is a list of education and training providers in England, Wales, Scotland and Northern Ireland. The Register does not quality assure or accredit in any way the learning provision of any registered provider.