Oracle 10g Administration - Online Course

Oracle's new 10g database leverages the power of grid computing to spread tasks across multiple low-cost machines. Learners will be able to install and maintain an Oracle 10g database in an effective, efficient manner. Topics such as the interaction among Oracle components, an understanding of Oracle's architecture, performance monitoring, database security, user management, and backup and recovery techniques are covered.

This series is for Oracle 10g database administrators who wish to understand Oracle's Optimal Flexible Architecture, Shared Server Architecture, and database interfaces (SQL, Java, C++ and PL/SQL). This online course contains 17 lessons and should take approximately 6 hours to complete.

Lesson 1: Oracle Architectural Components (0) hour

Oracle Architectural Components teaches you how to describe the stages that the Oracle 10g Database Server goes through in processing an SQL statement, differentiate among a database, an instance and a server, and define the underlying physical, memory, process and logical structures of the Oracle 10g Database Server. This course provides an overview of the physical, memory, process, and logical structures that make up the Oracle 10g Database Server. Topics include Oracle architectural components.

Lesson 2: Oracle Server Introduction (0) hour

Oracle Server Introduction teaches you how to define the functions of the Oracle Universal Installer, explain Oracle's administration tools, and describe Oracle's configuration assistants. This course provides information on Oracle's installation and configuration tools. Topics include Oracle server introduction.

Lesson 3: Database Architecture, Creation, and Interfaces (0) hour

Database Architecture, Creation, and Interfaces teaches you how to differentiate between shared server and dedicated server, define and explain Automatic Storage Management (ASM), and describe the different interfaces to the Oracle kernel. This course provides an overview of programmatic interfaces within Oracle and different database architectures (shared server vs. dedicated server). Topics include Database architecture, creation, and interfaces.

Lesson 4: Database Control and Storage Structures (2.0) hours

Database Control and Storage Structures teaches you how to describe Oracle's multithreaded agent technology, explain Oracle's listener technology, and define Oracle's Recycle Bin and Flashback technology. This course provides information on Oracle 10g's multithreaded agent technology, as well as Oracle's new Recycle Bin and Flashback technologies. Topics include Database control: multithreaded agents, Database control: startup and shutdown, Database control: listener, and Database control: database storage structures.

Lesson 5: Managing Users and Schemas (2.0) hours

Managing Users and Schemas teaches you how to define the roles of creating, deleting, and managing users, define the creating, deleting, and managing roles, and define the create, delete, and manage privileges. This course provides the information you need to create, delete, and manage users, roles, and privileges within Oracle 10g. Topics include Managing users, Modifying tables, Constraints, Indexes, and Views.

Lesson 6: Data Management (0) hour

Data Management teaches you how to describe Oracle's SQL*Loader technology, and describe the process used with large-scale data imports and exports using the Data Pump technology. This course provides information pertaining to Oracle SQL*Loader and Data Pump technologies. Topics include Data management.

Lesson 7: PL/SQL (1.0) hour

PL/SQL teaches you how to explain the method used to declare PL/SQL variables, define the PL/SQL syntax, and describe PL/SQL exception handlers. This course provides an overview of PL/SQL, information on how to declare PL/SQL variables, understand PL/SQL syntax, and write PL/SQL exception handlers. Topics include Overview of PL/SQL.

Lesson 8: Database Security Management (0) hour

Database Security Management teaches you how to explain how Oracle uses profiles to manage and secure passwords, describe how Oracle uses a password file to secure DBA access, and define how Oracle uses auditing and audit trails to track access to the database. This course provides information on Oracle 10g's password file, profile, and auditing technologies. Topics include Database security management.

Lesson 9: Oracle Net Services (0) hour

Oracle Net Services teaches you how to define Oracle Net Manager and Oracle listener technologies. This course provides information on Oracle's listener and Net Manager technologies. Topics include Oracle Net services.

Lesson 10: Oracle Shared Server (0) hour

Oracle Shared Server teaches you how to describe Oracle's Shared Server benefits, configuration, and technology. This course provides information on Oracle's Shared Server technology. Topics include Oracle Shared Server.

Lesson 11: Database Performance Monitoring (0) hour

Database Performance Monitoring teaches you how to describe Oracle's statistics gathering, tuning, and monitoring. This course provides information on how Oracle gathers and uses statistics to tune and improve its performance. Topics include Explain database performance monitoring.

Lesson 12: Database Maintenance (0) hour

Database Maintenance teaches you how to explain how Oracle establishes alert thresholds, describe how Oracle gathers baseline metrics, define how to use Oracle tuning and diagnostic advisors, and describe Oracle's automatic workload repository. This course provides information on how Oracle 10g establishes alert thresholds and gathers baseline metrics. It also explains how to use tuning and diagnostic advisors, as well as the Automatic Database Diagnostic Monitor (ADDM). Topics include Database maintenance: alerts and thresholds, and Database maintenance: advisors.

Lesson 13: Database Undo Management (0) hour

Database Undo Management teaches you how to explain Oracle's undo management technology, and describe Oracle's flashback technology. This course explains how to enable and configure Oracle's undo management and flashback technology. Topics include Database undo management.

Lesson 14: Database Locking Conflicts (0) hour

Database Locking Conflicts teaches you how to explain Oracle's row and table locking technology, and describe Oracle's deadlock management technology. This course provides information on Oracle's row and table locking technology, as well as Oracle's deadlock management technology. Topics include Database locking.

Lesson 15: Database Backup and Recovery Concepts (1.0) hour

Database Backup and Recovery Concepts teaches you how to describe Oracle's crash and instance recovery technology, and define how Oracle works with online and archived redo log files. This course provides information on how Oracle performs crash and instance recovery, as well as how Oracle works with redo log files and archived log files. Topics include Database backup and recovery: overview and fundamentals, and Database backup and recovery: redo log files.

Lesson 16: Database Backups (0) hour

Database Backups teaches you how to explain how to perform server-managed (RMAN) backups, and define how to configure and use Oracle's Flash Recovery area. This course provides information on configuring and using Oracle's Flash Recovery area to assist in performing server-managed (RMAN) database backups. Topics include Database backups using RMAN.

Lesson 17: Database Recovery (0) hour

Database Recovery teaches you how to describe how to use Flashback to perform database recovery. This course provides information on how to recover information from your databases and how to use Flashback Drop and Flashback Database as alternatives to point-in-time (incomplete) recovery. Topics include Database recovery.