Overview

This Oracle 11g training course will allow the student to gain the skills necessary for day-to-day administration of an Oracle database.

 

Objectives

After completing this course, students will be able to:

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

 

Audience

The primary audiences for this course are: Database administrators, Web server administrators, System administrators, Implementation specialists, Data center support engineers, Senior application designers and developers.

 

Prerequisites

  • Course Oracle Database 11g SQL Fundamentals I

 

Outline

Module 1: Introduction to the Oracle Server Technologies

  • Position the Oracle Product Family
  • Explain Relational Structures
  • Understand the SQL Language
  • Appreciate the DBA’s Role

 

Module 2: Exploring the Database Architecture

  • Describe the Single-Instance Architecture
  • Explain the Memory Structures
  • Describe the Process Structures
  • Summarize the Storage Structures

 

Module 3: Preparing the Database Environment

  • Identify the Tools for Administering an Oracle Database
  • Plan an Oracle Database Installation
  • Install the Oracle Software by Using the Oracle Universal Installer (OUI)

 

Module 4: Creating an Oracle Database

  • Create a Database by Using the Database Configuration Assistant

 

Module 5: Managing the Oracle Instance

  • Describe the Stages of Database Startup and Shutdown
  • Set Database Initialization Parameters
  • Use the Alert Log and Trace Files
  • Use Data Dictionary and Dynamic Performance Views

 

Module 6: Configuring the Oracle Network Environment

  • Configure and Manage the Oracle Network
  • Use the Oracle Shared Server Architecture

 

Module 7: Managing Database Storage Structures

  • Understand Tablespaces and Datafiles
  • Create and Manage Tablespaces
  • Manage Space in Tablespaces

 

Module 8: Administering User Security

  • Create and Manage Database User Accounts
  • Grant and Revoke Privileges
  • Create and Manage Roles
  • Create and Manage Profiles

 

Module 9: Managing Schema Objects

  • Create and Modify Tables
  • Manage Constraints
  • Create Indexes
  • Create and Use Temporary Tables

 

Module 10: Managing Data and Concurrency

  • Manage Data Using DML
  • Identify and Administer PL/SQL Objects
  • Monitor and Resolve Locking Conflicts

 

Module 11: Managing Undo Data

  • Explain the Purpose of Undo
  • Understand How Transactions Generate Undo
  • Manage Undo

 

Module 12: Implementing Oracle Database Security

  • Database Security and Principle of Least Privilege
  • Work with Standard Database Auditing

 

Module 13: Database Maintenance

  • Use and Manage Optimizer Statistics
  • Use and Manage the Automatic Workload Repository
  • Use the Advisory Framework
  • Manage Alerts and Thresholds

 

Module 14: Performance Management

  • Use Automatic Memory Management
  • Use Memory Advisors
  • Troubleshoot Invalid and Unusable Objects

 

Module 15: Backup and Recovery Concepts

  • Identify the Types of Failure That Can Occur in an Oracle Database
  • Describe Ways to Tune Instance Recovery
  • Identify the Importance of Checkpoints, Redo Log Files, and Archived Log Files
  • Overview of Flash Recovery Area
  • Configure ARCHIVELOG Mode

 

Module 16: Performing Database Backups

  • Create Consistent Database Backups
  • Back Up Your Database Without Shutting It Down
  • Create Incremental Backups
  • Automate Database Backups
  • Manage Backups, View Backup Reports, and Monitor the Flash Recovery Area

 

Module 17: Performing Database Recovery

  • Overview of Data Recovery Advisor
  • Use Data Recovery Advisor to Perform Recovery (Control File, Redo Log File, and Data File)

 

Module 18: Moving Data

  • Describe and Use Methods to Move Data (SQL Loader, Directory Objects, External Tables)
  • Explain the General Architecture of Oracle Data Pump
  • Use Data Pump Export and Import to Move Data Between Oracle Databases

 

Module 19: Intelligent Infrastructure Enhancements

  • Use the Enterprise Manager Support Workbench
  • Manage Patches

 

Follow-On

  • Course Oracle Database 11g Administration II

 

Related Certification

  • Oracle Database 11g: Administration I (Exam 1Z0-052)