Oracle 10g Administration Online Training Course
Course Topics: 17
Estimated Time Needed: 15.44 hour(s)
Audience: This training course 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).
Course Description: 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.
Click here to watch a preview from one Oracle 10g Administration lesson
Course Tutorials Include:
Oracle 10g Administration: 1 Oracle Architectural Components
Description
This course provides an overview of the physical, memory, process, and logical structures that make up the Oracle 10g Database Server.
Objectives
- 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
- Define the underlying physical, memory, process and logical structures of the Oracle 10g Database Server
Oracle 10g Administration: 2 Oracle Server Introduction
Description
This course provides information on Oracle's installation and configuration tools.
Objectives
- Define the functions of the Oracle Universal Installer
- Explain Oracle's administration tools
- Describe Oracle's configuration assistants
Oracle 10g Administration: 3 Database Architecture, Creation, and Interfaces
Description
This course provides an overview of programmatic interfaces within Oracle and different database architectures (shared server vs. dedicated server).
Objectives
- Differentiate between shared server and dedicated server
- Define and explain Automatic Storage Management (ASM)
- Describe the different interfaces to the Oracle kernel
Oracle 10g Administration: 4 Database Control and Storage Structures
Description
This course provides information on Oracle 10g's multithreaded agent technology, as well as Oracle's new Recycle Bin and Flashback technologies.
Objectives
- Describe Oracle's multithreaded agent technology
- Explain Oracle's listener technology
- Define Oracle's Recycle Bin and Flashback technology
Oracle 10g Administration: 5 Managing Users and Schemas
Description
This course provides the information you need to create, delete, and manage users, roles, and privileges within Oracle 10g.
Objectives
- Define the roles of creating, deleting, and managing users
- Define the creating, deleting, and managing roles
- Define the create, delete, and manage privileges
Oracle 10g Administration: 6 Data Management
Description
This course provides information pertaining to Oracle SQL*Loader and Data Pump technologies.
Objectives
- Describe Oracle's SQL*Loader technology
- Describe the process used with large-scale data imports and exports using the Data Pump technology
Oracle 10g Administration: 7 PL/SQL
Description
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.
Objectives
- Explain the method used to declare PL/SQL variables
- Define the PL/SQL syntax
- Describe PL/SQL exception handlers
Oracle 10g Administration: 8 Database Security Management
Description
This course provides information on Oracle 10g's password file, profile, and auditing technologies.
Objectives
- Explain how Oracle uses profiles to manage and secure passwords
- Describe how Oracle uses a password file to secure DBA access
- Define how Oracle uses auditing and audit trails to track access to the database
Oracle 10g Administration: 9 Oracle Net Services
Description
This course provides information on Oracle's listener and Net Manager technologies.
Objectives
- Define Oracle Net Manager and Oracle listener technologies
Oracle 10g Administration:10 Oracle Shared Server
Description
This course provides information on Oracle's Shared Server technology.
Objectives
- Describe Oracle's Shared Server benefits, configuration, and technology
Oracle 10g Administration:11 Database Performance Monitoring
Description
This course provides information on how Oracle gathers and uses statistics to tune and improve its performance.
Objectives
- Describe Oracle's statistics gathering, tuning, and monitoring
Oracle 10g Administration:12 Database Maintenance
Description
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).
Objectives
- Explain how Oracle establishes alert thresholds
- Describe how Oracle gathers baseline metrics
- Define how to use Oracle tuning and diagnostic advisors
- Describe Oracle's automatic workload repository
Oracle 10g Administration:13 Database Undo Management
Description
This course explains how to enable and configure Oracle\'s undo management and flashback technology.
Objectives
- Explain Oracle's undo management technology
- Describe Oracle's flashback technology
Oracle 10g Administration:14 Database Locking Conflicts
Description
This course provides information on Oracle's row and table locking technology, as well as Oracle's deadlock management technology.
Objectives
- Explain Oracle's row and table locking technology
- Describe Oracle's deadlock management technology
Oracle 10g Administration:15 Database Backup and Recovery Concepts
Description
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.
Objectives
- Describe Oracle's crash and instance recovery technology
- Define how Oracle works with online and archived redo log files
Oracle 10g Administration:16 Database Backups
Description
This course provides information on configuring and using Oracle\'s Flash Recovery area to assist in performing server-managed (RMAN) database backups.
Objectives
- Explain how to perform server-managed (RMAN) backups
- Define how to configure and use Oracle's Flash Recovery area
Oracle 10g Administration:17 Database Recovery
Description
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.
Objectives
- Describe how to use Flashback to perform database recovery
Features
- Flash-based instructional demonstrations applying course concepts.
- Instructional audio with graphics highlighting key points.
- Exercises allow learners to practice in the actual application being studied.
- Supplied sample files include sample documents, application files, programs, and programming code that enable learners to practice with these files, enhancing the learning experience.
- A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
- Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
- Search text enables learners to rapidly search all text within a course to easily retrieve information required.
- Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
- A skill assessment generates a customized learning path based on the results of a pre-test.
- A glossary provides a reference for definitions of unfamiliar terms.
- Bookmarking tracks the learner's progress in a course.