Online Oracle9i Database Administration eLearning Training

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...

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 This course introduces students to 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,  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 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 This course introduces students to 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  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...