Oracle Database 11g: Administration Workshop I (Self-Study Course)


Who should attend

  • Database administrators
  • Database designers
  • Developers


  • A working knowledge of SQL

Course Objectives

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

Product Description

  • Oracle Database 11g: Database Architecture and Installation
    • Exploring the Oracle Database 11g Architecture
    • Preparing the Database Environment
  • Oracle Database 11g: Database Creation, Instance Management, and Connectivity
    • Database Creation and Instance Management
    • Configuring the Oracle Network Environment
  • Oracle Database 11g: Storage Structures and User Security
    • Managing Storage Structures
    • Administering User Security
  • Oracle Database 11g: Managing the Schema, Data, and Concurrency
    • Managing Schema Objects
    • Managing Data and Concurrency
  • Oracle Database 11g: Managing Undo Data, Database Security, and Maintenance
    • Undo Data and Database Security
    • Maintaining Statistics
  • Oracle Database 11g: Performance Monitoring, Recovery Concepts and Backup
    • Performance Monitoring and Recovery
    • Performing Database Backups
  • Oracle Database 11g: Recovering, Moving, and Enhancing the Oracle Database
    • Data Recovery and Movement
    • Enhancing Database Capabilities

Price on request