* Learn Oracle 10g
installation & configuration.
* Understand Server
Configuration.
* See new Oracle10g
Utilities Enhancements.
* Use Oracle10g Backup and
Recovery Features.
* Learn Oracle10g Database
Tuning and Performance.
* Understand Oracle10g
Globalization Improvements.
|
|

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 Oracle10g OCP SQL & PL/SQL
exam. This course provides sample OCP exam questions and an
opportunity to access your overall knowledge of Oracle 10g SQL
concepts and PL/SQL programming.
The primary goal
of this course is to prepare the students to pass the
Oracle10g OCP SQL & PL/SQL exam. This Oracle10g 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 Oracle10g, specific Oracle concepts and
knowledge required for the OCP exam, and tips and techniques for
passing the Oracle10g OCP exam on your first attempt.
Broad in scope,
this course covers all of the Oracle10g 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 Database 10g New Features
Oracle 10g Reference for Advanced Tuning & Administration
Mike Ault, Daniel Liu, Madhu
Tumma
ISBN: 0-9740716-0-9 |

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