Online Oracle9i Database eLearning - Training Resources

Introducing Oracle9i Database To introduce the components and architecture of Oracle9i, the application of Oracle9i, and migrating and upgrading to Oracle9i  more...

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

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

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

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 Architecture Strategy ...ng goals. o Sequence the steps associated with tuning an Oracle9i database. Unit 2: Alert Log, Trace Files, and Events 1 - 2 hours o Identify key information recorded by the alert log. o Identify the parameters that control the location and format of the alert log file. o Identify the different methods available for generating user process trace files. o Identify the parameters that  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 ...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 limits. • Demonstrate the use of resource limits and how to set them. • Manage system and object privileges. •  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 Course Overview 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  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 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. Learn To: o Identify the components of the relational  more...

Oracle9i Certified Database Administrator Track Curriculum The Complete 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 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...