Oracle 10g/11g Database Administration I Part 2

Videos

There are several great features that come with this course. The Course Transcript tracks your progress and allows you to pick up where you left off. You can view or email your transcript. The course comes with documentation found in Downloads Tab. You have access to the course and all videos for 1 year. Full screen viewing option available (see icon on bottom right corner of video).

Start Learning Oracle 10g/11g Database Administration I Part 2 Today!

List Price: $700 Your Price: $497

Video Title	Minutes
00: Course Introduction	6
21: Oracle Shared Server, Part One	23
22: Oracle Shared Server, Part Two	32
23: Database Performance Monitoring-Part One	28
24: Database Performance Monitoring, Part Two	23
25: Database Maintenance, Part One	23
26: Database Maintenance, Part Two	16
27: Database Maintenance, Part Three	31
28: Database Maintenance, Part Four	17
29: Database Undo Management, Part One	21
30: Database Undo Management, Part Two	19
31: Database Locking Conflicts, Part One	15
32: Database Locking Conflicts, Part Two	21
33: Database Backup and Recovery Concepts, Part One	42
34: Database Backup and Recovery Concepts, Part Two	24
35: Database Backup and Recovery Concepts, Part Three	10
36: Database Backups, Part One	11
37: Database Backups, Part Two	17
38: Database Backups: Part Three	34
39: Database Recovery, Part One	40
40: Database Recovery, Part Two	27
41: Course Summary & Evaluation	4
Total:	8 Hours 4 Minutes

Start Learning Oracle 10g/11g Database Administration I Part 2 Today!

List Price: $700 Your Price: $497

Downloads

NOTE: Click link then select "Save"

• Student Guide
• Exercise Guide
• Oracle Installation Guide

Related Links

• Course Survey
• Course Labs
• Oracle Certification Requirements
• Exam Pricing and Locations

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g Database Administration I Part 2 Today!

List Price: $700 Your Price: $497

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.

Related Training

• Course: Oracle 10g/11g Database Administration I - Part 1
• Course: Oracle 10g/11g Database Administration II - Part 1
• Course: Oracle 10g/11g Database Administration II - Part 2
• Podcast: Shared Server In Oracle 10g And 11g
• Podcast: Solving Oracle 10g and 11g Performance Problems Before They Occur
• Podcast: Advising the Oracle
• Podcast: Live Locks and Dead Locks in Oracle

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g Database Administration I Part 2 Today!

List Price: $700 Your Price: $497

Oracle 10g/11g Database Administration I Part 2 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

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g Database Administration I Part 2 Today!

List Price: $700 Your Price: $497

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:

• Oracle 10g/11g: Introduction to SQL
• Oracle 10g/11g: Advanced SQL
• Oracle 11g PL/SQL Programming Part 1
• Oracle 11g PL/SQL Programming Part 2
• Oracle 10g/11g Database Administration I Part 1

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g Database Administration I Part 2 Today!

List Price: $700 Your Price: $497

Hardware/Software Requirements

Hardware:

• Java Runtime Environment (JRE)
• Memory requies 32 MB
• 200 MB disk space

Software:

• Oracle Univeral Installer 11g Release 2 (11.2)-Detailed set up will be provided with the course.

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g Database Administration I Part 2 Today!

List Price: $700 Your Price: $497

Objectives

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.

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g Database Administration I Part 2 Today!

List Price: $700 Your Price: $497

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.

For more information, contact us or call 1-877-546-4446

Start Learning Oracle 10g/11g Database Administration I Part 2 Today!

List Price: $700 Your Price: $497