| |
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
* Understand SQL &
PL/SQL Features.
* See SQL structures.
* Understand PLSQL structures.
* Employ PLSQL Programming.
* Learn Advanced SQL & PL/SQL concepts.
|
|
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.
 |
|
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
|
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.
|
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
|
and include the URL for the page.
