Online Oracle8 eLearning - Training Resources
Oracle8 Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
Oracle SQL PL SQL Using Procedure Builder Curriculum

...ertified Professional (OCP) Program certification tracks: Oracle8i Certified Database Administrator, Oracle8 Certified Database Administrator, and Oracle Certified Application Developer, Release 2. Learn To See individual course descriptions for specific course objectives and scope. Audience Application developers, database administrators, designer/ developers, and technical support
more...
Oracle SQL PL SQL Using Procedure Builder Curriculum
CIW E-Commerce Designer Part 4 Site Implementation

...evelopment packages. Identify the characteristics of the Oracle8 package. Identify the main capabilities of Microsoft SQL Server. Audience Candidates for this exam design and implement commerce-driven Web sites, identify customer needs, monitor customer usage patterns, determine order processes and service after sales, and consider how e-business solutions can increase sales. Candidates
more...
Oracle Reports R6 Enhance Reports

... report by creating a query using the Data Wizard. Match Oracle8 object columns and ref columns with their representation in reports. Create an external query by using the Object Navigator. Create ref queries by using the ref cursor query tool. Modify the properties of a query using Property Palette option in the Data Model. Create a data link between objects by using the link tool in the
more...
Oracle Form Builder R6 Including Reusable Oracle Components

...ment methods to use additional data sources, to work with Oracle8 objects, and to integrate charts, reports, and timers in form modules. In addition, the course covers the procedures to reuse components, objects, and code and to modify the relations between two associated blocks. Finally, the course provides information on the new features available in Oracle Developer. L earn To:
more...
Oracle8 Performance Tuning Optimizing Sorts and Minimizing Contention

...ourse Overview
This course is the third in a three-part Oracle8 Performance Tuning series. This course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts, ensure that sorting is done in memory where possible, use direct writes for large sorts and allocate temporary space appropriately. The student
more...
Oracle8 Performance Tuning Managing Memory and Disk I O

...urse Overview
This course is the second in a three-part Oracle8 Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition, participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log
more...
Oracle8 Performance Tuning Curriculum

The Oracle8 Performance Tuning Curriculum consists of the following courses:
Oracle8 Performance Tuning: Strategies and Techniques
Oracle8 Performance Tuning: Managing Memory and Disk I/O
Oracle8 Performance Tuning: Optimizing Sorts and Minimizing Contention
To review individual course descriptions, please return to the previous page and select the desired title(s).
more...
Oracle8 Performance Tuning Strategies and Techniques

...ourse Overview
This course is the first in a three-part Oracle8 Performance Tuning series. This course will introduce participants to tools and techniques used to improve the performance of the Oracle8 server. Participants will be introduced to files and events that support the tuning process. In addition, students will learn considerations for tuning applications. Finally, students will
more...
Oracle8 Network Administration Net8 Configuration and Troubleshooting

... This is the second course in a two-part series based on Oracle8 Network Administration. This course introduces participants to the trends and problems associated with business networking and presents the various solutions required to address these problems. This series explains in detail the architecture of Net8 and describes the steps in which connections are established between peers.
more...
Oracle8 Network Administration Curriculum

The Oracle8 Network Administration Curriculum consists of the following courses:
Oracle8 Network Administration: Net8 Architecture and Configuration
Oracle8 Network Administration: Net8 Configuration and Troubleshooting
To review individual course descriptions, please return to the previous page and select the desired title(s).
more...
Oracle8 Network Administration Net8 Architecture Configuration

... This is the first course in a two-part series based on Oracle8 Network Administration. This course introduces participants to the trends and problems associated with business networking and presents the various solutions required to address these problems. This series explains in detail the architecture of Net8 and describes the steps in which connections are established between peers.
more...
Oracle8 Backup and Recovery - Troubleshooting and Recovery

...nd 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 Contents
Unit 1: Failures and Troubleshooting
Duration: 1 - 2 Hour(s)
Identify the ways of resolving
more...
Oracle8 Backup and Recovery Curriculum

The Oracle8 Backup and Recovery Curriculum consists of the following courses:
Oracle8 Backup and Recovery - Strategies and Backups
Oracle8 Backup and Recovery - Troubleshooting and Recovery
To review individual course descriptions, please return to the previous page and select the desired title(s).
more...
Oracle8 Backup and Recovery - Strategies and Backups

...nd 60113. In addition, participants should have taken the Oracle8 Database Administration series, courses 61311, 61312, 61313, 61314, and 61315.
T otal Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Oracle Backup and Recovery Architecture
Duration: 1 - 2 Hour(s)
Identify the database administrator goals and the criteria for defining a backup and recovery strategy.
more...
Oracle8 Database Administration - Manage Security

...base administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and tasks associated with managing security.
L earn To:
Define and maintain the security domains for users in a given environment.
Define and maintain a named set of resources and password limits.
Manage system and object privileges.
Control the
more...
Oracle8 Database Administration - Manage Data

...base administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts associated with tables. In addition, this course will teach users about maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data.
L earn To:
Identify the characteristics of various tables and datatypes.
more...
Oracle8 Database Administration - Manage Storage Structures

...base administration strategies and procedures provided in Oracle8. In this course, participants will learn the concepts associated with storage structure components. In addition, this course will teach users how to create and maintain rollback segments, temporary segments and indexes.
L earn To:
Identify how storage structure components work.
Manage rollback segments.
Manage
more...
Oracle8 Certified Database Administrator Curriculum

... and hands-on practice in key topic areas. The Complete Oracle8 Certified Database Administrator Curriculum consists of the following courses: Oracle SQL: Basic SELECT Statements (ID#378) Oracle SQL: Data Retrieval Techniques (ID#379) Oracle SQL: DML & DDL (ID#380) Oracle SQL: PL/SQL: Basics (ID#322) Oracle8 Database Administration - Manage an Instance (ID#421) Oracle8 Database
more...
Oracle8 Database Administration - Create Databases

...base administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts associated with storage structure components, managing rollback segments, temporary segments, and indexes. In addition, creating and maintaining databases will be covered.
L earn To:
Plan and create a database.
Create the data dictionary view.
Use the
more...
Oracle8 Database Administration Curriculum

...Oracle8 Certified Database Administration Curriculum consists of the following courses:
Oracle8 Database Administration - Manage and Instance
Oracle8 Database Administration - Create Database
Oracle8 Database Administration - Manage Storage Structures
Oracle8 Database Administration - Manage Data
Oracle8 Database Administration - Manage Security
To review individual course
more...
Oracle8 Database Administration - Manage an Instance

...base administration strategies and procedures provided in Oracle8. In this course, participants will learn about the concepts and procedures associated with Oracle architectural components, using the database administration tools, managing an Oracle instance, and using National Language Support.
L earn To:
Identify Oracle architectural components.
Use the Server Manager line mode
more...
Object Analysis Design Requirements Analysis

... of object technology principles. This course supplements Oracle8 courses and Oracle Designer/2000 R2: Modeling Object Types (course 60421).
T otal Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Introduction to Object Orientation
Duration: 1 - 2 Hour(s)
Identify the importance and capabilities of Object Oriented methods.
Identify some of the difficulties in system
more...
Object Analysis Design Design Implementation

...rt of an Oracle integrated curriculum and supplements our Oracle8 courses and Oracle Designer/2000 R2: Modeling Object Types (course 60421). Participants should have taken the first part of this series, Object Analysis and Design: Requirements and Analysis (course 60027) prior to taking this course.
T otal Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: From Analysis to Design
more...
Oracle SQL Specifics Retrieving and Formatting Data

...'s object relational database management system (ORDBMS), Oracle8.
Identify how Oracle8 extends the capabilities of the Oracle7 server.
Identify characteristics of object systems.
Identify tasks performed by the Oracle DBMS.
Unit 2: The Oracle SELECT Statement
Duration: 1 - 2 Hour(s)
Match each SQL statement to its category.
Identify the components of a basic SELECT statement.
more...
Oracle SQL Specifics Creating and Managing Database Objects

...naging Tables
Duration: 1.5 - 2 Hour(s)
Match each Oracle8 data structure to its description.
Use the CREATE TABLE statement to create a table.
Use the CREATE TABLE statement and an embedded subquery to create a table from rows in another table.
Match the data dictionary views used to confirm tables and constraints with their purpose.
Identify the naming conventions to follow when
more...
SQL and PL SQL Basic SELECT

...ation tracks: Oracle7.3 Certified Database Administrator, Oracle8 Certified Database Administrator, and Oracle Certified Application Developer, Release 2. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Relational Database Concepts Duration: 1 - 2 Hour(s) Define components of the relational model. Identify the structural elements of a relational database. List
more...
SQL and PL SQL Data Retrieval Techniques

...ation tracks: Oracle7.3 Certified Database Administrator, Oracle8 Certified Database Administrator, and Oracle Certified Application Developer, Release 2. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Displaying Data From MultipleTables Duration: 1 - 2 Hour(s) Identify the four join types used to display data from more than one table. Identify a Cartesian
more...
SQL and PL SQL DML and DDL

...ation tracks: Oracle7.3 Certified Database Administrator, Oracle8 Certified Database Administrator, and Oracle Certified Application Developer, Release 2. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Creating Tables and Constraints Duration: 0.5 - 2 Hour(s) Identify the main database objects and their structures. Reference the tables of another user when
more...
From Serebra Learning Corporation
Oracle Developer: Including Reuseable Oracle Components
This course is the sixth in a six-part Oracle Developer series that is based on Oracle Developer Release 6. This course will enable learners to implement methods to use additional data sources to work with Oracle8 objects and to integrate charts reports and timers in form modules. In addition the course covers the procedures to reuse components objects and code and to modify the relations between
more...
Designer/2000 R2: Modeling Object Types
This course aims to teach the use of Object Designer to design and implementation of the Object Oriented Features of Oracle8. The use and meaning of the major components of the United Modeling Language (UML) are explained and used to describe a realistic application. The use of UML in the Type Diagrammer and the transformation of an object model into a database schema design is described in
more...
Oracle8 Database Administration - Manage an Instance
This course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course participants will learn about the concepts and procedures associated with Oracle architectural components using the database administration tools managing an Oracle instance and using National Language Support.
more...
Oracle8 Database Administration - Create Database
This course is the second in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course participants will learn about the concepts associated with storage structure components managing rollback segments temporary segments and indexes. In addition creating and maintaining databases will be covered.
more...
Oracle8 Database Administration - Manage Data Storage Structures
This course is the third in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course participants will learn the concepts associated with storage structure components. In addition this course will teach users how to create and maintain rollback segments temporary segments and indexes.
more...
Oracle8 Database Administration - Manage Data Storage
This course is the fourth in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course participants will learn about the concepts associated with tables. In addition this course will teach users about maintaining data integrity clusters and index-organized tables and methods for loading and reorganizing data.
more...
Oracle8 Database Administration - Manage Security
This course is the last in a five-part series covering the database administration strategies and procedures provided in Oracle8. In this course participants will learn about the concepts and tasks associated with managing security.
more...
Oracle8 Backup and Recovery - Strategies and Backups
This is the first course in a two-part series that will introduce participants to the critical task of planning and implementing database backup strategies. In this course users will be introduced to backup concepts and the Oracle architecture. They will learn how to change the archive mode of a database and configure a database for archive processing. Additionally users will be presented with
more...
Oracle8 Backup and Recovery - Troubleshooting and Recovery
This course is the second course in a two-part series that introduces participants to the critical task of planning and implementing database recovery strategies. This course will identify ways of handling different types of failures diagnosing errors and detecting corruption. Additionally users will be introduced to the different types of Oracle recovery methods and how to recover from the loss
more...
Oracle8 Network Administration: Net8 Architecture and Basic Configuration
...Oracle8 Network Administration. This course introduces participants to the trends and problems associated with business networking and presents the various solutions required to address these problems. This series explains in detail the architecture of Net8 and describes the steps in which connections are established between peers. Participants will learn how to implement a basic connection
more...
Oracle8 Network Administration: Net8 Additional Configuration and Troubleshooting
...Oracle8 Network Administration. This course introduces participants to the trends and problems associated with business networking and presents the various solutions required to address these problems. This series explains in detail the architecture of Net8 and describes the steps in which connections are established between peers. Participants will learn how to implement a basic connection
more...
Oracle8 Performance Tuning: Strategies and Techniques
This course is the first in a three-part Oracle8 Performance Tuning series. This course will introduce participants to tools and techniques used to improve the performance of the Oracle8 server. Participants will be introduced to files and events that support the tuning process. In addition students will learn considerations for tuning applications. Finally students will overview the operating
more...
Oracle8 Performance Tuning: Managing Memory and Disk I/O
...Oracle8 Performance Tuning series. This course introduces the learner to the application tuning issues that will impact database performance. In addition participants will be introduced to tuning components and functions of the shared pool and the buffer cache. Students will learn how to monitor the contents and usage of the Redo Log buffer. Finally participants will identify database
more...
Oracle8 Performance Tuning: Optimizing Sorts and Minimizing Contention
...Oracle8 Performance Tuning series. This course introduces the participants improving performance for sort operations. The student will be able to identify the SQL operations that require sorts ensure that sorting is done in memory where possible use direct writes for large sorts and allocate temporary space appropriately. The student will use Oracle tools to diagnose and resolve contention
more...
From Teach Me IT
Tuning Oracle8 Database Performance

...Oracle8 Database Performance WBT is the first course in the Oracle8 - Performance Tuning curriculum. This curriculum prepares the students for the Oracle8 Certified Database Administrator Track Exam # 1Z0-014. The course acquaints the users with the basic concept of performance tuning, and also discusses the various diagnostic tools used to diagnose problems in Oracle. It will also enable users
more...
Optimizing Oracle8 Performance

...Oracle8 Performance WBT is the second course in this curriculum. The curriculum prepares the students for the Oracle8 Certified Database Administrator Track Exam # 1Z0-014. The course first acquaints the users with the concept of tuning of sorts, checkpoints, resource contention, and then goes on to discuss the various OEM tools to tune background processes, networks and blocks. Additionally,
more...
Oracle SQL and PL/SQL: Basic Concepts

...curriculum. This curriculum prepares the students for the Oracle8 Certified Database Administrator Track Exam # 1Z0-001. This course explains the basic concepts regarding a DBMS, RDBMS, and ORDBMS, and give an Oracle implementation of these. It also provides users with the basic functionality of PL/SQL for creating, viewing, maintaining, and altering data in Oracle. After completing this
more...
Basic PL/SQL Programming

...curriculum. This curriculum prepares the students for the Oracle8 Certified Database Administrator Track Exam # 1Z0-001. This course enables users to create views, sequences, synonyms, records, tables, functions, and procedures. Additionally, it enables users to create different kinds of PL/SQL blocks. After completing this course, the student will be able to:
Create views
Identify the
more...
Oracle8 Database Architecture

...igned to acquaint users with the database architecture of Oracle8 and the important features of the Oracle8 database management system. This course familiarizes the user with the Oracle8 family and the important features of each of its components, such as Oracle Enterprise Manager and Oracle Worksheets. Additionally, the course provides information about various hardware configurations of each
more...
Managing Oracle8 Objects

...Oracle8 Objects WBT is designed to acquaint users with the concepts of managing various database objects, such as datafiles, tables, indexes, clusters, views, sequences, synonyms and schema objects. After completing this course, the user will be able to:
Monitor multiple databases
Manage rollback segments
Manage and alter tablespaces
Manage datafiles
Alter datafile availability
Manage
more...
Managing Users and Objects

...is course is the third course of the three courses in the Oracle8 Database Administration curriculum. The Oracle8 Database Administration curriculum prepares the students for the Oracle8 Certified Database Administrator Track Exam # 1Z0-013. After completing this course, the user will be able to:
Describe types of authentication
Manage users and user privileges
Create and manage user
more...
Oracle8 Backup & Recovery - I

...Oracle8 Backup and Recovery - I WBT is designed to acquaint users with the concepts of backup and recovery operations of the Oracle8 database. This course introduces the user to the basics of database backups, the backup strategies and their implementation, and the Recovery Manager. After completing this course, the user will be able to:
List the database backup methods
Describe the
more...
Oracle8 Backup and Recovery - II

...Oracle8 Backup and Recovery - II WBT is the second course of the two courses in the Oracle8 Backup and Recovery curriculum. The Oracle8 Backup and Recovery curriculum prepares the students for the Oracle8 Certified Database Administrator Track Exam # 1Z0-015. This course is designed to acquaint users with the concepts of backup and recovery operations of an Oracle database. It cites, in detail,
more...
Planning an Oracle8 Data Warehouse

...Oracle8 Data Warehouse is the first course in the Oracle8 DataWarehousing curriculum. The course enables a user to understand the concepts of data warehousing and learn how to plan a data warehouse design. The course familiarizes the users with the data warehouse architecture and process flow, as well as various Oracle features that support data warehousing. Additionally, the course explains in
more...
Implementing an Oracle8 Data Warehouse

...Oracle8 data warehouse is the second course in the Oracle8 Data Warehousing curriculum. The course provides the users an insight into the functionalities of an Oracle data warehouse and enables them to organize for building a data warehouse. Apart from getting familiar with the concepts of moving and managing data, the users also receive a sound understanding of SQL*Loader, a common tool for
more...
Optimizing and Securing an Oracle8 Data Warehouse

...Oracle8 Data Warehouse is the third course of the Oracle8 Data Warehousing curriculum. This course acquaints users to the various methods that can be employed to secure and optimize an Oracle8 data warehouse. The course explains the concepts of tuning the data warehouse, creating backups, recovering and archiving data. The course extensively covers aspects related to securing the data warehouse
more...
Managing Oracle8 Networks

...Oracle8 Networks WBT prepares students for the Oracle8 Certified Database Administrator Track Exam #1Z0-016. This course acquaints network administrators with the basic architecture of Oracle8 networks. It introduces Net8 and teaches users to plan and configure an Oracle8 network. The course also enables users to configure advanced Oracle8 network services, such as Oracle Names Server,
more...
