Online Oracle8 Certified Database eLearning Training
From 123-CBT Computer Based Training
Oracle SQL PL SQL Using Procedure Builder Curriculum

...cation 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 professionals. Prior to taking this
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 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...
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 Teach Me IT
Tuning Oracle8 Database Performance

...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 to tune the various components of Oracle, such as database operations and distributed
more...
Optimizing Oracle8 Performance

... 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, it discusses the various features and uses of the
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...
Managing Users and Objects

...e 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 profiles
Grant and revoke user privileges and roles
Grant and list roles
List user privileges and role information
Define
more...
Oracle8 Backup and Recovery - II

...kup 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, the various means and modes of recovering an Oracle database to enable you to implement an effective backup and recovery scheme for your
more...
Managing Oracle8 Networks

...e Managing 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
more...
