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

Oracle 10g/11g Database Administration 1

 Print E-mail

Public Training Course - Taught Live OnLine

Notify Me when Oracle 10g/11g Database Administration is next offered!Training Description

This course will give students a firm foundation in basic administration of an Oracle 11g Database. Participants learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Participants will create an operational database and effectively manage the various structures in an efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.

Audience

  • Database Administrators, Developers, Designers, Technical Administrator

Prerequisites

  • The course “Oracle Database 11g: Introduction to SQL” or working knowledge of SQL

Course Objectives

  • Describe the Oracle 11g Database Architecture
  • Install and configure Oracle Database 11g
  • Configure Oracle Net services
  • Create and administer user accounts
  • Manage database storage structures
  • Perform basic backup and recovery of a database
  • Manage users and schemas
  • Manage security using system privileges
  • Manage data and concurrency
  • Monitor and administer undo data
  • Backup and recover a database
  • Monitor performance
  • Use the database diagnostic monitor

Topics

Oracle Database Architecture

  • Oracle Database Architecture Overview
  • Interacting with an Oracle Database
  • Process Architecture
  • Database Storage Architecture
  • Logical and Physical Database Structures
  • Tablespaces and Data Files
  • SYSTEM and SYSAUX Tablespaces
  • Segments, Extents, and Blocks

Installation Issues

  • Tasks of an Oracle DBA
  • Tools Used to Administer an Oracle Database
  • Installation: System Requirements
  • Optimal Flexible Architecture (OFA)
  • Setting Environment Variables
  • Oracle Universal Installer (OUI)
  • Database Configuration Options

Creating an Oracle Database

  • Planning Considerations
  • Configuring the Listener
  • Using the DBCA to Create a Database
  • Creating a Database Design Template
  • Using DBCA For Additional Tasks

The Oracle Instance

  • Oracle Enterprise Manager (DBControl)
  • Initialization Parameters
  • Startup and Shutdown the Database
  • Viewing the Alert Log
  • Using Trace Files
  • Overview of the Data Dictionary

Configuring Oracle Network Services

  • Oracle Net Services & Listener
  • Tools for Configuring and Managing the Oracle Network
  • Net Services Administration Pages
  • Naming Methods
  • Directory Naming
  • Shared Server

Managing Database Storage

  • How Data Is Stored
  • Database Block
  • Tablespaces
  • Tablespaces in the Demo Database
  • Oracle Managed Files (OMF)
  • ASM: Concepts

User Security

  • Database User Accounts
  • Predefined Accounts: SYS and SYSTEM
  • Administrator Authentication
  • Using User-Defined Roles
  • Using Predefined Roles
  • Manage Passwords
  • Assigning Quota to Users

Managing Schema Objects

  • Schema Definition
  • Access Schema Objects
  • Data Types in the Oracle 11g Database
  • Creating and Modifying Tables
  • Define and Maintain Data Integrity
  • Indexes & Views
  • Sequences
  • Temporary Tables

Managing Data and Concurrency

  • Transaction Processing
  • PL/SQL
  • Functions, Procedures, Packages & Triggers
  • Data Concurrency
  • Understand Locking Mechanisms

Managing Undo Data

  • How Transactions Use Undo Data
  • Undo Data Versus Redo Data
  • Configuring Undo Retention
  • Guaranteeing Undo Retention
  • Using the Undo Advisor
  • Viewing System Activity

Implementing Oracle Database Security

  • Describe Oracle 11g’s Principle of Least Privilege
  • Monitoring for Compliance
  • Fine-Grained Auditing
  • DBA Auditing
  • Security Updates
  • Applying Security Patches

Database Maintenance

  • Collecting Statistics for the Optimizer
  • Automatic Workload Repository (AWR)
  • Automatic Database Diagnostic Monitor (ADDM)
  • Advisory Framework
  • Server-Generated Alerts
  • Responding to Alerts
  • 11g new Diagnostic parameter

Performance Considerations

  • Managing Memory
  • Enabling Automatic Memory Management (AMM)
  • Using Memory Advisors
  • Dynamic Performance Statistics
  • Troubleshooting and Tuning Views
  • Identify Invalid and Unusable Objects

Backup and Recovery Concepts

  • Statement Failure
  • User Error
  • Media Failure
  • Understanding Instance Recovery
  • Phases of Instance Recovery
  • Using the MTTR Advisor
  • Archive Log Files

Performing Database Backups

  • Overview of Backup Options
  • Oracle Secure Backup
  • User-Managed Backup
  • Configuring the Flash Recovery Area
  • Using Recovery Manager (RMAN)
  • Configuring Backup Settings
  • Backing Up the Control File to a Trace File

Performing Database Recovery

  • Opening a Database
  • Listing Data Failures
  • Data Recovery Advisor
  • Recover a Control File
  • Recover a Redo Log File

Moving Data

  • Overview of SQL*Loader
  • Overview of Data Pump
  • Overview of Directory Object
  • Using Enterprise Manager to