Online Technical Support Professionals eLearning Training
From 123-CBT Computer Based Training
Oracle SQL PL SQL Using Procedure Builder Curriculum

...opers, database administrators, designer/ developers, and technical support professionals. Prior to taking this curriculum, participants should be able to use a graphical user interface (GUI) and should be familiar with data processing concepts and techniques. Some prior knowledge of programming languages would be an advantage. This curriculum will help candidates prepare for test 1Z0-001,
more...
Oracle9i Peformance Tuning Managing Memory and Disk I O

...udience for this course includes Database Administrators, Technical Support Professionals, and System Administrators. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English, Portuguese, Spanish Total Learning Time 6 to 8 hours 64332 Objectives Unit 1: SQL Statement Tuning 1 - 2 hours
more...
Oracle9i Database Admin Manage Security

...ators, System Administrators, Network Administrators, and Technical Support Professionals. Additionally, learners should have taken the first four parts of this series (64311-64314). Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL:
more...
Oracle9i Database Admin Manage Data Storage

...ators, System administrators, Network administrators, and Technical support professionals. Additionally, learners should have taken the first three parts of this series 64311-64313. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL:
more...
Oracle9i Database Admin Manage Storage Structures

...ators, System administrators, Network administrators, and Technical support professionals. Additionally, learners should have taken the first two parts of this series 64311 and 64312. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL:
more...
Oracle9i Database Admin Create a Database

Course Overview The Oracle9i Database Administration: Create a Database course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle9i. Participants learn about the concepts associated with storage structure components, management of rollback segments, temporary segments, and indexes. In addition, this course discusses how to
more...
Oracle9i Database Admin Manage an Instance

...ators, System administrators, Network administrators, and Technical support professionals. Suggested prerequisites include Oracle SQL: Basic SELECT Statements (61110), Oracle SQL: Data Retrieval Techniques (61111), Oracle SQL: DML and DDL (61112), Oracle PL/SQL: PL/SQL Basics (61113), Oracle PL/SQL: Procedures, Functions, and Packages (61114), Oracle PL/SQL: Database Programming (61115).
more...
Oracle9i SQL Data Retrieval Techniques

... includes database administrators, designers, developers, technical support professionals, and application developers. This course will help students prepare for the Oracle9i DBA certification, and is mapped to Exam 1Z0-007. Deployment Options Internet / Intranet, Download, LAN, Workstation Accreditation NASBA credits: 4 CPE Credits Language Options American English, German,
more...
Oracle PL SQL Database Programming

...e Application Developers, Database Administrators, and Technical Support Professionals. Prior to taking this course, students should have knowledge equivalent to the computer based training (CBT) courses entitled: Oracle SQL and SQL *Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL *Plus: DML and DDL (course 61112), Oracle PL/SQL: Basics (course 61113) and Oracle PL/SQL:
more...
Oracle PL SQL Procedures Functions Packages

...e Application Developers, Database Administrators, and Technical Support Professionals. Prior to taking this course, students should have knowledge equivalent to the computer based training (CBT) courses entitled: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL*Plus: DML and DDL (61112). T otal Learning Time 6 - 8 Hour(s) Course Contents Unit
more...
Oracle8i Network Administration Net8 Additional Config Troubleshooting

...ators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315), and the first part in this series, Oracle8i Network Administration: Net8 Architecture and Basic Configuration (63326). This course will help candidates prepare for the Oracle8i Certified Database
more...
Oracle8i Network Administration Net8 Architecture Strategy

...ators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315). This course will help candidates prepare for the Oracle8i Certified Database Administrator (DBA) Track Exam 5, 1Z0-026. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Net8
more...
Oracle8i Backup and Recovery Troubleshooting Recovery

...ators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315) prior to taking this course, and Oracle8i Backup and Recovery: Strategies and Backups (63321). This course will help candidates prepare for the Oracle8i Certified Database Administrator (DBA) Track Exam 3,
more...
Oracle8i Backup and Recovery Strategies Backups

...ators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315) prior to taking this course. This course will help candidates prepare for the Oracle8i Certified Database Administrator (DBA) Track Exam 3, 1Z0-025. T otal Learning Time 6 - 8 Hour(s) Course
more...
Oracle8i Performance Tuning Optimizing Sorts Minimizing Contention

...ators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315) prior to taking this course, and Oracle8i Performance Tuning: Strategies and Techniques (63331) and Oracle8i Performance Tuning: Managing Memory and Disk I/O (63332). This course will help candidates
more...
Oracle8i Performance Tuning Managing Memory Disk I O

...ators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315) prior to taking this course, and Oracle8i Performance Tuning: Strategies and Techniques (63331). This course will help candidates prepare for the Oracle8i Certified Database Administrator (DBA) Track Exam
more...
Oracle8i Performance Tuning Architecture Strategy

...ators, System Administrators, Network Administrators, and Technical Support Professionals. Participants should have completed the Oracle8i Database Administration Series (courses 63311-63315) prior to taking this course, and experience using Oracle Enterprise Manager (OEM). This course will help candidates prepare for the Oracle8i Certified Database Administrator (DBA) Track Exam 4, 1Z0-024.
more...
Oracle8i Database Admin Manage Security

...istrators, System Administrators, Network Administrators, Technical Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i
more...
Oracle8i Database Admin Manage Data Storage

...istrators, System Administrators, Network Administrators, Technical Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i
more...
Oracle8i Database Admin Manage Storage Structures

...istrators, System Administrators, Network Administrators, Technical Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311) and Oracle8i
more...
Oracle8i Database Admin Create Databases

...istrators, System Administrators, Network Administrators, Technical Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113), Oracle8i Database Administration: Manage an Instance (63311). This course will
more...
Oracle8i Database Admin Manage an Instance

...istrators, System Administrators, Network Administrators, Technical Support Professionals. Participants should have taken Oracle SQL and SQL*Plus: Basic SELECT Statements (61110), Oracle SQL and SQL*Plus: Data Retrieval Techniques (61111), Oracle SQL and SQL*Plus: DML and DDL (61112), Oracle PL/SQL: Basics (60113). This course will help candidates prepare for the Oracle8i Certified DBA
more...
Oracle Reports R6 Control Reports

...elopers, Database Administrators, Designer/Developers and Technical Support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61111); Oracle SQL and SQL*Plus: DML and DDL (course 61112); Oracle PL/SQL: Basics (course 60113); Oracle PL/SQL: Procedures, Functions and Packages (course 60114); and Oracle
more...
Oracle Reports R6 Enhance Reports

...velopers, DatabaseAdministrators, Designer/Developers and Technical Support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61111); Oracle SQL and SQL*Plus: DML and DDL (course 61112); Oracle PL/SQL: Basics (course 60113); Oracle PL/SQL: Procedures, Functions and Packages (course 60114); and Oracle
more...
Oracle Reports R6 Report Fundamentals

...A udience Application Developers, Designer/Developer, Technical support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61111); Oracle SQL and SQL*Plus: DML and DDL (course 61112); Oracle PL/SQL: Basics (course 60113); Oracle PL/SQL: Procedures, Functions and Packages (course 60114); and Oracle
more...
Oracle Form Builder R6 Including Reusable Oracle Components

...lopers, database administrators, designer/developers, and technical support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL:
more...
Oracle Form Builder R6 Controlling the User Interface Programmatically

...lopers, database administrators, designer/developers, and technical support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL:
more...
Oracle Form Builder R6 Project Builder and Menu Modules

...lopers, database administrators, designer/developers, and technical support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL:
more...
Oracle Form Builder R6 Writing and Debugging Code

...lopers, database administrators, designer/developers, and technical support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL:
more...
Oracle Form Builder R6 Enhancing the User Interface

...lopers, database administrators, designer/developers, and technical support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL:
more...
Oracle Form Builder R6 Forms Fundamentals

...lopers, database administrators, designer/developers, and technical support professionals. Participants should have knowledge equivalent to the following courses: Oracle SQL: Basic SELECT Statements (61110); Oracle SQL: Data Retrieval Techniques (61111); Oracle SQL: DML and DDL (61112); Oracle PL/SQL: Basics (60113); Oracle PL/SQL: Procedures, Functions and Packages (60114); and, Oracle PL/SQL:
more...
Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention

...dministrators, applications designers and developers, and technical support professionals.
Prior to taking this course, participants should familiar with administering an Oracle8 database, or have taken the Oracle8 Database Administration series (courses 61311-61315). In addition, they should understand key strategies and techniques involved in tuning an Oracle8 database, or have taken the
more...
Oracle8 Performance Tuning Managing Memory and Disk I O

...dministrators, applications designers and developers, and technical support professionals.
Prior to taking this course, participants should be familiar with administering an Oracle8 database, or have taken the Oracle8 Database Administration series (courses 61311-61315). In addition, they should understand key strategies and techniques involved in tuning an Oracle8 database, or have taken the
more...
Oracle8 Performance Tuning Strategies and Techniques

...dministrators, applications designers and developers, and technical support professionals.
Prior to taking this course, participants should be familiar with administering an Oracle8 database and have experience using Oracle Enterprise Manager (OEM), or have taken the Oracle8 Database Administration series (courses 61311-61315).
T otal Learning Time
6 - 8 Hour(s)
Course Contents
more...
Oracle8 Database Administration - Manage Security

...ators, system administrators, network administrators, and technical support professionals. Prior to taking this course, participants should be familiar with SQL and PL/SQL using Procedure Builder, or have taken courses 60111, 60112, 60113, and 60114. In addition, participants should have taken the first four parts of the Oracle8 Database Administration series, courses 61311, 61312, 61313, and
more...
Oracle8 Database Administration - Manage Data

...ators, system administrators, network administrators, and technical support professionals. Prior to taking this course, 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
more...
Oracle8 Database Administration - Manage Storage Structures

...ators, system administrators, network administrators, and technical support professionals. Prior to taking this course, 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 Oracle8 Database Administration series, courses 61311 and 61312.
T otal
more...
Oracle8 Database Administration - Create Databases

...ators, system administrators, network administrators, and technical support professionals. Prior to taking this course, 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 part of the Oracle8 Database Administration series, course 61311.
T otal Learning Time
6 - 8
more...
Oracle8 Database Administration - Manage an Instance

...rators, system administrators, network administrators and technical support professionals. Prior to taking this course, 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
more...
Oracle Report Builder Controlling Reports

...lopers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, 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
more...
Oracle Report Builder Enhancing Reports

...lopers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, 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
more...
Oracle Report Builder Report Fundamentals

...lopers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, 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
more...
Oracle Form Builder Including Reusable Oracle Components

...lopers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, 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
more...
Oracle Form Builder Handling Multiple Object Relationships

...lopers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, 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
more...
Oracle Form Builder Managing Module Types

...lopers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, 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
more...
Oracle Form Builder Writing and Debugging Code

...lopers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, 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
more...
Oracle Form Builder Enhancing the User Interface

...lopers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, 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 part of the Oracle Form Builder series: Course 61211, Oracle Form Builder: Forms Fundamentals.
T
more...
Oracle SQL and SQL Plus Advanced SELECT Statements

... database administrators, system designer/developers, and technical support professionals. Learners should be familiar 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
more...
Oracle SQL and SQL Plus SQL Plus and Reporting

...database administrators, system designers/developers, and technical support professionals. Learners should be familiar 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
more...
Oracle Form Builder Forms Fundamentals

...lopers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, 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)
more...
SQL and PL SQL PL SQL Basics

... Developers, Database Administrators, System Analysts and Technical Support Professionals. Prior to taking this course students should have knowledge equivalent to the computer based training (CBT) courses entitled: Oracle SQL and SQL*Plus: Basic SELECT Statements (course 61110), Oracle SQL and SQL*Plus: DML and DDL (61112) and Oracle 8i. T otal Learning Time 6 - 8 Hour(s) Course
more...
SQL and PL SQL Basic SELECT

...lopers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, participants should be able to use a graphical user interface (GUI) and should be familiar with data processing concepts and techniques. Some prior knowledge of programming languages would be an advantage. This course will help candidates prepare for test 1Z0-001, which
more...
SQL and PL SQL Data Retrieval Techniques

...lopers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, participants should be able to use a graphical user interface (GUI) and should be familiar with data processing concepts and techniques. Some prior knowledge of programming languages would be an advantage. In addition, participants should have taken the first part of this
more...
SQL and PL SQL DML and DDL

...Administrators, Designer/Developers, System Analysts, and Technical Support Professionals. Prior to taking this course, participants should be able to use a graphical user interface (GUI) and should be familiar with data processing concepts and techniques. Some prior knowledge of programming languages would be an advantage. In addition, participants should have taken the first two courses in
more...
