• Decrease font size
  • Default font size
  • Increase font size

Oracle 10g/11g Database Administration 1, Part 2

 Print E-mail

Try a Self-Paced Training Module Now!Visit GogoTraining and Buy this Oracle 10g/11g Database Administration 1, Part 2 Self-Paced Training Technical Course Now!

Start Oracle Administration Training Today!

 

  • Dashcourses has partnered with GogoTraining to bring you this Self-paced Course
  • Set your own training schedule
  • Watch as many times as you want 24/7 for 60 days following purchase
  • Find out what Dashcourses' self-paced training is all about with no obligation - download Silverlight and View a Module
  • Our self-paced training modules are viewable in Internet Explorer, Firefox and Safari

Training Description

This course explores how Oracle Database applies 'grid computing' to multiple computers to provide fast, efficient, secure data storage and manipulation that easily scales to thousands of clients. In this course, students will learn how to install, administer and maintain an Oracle 10g or 11g database in an effective and efficient manner. Topics such as the interaction among Oracle components, an understanding of Oracle's architecture and user management are covered. Students will learn to install, administer and maintain an Oracle 10g or 11g database in an effective and efficient manner. Topics such as performance monitoring, database security and backup and recovery techniques are covered. This course will assist those preparing to take the Oracle Certified Associate (OCA) certification examination. This course will assist those preparing to take the Oracle Certified Associate (OCA) certification examination.

Training Objectives

As a result of taking this training, students 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

Previous experience with administering Oracle 9i databases OR successful completion of 40-hour "Introduction to Oracle" and 40-hour "Oracle PL/SQL" courses.

Outline - Part 1

Module 00: Course Introduction

Module 01: Architectural Components, Part One:

  • Physical Structure
  • Memory Structure
  • Process Structure
  • Logical Structure

Module 02: Architectural Components, Part Two:

  • Stages of a SQL Statement
  • Defining the Database, Instance and Server

Module 03: Administration and Installation Tools for Oracle Server, Part One:

  • Administration Tools
  • The Oracle Universal Installer

Module 04: Administration and Installation Tools for Oracle Server, Part Two:

  • SQL*Plus
  • Configuration Assistants

Module 05: Database Architecture and Creation

  • Database Architecture
  • Database Creation

Module 06: Database Interfaces

  • Database Interfaces

Module 07: Database Control

  • The Console
  • The Listener
  • Agents
  • Instance
  • Controlling the Database

Module 08: Storage Structures

  • Tablespace Creation
  • Tablespace Management
  • Tablespace Information

Module 09: User Management

  • Managing Users
  • Managing Roles
  • Managing Privileges

Module 10: Schema Object Management

  • Managing Tables
  • Managing Constraints
  • Managing Indexes
  • Managing Views

Module 11: Data Management using SQL*Loader

  • Using SQL*Loader to Import Information

Module 12: Data Management Using the Data Pump

  • Data Pump Export
  • Data Pump Import

Module 13: PL/SQL Overview

  • PL/SQL Declarations
  • PL/SQL Code

Module 14: PL/SQL Exceptions

  • Creating Exceptions
  • Handling Exceptions
  • Built-In Exceptions

Module 15: Database Security Management, Part One

  • Managing Default User Accounts

Module 16: Database Security Management, Part Two

  • Password Security Features

Module 17: Database Security Management Part Three

  • Database Auditing

Module 18: Oracle Net Services, Part One

  • Oracle Net Services Overview and Concepts
  • Oracle Listener Creation and Configuration

Module 19: Oracle Net Services, Part Two

  • Oracle Net Manager
  • Using TNSPING

Module 20: Summary Part One

Outline - Part 2

Module 21: Oracle Shared Server, Part One

  • Architecture
  • Benefits and Features

Module 22: 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: Course Summary