Online Oracle9i eLearning - Training Resources
Oracle9i Training Provider? - Tell us about your Training!
From 123-CBT Computer Based Training
Introducing Oracle9i Database
To introduce the components and architecture of Oracle9i, the application of Oracle9i, and migrating and upgrading to Oracle9i
more...
Introducing Oracle9i Database
Manageability Enhancements in Oracle9i
To describe the manageability enhancements of an Oracle9i database
more...
Availability Features in Oracle9i
To explain how the new features of an Oracle9i database support the maximum availability of a database
more...
Scalability and Performance in Oracle9i
To describe the scalability and performance enhancements available in an Oracle9i database
more...
Development Platform in Oracle9i
To explain the Oracle9i database enhancements that support the Oracle9i database development platform
more...
Security Overview for Oracle9i Administrators
To provide an overview of the security features in an Oracle9i database
more...
Introduction to Oracle and SQL in Oracle9i
To introduce Oracle as a relational database management system (RDBMS) and to discuss how to use basic SQL statements
more...
Subqueries Reporting and User-Access Control in Oracle9i
To describe the use of subqueries, reporting, and user-access control in an Oracle9i database
more...
Defining and Manipulating Data in Oracle9i
To describe how to define database objects and manipulate the data stored within them in an Oracle9i database
more...
Performance Tuning Methodology and Tools in Oracle9i
To describe the methods and goals of database tuning and the utilities and tools used to analyze and tune an Oracle9i database
more...
Tuning Database Structures in Oracle9i
To describe how to tune components of an Oracle9i database
more...
Tuning Systems and Applications in Oracle9i
To describe how to tune systems and applications in Oracle9i
more...
Architecture and Administration Tools in Oracle9i
To describe the Oracle9i database architecture and how to use the database administration tools
more...
Database and Instance Management in Oracle9i
To describe how to manage an Oracle9i database instance and how to plan and create a database
more...
Database Structures in Oracle9i
To describe how to use an Oracle9i database data dictionary, the control files, and the redo log files
more...
Data Storage in Oracle9i
To describe the data storage structures in an Oracle9i database and explain how to manage them
more...
Tables and Indexes in Oracle9i
To describe how to manage tables and indexes in an Oracle9i database
more...
Data Integrity in Oracle9i
To describe how to use integrity constraints to enforce business rules on the data in an Oracle 9i database
more...
Users and Profiles in Oracle9i
To describe how to use manage users, passwords, and resources in an Oracle9i database
more...
Privileges and Roles in Oracle9i
To describe how to manage privileges and roles in an Oracle9i database
more...
Globalization and Auditing in Oracle9i
To describe how to manage globalization support in an Oracle9i database and how to audit an Oracle9i database
more...
Networking Overview for Oracle9i Administrators
To provide an overview of the networking solutions and the components of the network architecture in an Oracle9i database
more...
Oracle Network Configuration in Oracle9i
To explain how to configure client/server Oracle Net Services and a Shared Server for an Oracle9i database
more...
Backup and Recovery Overview and Configuration in Oracle9i
To describe backup and recovery operations, the backup components, and how to configure these components in an Oracle9i database
more...
User-Managed and RMAN Backup and Recovery in Oracle9i
To describe how to perform user-managed and Recovery Manager backup and recovery in an Oracle9i database
more...
Recovery Manager Maintenance in Oracle9i
To describe how to maintain the Recovery Manager (RMAN) and how to create and maintain the recovery catalog in an Oracle9i database
more...
Transporting and Loading Data in Oracle9i
To describe how to transport and load data in an Oracle9i database
more...
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 Performance Tuning Curriculum

The Oracle9i Database: Performance Tuning Curriculum includes the following courses: Oracle9i Performance Tuning: Architecture and Strategy Oracle9i Performance Tuning: Managing Memory and Disk I/O Oracle9i 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...
Oracle9i Database Admin Set Up Oracle Net Services

...racle SQL, Oracle PL/SQL. Suggested prerequisites include Oracle9i Database Administration: Manage an Instance (64311), and Oracle9i Database Administration: Create a Database (64312). Content Emphasis Conceptual Deployment Options Accreditation NASBA credits: 4 CPE Credits Language Options American English Total Learning Time 6 to 8 hours 64326 Objectives Unit
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 Fundamentals II Curriculum

The Oracle9i Database: Fundamentals II Curriculum includes the following courses: Oracle9i Database Admin.: Perform Database Backups Oracle9i Database Admin.: Recover Databases Oracle9i Database Admin.: Set Up Oracle Net Services To review individual course descriptions, please return to the previous page and select the desired title(s).
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 Database Admin Manage an Instance

...Oracle9i Database Administration: Manage An Instance course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle9i. This course introduces the participants to the concepts and procedures associated with Oracle architectural components. The participants learn the various tasks of a database administrator that are performed by using
more...
Oracle9i Database Fundamentals I Curriculum

...Oracle9i Database: Fundamentals I Curriculum includes the following courses: Oracle9i Database Admin.: Manage an Instance Oracle9i Database Admin.: Create a Database Oracle9i Database Admin.: Manage Storage Structures Oracle9i Database Admin.: Manage Data Storage Oracle9i Database Admin.: Manage Security To review individual course descriptions, please return to the previous page and
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...
Oracle9i SQL Data Retrieval Techniques

...evelopers. 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, Brazilian Portuguese, Spanish Total Learning Time 6 to 8 hours 61131 Objectives Unit 1: Displaying Data
more...
Oracle9i SQL Basic SELECT Statements

...evelopers. 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, Brazilian Portuguese, Spanish Total Learning Time 6 to 8 hours 61130 Objectives Unit 1: Relational Database
more...
Oracle9i SQL Curriculum

The Introduction to Oracle9i: SQL Curriculum includes the following courses: Oracle9i SQL: Basic SELECT Statements Oracle9i SQL: Data Retrieval Techniques Oracle9i SQL: DML and DDL To review individual course descriptions, please return to the previous page and select the desired title(s).
more...
Oracle9i Certified Database Administrator Track Curriculum

...Oracle9i Certified Database Administrator Track Curriculum includes the following curriculums: Introduction to Oracle9i: SQL Curriculum (ID#8054) Oracle9i Database: Fundamentals I Curriculum (ID#8058) Oracle9i Database: Fundamentals II Curriculum (ID#8064) Oracle9i Database: Performance Tuning Curriculum (ID#8068) To review individual curriculum descriptions, please select the
more...
Oracle Database 10g PL SQL Fundamentals Part 1

...s, and Technical consultants who have experience with the Oracle9i Database.
Deployment:
Self-Study
Language Options:
US English
Total Learning Time:
8 hours
Objectives:
Unit 1: Programming with PL/SQL
Identify features of PL/SQL.
Identify benefits of PL/SQL.
Identify features of PL/SQL blocks.
Match different PL/SQL program constructs with their
more...
Oracle Database Administration Workshop I Part 2

...s, and Technical consultants who have experience with the Oracle9i Database.
Deployment:
Self-Study
Language Options:
US English
Total Learning Time:
4 hours
Objectives:
Unit 1: Managing Users
Identify features of database user accounts and profiles in Oracle Database 10g.
Identify options you can configure when creating a user.
Identify options used to
more...
Oracle Database 10g New Features for Administrators Part 1

...s, and Technical consultants who have experience with the Oracle9i Database.
Deployment:
Self-Study
Language Options:
US English
Total Learning Time:
6 hours
Objectives:
Unit 1: Oracle Database 10g - New Features
Match goals of Oracle Database 10g manageability with the methods of achieving them.
Identify features of the Oracle Database 10g manageability
more...
Oracle Database 10g New Features for Administrators Part 2

...s, and Technical consultants who have experience with the Oracle9i Database.
Deployment:
Self-Study
Language Options:
US English
Total Learning Time:
6 hours
Objectives:
Unit 1: Automatic Management
Identify features of Automatic Database Diagnostic Monitor (ADDM).
Identify options for analyzing Automatic Database Diagnostics Monitor (ADDM) results.
more...
Oracle Database 10g New Features for Administrators Part 3

...s, and Technical consultants who have experience with the Oracle9i Database.
Deployment:
Self-Study
Language Options:
US English
Total Learning Time:
6 hours
Objectives:
Unit 1: Resource Management and Job Scheduling
Identify features of Resource Manager in Oracle Database 10g.
Identify options for creating a mapping between consumer groups and session
more...
Oracle Database 10g New Features for Administrators Part 4

...s, and Technical consultants who have experience with the Oracle9i Database.
Deployment:
Self-Study
Language Options:
US English
Total Learning Time:
6 hours
Objectives:
Unit 1: Backup and Recovery Enhancements
Identify features of the flash backup and recovery strategy.
Identify tasks that you perform when using the flash recovery area to simplify
more...
Oracle Database 10g New Features for Administrators Part 5

...s, and Technical consultants who have experience with the Oracle9i Database.
Deployment:
Self-Study
Language Options:
US English
Total Learning Time:
6 hours
Objectives:
Unit 1: Storage Management
Identify features of Automatic Storage Management (ASM).
Identify tasks in the process for creating an ASM-enabled database instance.
Identify options for
more...
Oracle 9i New Features Database Administration

...Oracle9i enhancements in server-side manageability, Oracle Enterprise Manager, and globalization. Learn To Identify memory and space management improvements. Describe segment and index management improvements. Identify improvements in database operations and performance. Recognize
more...
Oracle 9i New Features Backup Recovery Performance Tuning

This course introduces students to high availability and fault recovery, data protection and disaster recovery, LogMiner enhancements, online operations, and Recovery Manager enhancements. Students also learn about schema improvements, system improvements, and scalable session state management. Learn To Identify the new features designed to reduce unplanned
more...
Oracle Database 10g PL SQL Fundamentals Part 3

...s, and Technical consultants who have experience with the Oracle9i Database.
Deployment:
Self-Study
Language Options:
US English
Total Learning Time:
8 hours
Objectives:
Unit 1: Dynamic SQL Statements
Match the stages in the execution of SQL statements with their descriptions.
Identify features of dynamic SQL.
Identify the features of the DBMS_SQL package.
more...
From Serebra Learning Corporation
Backup and Recovery Overview and Configuration in Oracle9i
To describe backup and recovery operations, the backup components, and how to configure these components in an Oracle9i database Oracle database administrators and database operators
more...
User-Managed and RMAN Backup and Recovery in Oracle9i
To describe how to perform user-managed and Recovery Manager backup and recovery in an Oracle9i database Oracle database administrators and database operators
more...
Recovery Manager Maintenance in Oracle9i
To describe how to maintain the Recovery Manager (RMAN) and how to create and maintain the recovery catalog in an Oracle9i database Oracle database administrators and database operators
more...
Transporting and Loading Data in Oracle9i
To describe how to transport and load data in an Oracle9i database Oracle database administrators and database operators
more...
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...
Tables and Indexes in Oracle9i
To describe how to manage tables and indexes in an Oracle9i database Anyone wanting to learn about Oracle9i database administration
more...
Data Integrity in Oracle9i
To describe how to use integrity constraints to enforce business rules on the data in an Oracle 9i database Anyone wanting to learn about Oracle9i database administration
more...
Users and Profiles in Oracle9i
To describe how to use manage users, passwords, and resources in an Oracle9i database Anyone wanting to learn about Oracle9i database administration
more...
Database Structures in Oracle9i
To describe how to use an Oracle9i database data dictionary, the control files, and the redo log files Anyone wanting to learn about Oracle9i database administration
more...
Privileges and Roles in Oracle9i
To describe how to manage privileges and roles in an Oracle9i database Anyone wanting to learn about Oracle9i database administration
more...
Globalization and Auditing in Oracle9i
To describe how to manage globalization support in an Oracle9i database and how to audit an Oracle9i database Anyone wanting to learn about Oracle9i database administration
more...
Networking Overview for Oracle9i Administrators
To provide an overview of the networking solutions and the components of the network architecture in an Oracle9i database Oracle database administrators and database operators
more...
Oracle Network Configuration in Oracle9i
To explain how to configure client/server Oracle Net Services and a Shared Server for an Oracle9i database Oracle database administrators and database operators
more...
Introduction to Oracle and SQL in Oracle 9i
To introduce Oracle as a relational database management system (RDBMS) and to discuss how to use basic SQL statements Junior database administrators, application developers, and database operators
more...
SQL Functions in Oracle 9i
To describe how to use SQL functions for data retrieval Junior database administrators, application developers, and database operators
more...
Subqueries Reporting and User-Access Control in Oracle 9i
To describe the use of subqueries, reporting, and user-access control in an Oracle9i database Junior database administrators, application developers, and database operators
more...
Defining and Manipulating Data in Oracle 9i
To describe how to define database objects and manipulate the data stored within them in an Oracle9i database Junior database administrators, application developers, and database operators
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...
Manageability Enhancements in Oracle9i
To describe the manageability enhancements of an Oracle9i database 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...
Scalability and Performance in Oracle9i
To describe the scalability and performance enhancements available in an Oracle9i 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...
Security Overview for Oracle9i Administrators
To provide an overview of the security features in an Oracle9i database Database operators, administrators, and developers interested in the new technical features and benefits of an Oracle9i database
more...
Performance Tuning Methodology and Tools in Oracle9i
To describe the methods and goals of database tuning and the utilities and tools used to analyze and tune an Oracle9i database Anyone wishing to learn about Oracle9i database performance tuning
more...
Tuning Memory Structures in Oracle9i
To describe how to tune Oracle9i memory structures Anyone wishing to learn about Oracle9i database performance tuning
more...
Tuning Database Structures in Oracle9i
To describe how to tune components of an Oracle9i database Anyone wishing to learn about Oracle9i database performance tuning
more...
Tuning Systems and Applications in Oracle9i
To describe how to tune systems and applications in Oracle9i Anyone wishing to learn about Oracle9i database performance tuning
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 Database Administration: Manage an Instance


...Oracle9i Database Administration: Manage An Instance course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle9i. This course introduces the participants to the concepts and procedures associated with Oracle architectural components. The participants learn the various tasks of a database administrator that are performed by using
more...
Oracle9i Database Administration: 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 Database Administration: Manage Storage Structures


The Oracle 9i Database Administration: Manage Storage Structures course is the third in a five-part series covering the database 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
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: Strategies and Backups


...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 commands, and the Oracle Enterprise Manager Console. Students
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
more...
Oracle9i Database Administration: Set Up Oracle Net Services


This course covers the architecture and configuration of Oracle Net Services. It details client-server and web implementations, in addition to additional features such as Dynamic Service Registration and the use of the Oracle Names Server as an LDAP Proxy. This course also discusses the configuration of the Oracle Shared Server and Oracle Names Server.
more...
Oracle9i Performance Tuning: Strategies and Techniques


In this course, you are introduced to the strategies and techniques used for tuning the Oracle9i server.
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 New Features: Database Administration
This course introduces learners to the Oracle9i enhancements in server-side manageability Oracle Enterprise Manager and globalization.
more...
Oracle9i New Features: Backup, Recovery, and Performance Tuning
This course introduces students to high availability and fault recovery data protection and disaster recovery LogMiner enhancements online operations and Recovery Manager enhancements. Students also learn about schema improvements system improvements and scalable session state management.
more...
Oracle9i Database Administration: Manage an Instance
...Oracle9i Database Administration: Manage An Instance course is the first in a five-part series covering the database administration strategies and procedures provided in Oracle9i. This course introduces the participants to the concepts and procedures associated with Oracle architectural components. The participants learn the various tasks of a database administrator that are performed by using
more...
Oracle9i Database Administration: 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 Database Administration: Manage Storage Structures
The Oracle 9i Database Administration: Manage Storage Structures course is the third in a five-part series covering the database 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
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: Strategies and Backups
...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 commands and the Oracle Enterprise Manager Console. Students assess the
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 Database Administration: Set Up Oracle Net Services
This course covers the architecture and configuration of Oracle Net Services. It details client-server and web implementations in addition to additional features such as Dynamic Service Registration and the use of the Oracle Names Server as an LDAP Proxy. This course also discusses the configuration of the Oracle Shared Server and Oracle Names Server.
more...
Oracle9i Performance Tuning: Strategies and Techniques
In this course you are introduced to the strategies and techniques used for tuning the Oracle9i server.
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: Basics
...Oracle9i PL/SQL: Basics course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design develop and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming.
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 Software Training Academy, Inc
Oracle 10g Administration

... on the use of the Server Parameter File, introduced with Oracle9i.
Create new Oracle users, provide tablespace quota and grant them the system or object privileges necessary to perform their work, including the use of roles. Secure the default users provided with database installation.
Implement the Oracle user password management features such as password expiration, account
more...
