Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 







Oracle SQL & PL/SQL OCP Preparation Training Course

A five day on-site Oracle Certified Professional SQL & PL/SQL class
Test 1Z0-007

© 2007-2016 by Burleson Corporation

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices



Key Features

* Understand SQL & PL/SQL Features.

* See SQL structures.

* Understand PLSQL structures.

* Employ PLSQL Programming.

* Learn Advanced SQL & PL/SQL concepts.



Course Description

exercises are used to demonstrate each feature and the student will gain first-hand experience in the key Oracle SQL & PL/SQL concepts required to pass the Oracle OCP exam.  In addition, this course provides sample OCP exam questions and an opportunity to access your overall knowledge of Oracle SQL concepts and PL/SQL programming.

The primary goal of this course is to prepare the students to pass the Oracle9i OCP SQL & PL/SQL exam.  This Oracle OCP course is an intensive 5-day course is designed to provide Oracle professionals with an in-depth understanding of the SQL & PL/SQL features of Oracle, specific Oracle concepts and knowledge required for the OCP exam, and tips and techniques for passing the Oracle OCP exam on your first attempt.

Broad in scope, this course covers all of the Oracle SQL & PL/SQL topics on the OCP exam.  PL/SQL techniques include PL/QL control structures, PL/SQL Boolean Logic, PL/SQL array processing, bulk collect techniques and the use of stored procedures and PL/SQL packages.  SQL techniques include in-line views, scalar subqueries, correlated and non-correlated subqueries, execution plan analysis and SQL tuning.

Book Recommended

  Oracle PL/SQL 101

Christopher Allen

Osborne ORACLE Press Series
McGraw-Hill Professional Publishing

ISBN: 007212606X

  OCA/OCP: Introduction to Oracle SQL Study Guide

Chip Dawes & Biju Thomas


ISBN: 0782140629


This Oracle OCP SQL & PL/SQL exam review training is designed for the practicing Oracle professional but it is useful to anyone interested in learning Oracle SQL and PL/SQL.  Appropriate students include Oracle developers, Oracle DBAs, Oracle web developers and any computer professional who needs to understand developing applications using Oracle SQL & PL/SQL.  The course assumes a basic knowledge of computer programming techniques, relational database concepts and basic SQL syntax.

Curriculum Design

This Oracle OCP training was designed by Donald K. Burleson.  Author of more than 30 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle High-Performance SQL tuning. Burleson Corporation instructors offer decades of real world DBA experience in Oracle features, and they will share their Oracle secrets in this intense Oracle training.

Learning Objectives:

The primary objective of this Oracle OCP training is to provide each student with the knowledge and testing secrets for passing the Oracle OCP SQL & PL/SQL exam.  The student will gain confidence in their Oracle SQL & PL/SQL knowledge and learn the tricks and traps of the Oracle OCP SQL & PL/SQL exam.

Using a proven training combination of intense instruction, practicum and numerous Oracle sample exams, the student should have a firm understanding of Oracle SQL and PL/SQL coding techniques.  

Oracle SQL & PL/SQL OCP Preparation Training Course

A five day on-site Oracle Certified Professional SQL & PL/SQL class
Test 1Z0-007
Copyright © 2007-2016 by Burleson Corporation
Day 1: SQL & PL/SQL Features Overview
Using SQL*Plus
Connecting to SQL*Plus
Use of glogin.sql and related files
Environmental Aspects of SQL*Plus
Use of the SET command
Use of the COLUMN command
Using SQL
Oracle SQL*Plus OCP questions
Cursor processing steps
Simple Select
Use of table joins
Use of outer joins
Use of self joins
Use of inline views
Oracle basic SQL OCP questions
Use of DDL
Object creation, change and removal
The CREATE Command
The ALTER Command
The DROP Command
Oracle OCP exam questions on DDL
Use of DML
Oracle OCP DML questions
Use of DCL
Database grants and privileges
Object grants and privileges
Oracle DCL OCP questions
Day 2: SQL structures
Basic SQL Syntax Features
            In-line views
            Correlated and non-correlated subqueries
            Scalar subqueries
Oracle SQL Features
            Oracle built-in functions
Day 3: PLSQL structures
PL/SQL Introduction
Anonymous PL/SQL blocks
Standalone PL/SQL programs
PL/SQL Functions
PL/SQL Procedures
PL/SQL Packages
Oracle OCP basic PL/SQL exam questions
PL/SQL Program Structure
Declaration section
            Variable declaration
            Use of %TYPE and %ROWTYPE
            Use of constants
            Specification of arrays
            Specification of cursors
Executable Section
BEGIN and END block structure
            IF constructs
            Using SELECT
            Using DML
Exception Processing
Creating an exception
User defined exceptions
Exceptions all programs should have
OCP PL/SQL structure exam questions
Day 4: PLSQL Programming
PL/SQL Application Design
Translating functional specifications and psuedocode
Implementing top-down object-oriented design
Creating package specifications
Creating stored procedure prototypes
Enforcing encapsulation
PL/SQL OCP questions
PL/SQL Control Structures
Accepting parameters
Complex Boolean processing (nested IF statements, CASE statement)
PL/SQL looping structures (FOR, While, Repeat-Until)
PL/SQL computation (complex assignment statements)
Defining and using pointers to PL/SQL structures
Oracle OCP PL/SQL exam questions
PL/SQL interfacing with Oracle
Declaring and manipulating multiple cursors
Bulk collect
Using ref cursors
Managing database exceptions
Oracle PL/SQL OCP exam questions
Using Oracle built-in Packages
DBMS packages
UTL packages
Oracle PL/SQL packages OCP exam questions
Day 5: Advanced SQL & PL/SQL concepts
PL/SQL Advanced Topics
Using Pragma references
Creating deterministic functions
Managing pipelined functions
Mutating triggers
Pinning PL/SQL packages in the SGA
Advanced array processing techniques
PL/SQL debugging
Compiling PL/SQL
Using Java inside PL/SQL
Calling PL/SQL from external programs (C++, Java, J2EE)
Oracle PL/SQL OCP exam questions
SQL Advanced Topics
SQL tuning Techniques
Cost-based Optimizer parameters
SQL optimizer modes (all_rows, first_rows, first_rows_n)
Cost-based optimizer internals
Collecting optimizer statistics with dbms_stats
Using histograms
Using SQL Hints
Improving SQL execution speed with global temporary tables
Distributed SQL over database links
Oracle SQL OCP exam questions
Object Oriented SQL and PL/SQL
Defining and using Oracle Types and Objects
Defining and calling PL/SQL member methods
Creating and using Collections
Creating a TYPE definition
Creating an Object Table
Creating an Object View
Object Inheritance
Object Overloading
Accessing nested tables
Abstract data types in SQL & PL/SQL
Manipulating Object Identifiers (OID)
Oracle object oriented OCP exam questions
OCP Final Exam Review for SQL & PL/SQL
Full sample OCP SQL PL/SQL exam questions
OCP testing techniques for success
Testing tips and secrets



Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.