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

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

SQL Functions in Oracle9i To describe how to use SQL functions for data retrieval  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 Memory Structures in Oracle9i To describe how to tune Oracle9i memory structures  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...