Skip to main Content

Oracle Database 11g: Administration Workshop I (D50079GC10)

  • Course Code O11GAWS1
  • Duration 5 days

Additional Payment Options

  • GTC 29 inc. VAT

    GTC, Global Knowledge Training Credit, please contact Global Knowledge for more details

Public Classroom Price

SAR10,125.00

excl. VAT

Request Group Training Add to Cart

Course Delivery

This course is available in the following formats:

  • Company Event

    Event at company

  • Public Classroom

    Traditional Classroom Learning

  • Virtual Learning

    Learning that is virtual

Request this course in a different delivery format.

Course Overview

Top
  • This course is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students 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. Students learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.
  • Manage users
    Manage storage structures
    Backup and Recovery
    Install and configure an Oracle database

Course Schedule

Top

Target Audience

Top
  • Database Administrators
  • Support Engineer
  • Developer
  • Technical Administrator
  • Database Designers

Course Objectives

Top
  • Describe Oracle Database Architecture
  • 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
  • Backup and recover a database
  • Monitor performance
  • Use the database diagnostic monitor

Course Content

Top
  • Exploring the Oracle Database Architecture
  • Preparing the Database Environment
  • Creating an Oracle Database
  • Managing the Oracle Instance
  • Configuring the Oracle Network Environment
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Schema Objects
  • Managing Data and Concurrency
  • Managing Undo Data
  • Implementing Oracle Database Security
  • Database Maintenance
  • Performance Management
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Moving Data
  • Enhancing Database Capabilities

Course Prerequisites

Top
  • Required Prerequisites:
    Working knowledge of SQL
  • Suggested Prerequisites:
    Oracle Database 11g: Introduction to SQL