Oracle Database 11g: Administration Workshop I Release 2, Day 1 (Self-Study Course)

 

Who should attend

  • Database administrators
  • Technical consultants
  • Java developers

Prerequisites

  • Taken Oracle Introduction to SQL course or equivalent experience
  • Oracle Database: Introduction to SQL

Course Objectives

  • Describe Oracle Database Architecture
  • Install Oracle Grid Infrastructure
  • Install and configure Oracle Database 11g
  • Configure Oracle Net services
  • Monitor performance
  • Monitor and administer undo data
  • Manage the database storage structures
  • Create and administer user accounts
  • Manage data concurrency
  • Perform basic backup and recovery of a database

Product Description

  • Exploring the Oracle Database Architecture
    • Oracle Database Architecture Overview
    • Oracle ASM Architecture Overview
    • Process Architecture
    • Memory structures
    • Logical and physical storage structures
    • ASM storage components
  • Installing your Oracle Software
    • Tasks of an Oracle Database Administrator
    • Tools Used to Administer an Oracle Database
    • Installation: System Requirements
    • Oracle Universal Installer (OUI)
    • Installing Oracle Grid Infrastructure
    • Installing Oracle Database Software
    • Silent Install
  • Creating an Oracle Database
    • Planning the Database
    • Using the DBCA to Create a Database
    • Password Management
    • Creating a Database Design Template
    • Using the DBCA to Delete a Database

Price on request