From Serebra Learning Corporation
Data Storage in Oracle9i 
To describe the data storage structures in an
Oracle9i database and explain how to manage them
Anyone wanting to learn about Oracle9i database administration
more...
Introducing Oracle9i Database 
To introduce the components and architecture of
Oracle9i, the application of Oracle9i, and migrating and upgrading to
Oracle9i Oracle database administrators; developers interested in the technical aspects of Oracle9i database
more...
Availability Features in Oracle9i 
To explain how the new features of an
Oracle9i database support the maximum availability of a database
Database operators, administrators, and developers interested in the new technical features and benefits of an Oracle9i database
more...
Development Platform in Oracle9i 
To explain the
Oracle9i database enhancements that support the Oracle9i database development platform
Database operators, administrators, and developers interested in the new technical features and benefits of an Oracle9i database
more...
Oracle9i SQL: Basic SELECT Statements 


This course covers relational database principles and
Oracle concepts; writing basic
SQL statements; restricting and sorting data; and using single-row functions. Additionally, this course provides an introduction to relational database concepts and the use of SQL for storing, retrieving, and manipulating data in a relational database.
more...
Oracle9i SQL: DML and DDL 


The
Oracle SQL DML and
DDL course is the third in a three-part series covering the
Data Manipulation and
Data Definition language statements supported by
Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table.
more...
Oracle9i Database Administration: Manage Data Storage 


This course is the fourth in the series covering the database administration strategies and procedures provided in
Oracle9. This course covers the concepts associated with tables, maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data.
more...
Oracle9i Database Administration: Manage Security 


This course is the last in a five-part series covering the database administration strategies and procedures provided in
Oracle9i. In this course you will learn the concepts and methods associated with implementing security and resource consumption in an Oracle9i database.
more...
Oracle9i Performance Tuning: Managing Memory and Disk I/O 


This course introduces students to the importance of good initial database design, and the methods used to tune an
Oracle9i production database. Students learn how to use the available
Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database.
more...
Oracle9i Performance Tuning: Optimizing Sorts and Minimizing Contention 


The content of this course includes details about each component of an
Oracle database instance, such as data blocks, disks, memory,
CPU, and dynamic views. Students learn about migration and chaining, reorganizing indexes, optimizing sort operations, tuning rollback segments, managing automatic undo, monitoring activities, implementing the Oracle shared server, and troubleshooting.
more...
Oracle9i Database Administration: Manage Data Storage 
This course is the fourth in the series covering the database administration strategies and procedures provided in
Oracle9. This course covers the concepts associated with tables maintaining data integrity clusters and index-organized tables and methods for loading and reorganizing data.
more...
Oracle9i Database Administration: Manage Security 
This course is the last in a five-part series covering the database administration strategies and procedures provided in
Oracle9i. In this course you will learn the concepts and methods associated with implementing security and resource consumption in an Oracle9i database.
more...
Oracle9i Database Administration: Recover Databases 
...Oracle9i database recovery concepts. The recovery concepts course includes recovery with and without archiving recovery of offline and online databases recovery with missing data files and incomplete recovery with and without archiving. Additional concepts covered by this course include time-based recovery cancel-based recovery recovery manager components recovery manager commands export and
more...
Oracle9i Performance Tuning: Managing Memory and Disk I/O 
This course introduces students to the importance of good initial database design and the methods used to tune an
Oracle9i production database. Students learn how to use the available
Oracle tools to recognize troubleshoot and resolve common performance-related problems in administering an Oracle database.
more...
Oracle9i Performance Tuning: Optimizing Sorts and Minimizing Contention 
The content of this course includes details about each component of an
Oracle database instance such as data blocks disks memory
CPU and dynamic views. Students learn about migration and chaining reorganizing indexes optimizing sort operations tuning rollback segments managing automatic undo monitoring activities implementing the Oracle shared server and troubleshooting.
more...
Oracle9i SQL: Basic SELECT Statements 
This course covers relational database principles and
Oracle concepts; writing basic
SQL statements; restricting and sorting data; and using single-row functions. Additionally this course provides an introduction to relational database concepts and the use of SQL for storing retrieving and manipulating data in a relational database.
more...
Oracle9i SQL: Data Retrieval Techniques 
This course covers joins group functions subqueries and the iSQL*Plus report variables. Additionally this course shows students how to access data from multiple table using joins aggregate data using group functions create subqueries and use iSQL*Plus commands to create customized queries.
more...
Oracle9i SQL: DML and DDL 
The
Oracle SQL DML and
DDL course is the third in a three-part series covering the
Data Manipulation and
Data Definition language statements supported by
Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create update and delete the database objects. The participants also learn to add rows update and delete existing rows from a table.
more...
Oracle9i PL/SQL: Procedures Functions and Packages 
This course introduces users to the basics of PL/
SQL subprograms. Users will learn how to build and invoke procedures and functions. This course also covers debugging PL/SQL subprograms using
Procedure Builder. Additionally users will learn how to trap and handle errors in a PL/SQL block. This course also covers the basics of packages and how to create and use them.
more...
Oracle9i PL/SQL: Database Programming 
This course discusses the features of stored subprograms and packages. Participants will learn how to create and invoke stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. Participants will learn how to manage stored subprograms and packages. This course also introduces
more...
From 123-CBT Computer Based Training
Oracle9i Performance Tuning Optimizing Sorts Minimizing Contention 

The content of this course includes details about each component of an
Oracle database instance, such as data blocks, disks, memory,
CPU, and dynamic views. Students learn about migration and chaining, reorganizing indexes, optimizing sort operations, tuning rollback segments, managing automatic undo, monitoring activities, implementing the Oracle shared server, and troubleshooting. Learn To:
more...
Oracle9i Peformance Tuning Managing Memory and Disk I O 

... initial database design, and the methods used to tune an
Oracle9i production database. Students learn how to use the available
Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database. Learn To: o
Match the optimizer modes with their descriptions. o Match the
OPTIMIZER_MODE parameter values with their description. o
more...
Oracle9i Performance Tuning Architecture Strategy 

...uced to the strategies and techniques used for tuning the
Oracle9i server. Learn To: o
Match the tuning goals with the appropriate job role. o
Identify common tuning problems that directly affect database performance. o Identify appropriate tuning goals. o Identify key information recorded by the alert log. o Identify the parameters that control the location and format of the alert
more...
Oracle9i Database Admin Recover Databases 

...Oracle9i database recovery concepts. The recovery concepts course includes recovery with and without archiving, recovery of offline and online databases, recovery with missing data files, and incomplete recovery with and without archiving. Additional concepts covered by this course include time-based recovery, cancel-based recovery, recovery manager components, recovery manager commands, export
more...
Oracle9i Database Admin Perform Database Backups 

...w This course introduces students to backup methods for
Oracle9i database administration. The backup concepts covered by this course include backup strategies and requirements,
Oracle Architecture, archiving data, backup methods, and working with a standby database. Students perform backup procedures using operating system utilities, Oracle9i utilities such as
RMAN, standard
SQL*Plus
more...
Oracle9i Database Admin Manage Security 

...base administration strategies and procedures provided in
Oracle9i. In this course you will learn the concepts and methods associated with implementing security and resource consumption in an Oracle9i database. Learn To Define and maintain the five components of the security domain of a user in a given environment. Define and maintain a named set of resource and password
more...
Oracle9i Database Admin Manage Data Storage 

Course
Overview This course is the fourth in the series covering the database administration strategies and procedures provided in
Oracle9. This course covers the concepts associated with tables, maintaining data integrity, clusters and index-organized tables, and methods for loading and reorganizing data. Learn To Identify the row storage method used by the various tables and the
more...
Oracle9i Database Admin Manage Storage Structures 

...base administration strategies and procedures provided in
Oracle9i. In this course, participants learn the concepts associated with storage structure components. In addition, this course teaches users the procedures for managing segment free space, undo space, temporary segments, and indexes. Learn To Identify the types of segments in the storage hierarchy. Identify the
more...
Oracle9i Database Admin Create a Database 

...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 create and maintain
more...
Oracle9i SQL DML and DDL 

...tion and
Data Definition language statements supported by
Oracle9i. This course introduces the participants to various objects in a database. The participants learn to create, update, and delete the database objects. The participants also learn to add rows, update, and delete existing rows from a table. The course also explains the use of external tables and how to create the external tables.
more...