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
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.