From Serebra Learning Corporation
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 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 123-CBT Computer Based Training
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 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 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 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 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...
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...
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...