From 123-CBT Computer Based Training
Oracle SQL PL SQL Using Procedure Builder Curriculum 

The courses in this curriculum cover the concepts of relational databases and the
SQL and PL/SQL programming languages. Students learn how to create and maintain database objects and to store, retrieve, and manipulate data. In addition, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. This curriculum
more...
Oracle PL SQL Procedures Functions Packages 

...form the steps to create a client-side procedure by using
Procedure Builder. Perform the steps to create a server-side procedure by using
SQL*Plus. Identify the different methods for passing parameters. Perform the steps to create a bind variable by using SQL*Plus. Perform the steps to invoke a procedure from SQL*Plus. Perform the steps to invoke a procedure from another procedure by using
more...
Oracle8 Backup and Recovery - Troubleshooting and Recovery 

...participants should be familiar with
SQL and PL/
SQL Using Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the
Oracle8 Database Administration series, courses 61311, 61312, 61313, 61314, and 61315, and have taken the first part of the Oracle8 Backup and Recovery series, course 61321.
T otal Learning Time
6 - 8 Hour(s)
Course
more...
Oracle8 Database Administration - Manage Data 

...participants should be familiar with
SQL and PL/SQL using
Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the first three parts of the
Oracle8 Database Administration series, courses 61311, 61312, and 61313.
T otal Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Managing Tables
Duration: 1 - 2 Hour(s)
Identify
more...
Oracle8 Database Administration - Manage an Instance 

...participants should be familiar with
SQL and PL/SQL using
Procedure Builder, or have taken courses 60111, 60112 and 60113.
T otal
Learning Time
6 - 8 Hour(s)
Course
Contents
Unit 1: Oracle Architecture Components
Duration: 1 - 2 Hour(s)
Identify the tasks of a database administrator.
Match the terms associated with establishing a database connection with their
more...
Oracle Report Builder Controlling Reports 

...participants should be familiar with
SQL and PL/SQL using
Procedure Builder and PL/
SQL Database Programming, or have taken courses 60111, 60112, 60113 and 60131. In addition, participants should have taken the first two parts of this series, courses 61221 and 61222. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Developing Report Templates Duration: 1.5 - 2 Hour(s)
more...
Oracle Report Builder Enhancing Reports 

...participants should be familiar with
SQL and PL/SQL using
Procedure Builder and PL/
SQL Database Programming, or have taken courses 60111, 60112, 60113 and 60131. In addition, participants should have taken the first part in this series, course 61221. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Enhancing a Report - Data Model Duration: 1 - 2 Hour(s) Match the
more...
Oracle Report Builder Report Fundamentals 

...e, participants should familiar with
SQL and PL/SQL using
Procedure Builder and PL/
SQL Database Programming, or have taken courses 60111, 60112, 60113 and 60131. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Developer/2000 Report Builder Duration: 1.5 - 2 Hour(s) Identify the feature of Developer/2000 Match the components of Developer/2000 with the tasks that
more...
Oracle Form Builder Including Reusable Oracle Components 

...participants should be familiar with
SQL and PL/SQL using
Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the first five parts of the
Oracle Form Builder series, courses 61211, 61212, 61213, 61214 and 61215.
T otal Learning Time
7 - 8 Hour(s)
Course Contents
Unit 1: Additional Data Sources
Duration: 2 Hour(s)
more...
Oracle Form Builder Handling Multiple Object Relationships 

...participants should be familiar with
SQL and PL/SQL using
Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the first four parts of the
Oracle Form Builder series, courses 61211, 61212, 61213, and 61214. T otal Learning Time 7 - 8 Hour(s) Course Contents Unit 1: Key Triggers and Mouse Events Duration: 2 Hour(s)
more...
Oracle Form Builder Managing Module Types 

...participants should be familiar with
SQL and PL/SQL using
Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition participants should have taken the first three parts of the
Oracle Form Builder series, courses 61211, 61212, and 61213. T otal Learning Time 7 - 8 Hour(s) Course Contents Unit 1: Project Builder Duration: 3 - 4 Hour(s) Identify the benefits
more...
Oracle Form Builder Writing and Debugging Code 

...participants should be familiar with
SQL and PL/SQL using
Procedure Builder, or have taken courses 60111, 60112 and 60113. In addition, participants should have taken the first two parts of the
Oracle Form Builder series, courses 61211 and 61212.
T otal Learning Time
7 - 8 Hour(s)
Course Contents
Unit 1: Runform Messages and Alerts
Duration: 2 - 3 Hour(s)
Match the
more...
Oracle SQL and SQL Plus Advanced SELECT Statements 

...amiliar with the basic principles of
SQL and PL/SQL using
Procedure Builder or have completed courses 60111, 60112 and 60113.
T otal
Learning Time
7 - 8 Hour(s)
Course
Contents
Unit 1: Single-Row Subqueries
Duration: 2 - 3 Hour(s)
Identify the properties of the different types of subqueries.
Sequence the steps in the execution of a single-row subquery.
Complete a SELECT
more...
Oracle SQL and SQL Plus SQL Plus and Reporting 

...amiliar with the basic principles of
SQL and PL/SQL using
Procedure Builder, or have completed courses 60111, 60112 and 60113. In addition, the first part of this series should have been taken, course
60121 Oracle SQL and SQL*Plus: Advanced Select Statements.
T otal Learning Time
7 - 8 Hour(s)
Course Contents
Unit 1: SQL*Plus
Duration: 3 Hour(s)
Differentiate between SQL and
more...
Oracle Form Builder Forms Fundamentals 

...participants should be familiar with
SQL and PL/SQL using
Procedure Builder, or have taken courses 60111, 60112 and 60113.
T otal
Learning Time
7 - 8 Hour(s)
Course
Contents
Unit 1: Developer/2000 and Form Builder: An Overview
Duration: 3 - 4 Hour(s)
Identify the features of Developer/2000.
Match the components of Developer/2000 with the tasks that they enable.
Identify
more...