Oracle Training Oracle Support Development Oracle Apps

 
 Home
 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
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

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

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

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

Sybex

ISBN: 0782140629

Audience

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
 
Syllabus
 
 
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
Use of BREAK and COMPUTE
Use of TTITLE and BTITLE
Using SQL
Oracle SQL*Plus OCP questions
 
Cursor processing steps
 
Parse
Fetch
 
Using SELECT
 
Simple Select
Use of table joins
Use of outer joins
Use of UNION, UNION ALL and MINUS
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
 
INSERT
UPDATE
DELETE
TRUNCATE
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
Triggers
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 -  2016

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.