Course Description
In this Oracle database administration online training course, Part 2 of a two part series, you will explore how an Oracle Database applies 'grid computing' to multiple computers to provide fast, efficient, secure data storage and manipulation that easily scales to thousands of clients. Students will learn how to install, administer and maintain an Oracle 10g or 11g database in an effective and efficient manner. Training topics such as performance monitoring, database security and backup and recovery techniques are covered. This Oracle training will assist those preparing to take the Oracle Certified Associate (OCA) certification examination.
Once you have completed Oracle 10g/11g Database Administration I Part 2 the next course you will want to take is Oracle 10g/11g Database Administration II Part 1. The Oracle 10g/11g Database Administration II is a 2 part series that will enhance your knowledge further with more advance Oracle database topics. Click here to learn more about Oracle 10g/11g Database Administration II Part 1 and Part 2.
In This Course You Will Learn:
As a result of taking this Oracle course, you will be able to:
-
Explain Oracle's architectural components.
-
Demonstrate how to use Oracle's universal installer and configuration assistants.
-
Identify the different interfaces to an Oracle database.
-
Describe the different database control and storage structures.
-
Explain how to use schema and user management tools.
-
Contrast the different techniques for importing data to an Oracle database and exporting data from an Oracle database.
-
Describe PL/SQL declarations, code and exceptions.
-
Discuss Oracle's password security and database auditing features.
-
Configure Oracle's default user account features.
-
Configure and tune Oracle's Listener and Net Services features.
-
Learn how to establish, tune and monitor Oracle's Shared Server configuration.
-
Explain how to manually and automatically monitor the performance of an Oracle database.
-
Describe how to use Oracle's advisors to help tune and monitor database performance.
-
Show how to tune and administer Oracle's database undo management.
-
Discover how Oracle detects and resolves locking conflicts.
-
Learn the roles of control files, data files and redo log files in database backup and recovery.
-
Describe the implications of running your database in NOARCHIVELOG mode and ARCHIVELOG mode on database backup and recovery.
-
Discuss the different types of database backups.
-
Differentiate the differences between user-managed and server-managed backups.
-
Contrast the differences between database restoration and database recovery.
-
Illustrate the importance of database incarnations in database recovery.
Prerequisites
You need to have equivalent Oracle 9i database experience and have taken Oracle 10g/11g Database Administration I Part 1 or have taken the following GogoTraining courses:
Outline
Module 00: Oracle 10g/11g Database Administration I Part 2 Online Training - Course Introduction
Module 21: Oracle Shared Server, Part One
• Architecture
• Benefits and Features
Module22: Oracle Shared Server, Part Two
• Oracle Shared Server Configuration
• Tuning the Oracle Shared Server
• Monitoring the Oracle Shared Server
Module 23: Database Performance Monitoring, Part One
• Database Statistics: Manual vs. Automatic
• Analyzing Objects
Module 24: Database Performance Monitoring, Part Two
• Validating Database Structure
• Validating System Objects
Module 25: Database Maintenance, Part One
• Database Maintenance Techniques: What are Reasonable Measurement Values?
Module 26: Database Maintenance, Part Two
• How Can We Use Advisors?
Module 27: Database Maintenance, Part Three
• How Can We Use the Automatic Database Diagnostic Monitor (ADDM)?
Module 28: Database Maintenance, Part Four
• How Can We Use the Workload Repository?
Module 29: Database Undo Management, Part One:
• Definition of Database Undo Management
• Configuration of Database Undo Management
Module 30: Database Undo Management, Part Two
• Administration of Database Undo Management
Module 31: Database Locking Conflicts, Part One
• Detecting Database Locking Conflicts
• Database Locking Modes
Module 32: Database Locking Conflicts, Part Two
• Resolving Database Locking Conflicts
Module 33: Database Backup and Recovery Concepts, Part One
• Control Files
• Data Files
• Redo Log Files
Module 34: Database Backup and Recovery Concepts, Part Two
• Log Writer Processes
• Archiver Processes
Module 35: Database Backup and Recovery Concepts, Part Three
• NOARCHIVELOG mode
• ARCHIVELOG mode
• Implications of ARCHIVELOG mode and Automatic Archival
Module 36: Database Backups, Part One
• Constituent Elements: Redo Logs; Control Files; Data Files
Module 37: Database Backups, Part Two
• Consistent Backups vs. Inconsistent Backups
• Full Backups vs. Incremental Backups
Module 38: Database Backups: Part Three
• Performing User-Managed Backups
• Performing Server-Managed Backups (RMAN)
Module 39: Database Recovery, Part One
• Overview and Fundamentals
• Restoration
• Recovery
Module 40: Database Recovery, Part Two
• Incarnations
• Log Sequence Numbers
Module 41: Oracle 10g/11g Database Administration I Part 2 Online Training - Course Summary
Certification
Oracle 10g/11g Database Administration I Part 2 online training is part of a two-course series that helps you to prepare for Oracle's exam 1Z0-052. This course maps to Oracle's course, Oracle Database 11g: Administration I. When you pass exam 1Z0-052, you have completed a portion of the requirements towards the Oracle Database 11g Administrator Certified Associate certification.
For more information about the certification requirements, pricing, and locations select the link in the related training section.