You are here: Home - Courses - Oracle Certified Professional   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 Start: July/sep 06 Duration: Three - Six month Cost: £949 Contact London Academy for Higher Education IT Department +44 (0) 208 534 9941 info@lahe.org.uk