0345 4506120

Oracle 11g Database Administrators Fundamentals I

This Oracle 11g Database Administrators practical foundation course is an essential toolkit for all DBA's, covering the skills needed to perform Oracle 11g database administration functions within their enterprise.

We don't currently have any courses listed for Oracle 11g Database Administrators Fundamentals I, would you like to view all courses for Oracle?

Learning Objectives

This practical foundation course is an essential toolkit for all Database Administrators covering essential l skills needed by the DBA to perform the Oracle 11g database administration function within their enterprise.

Designed to give attendees hands on experience attendees will explore the Oracle 11g architecture providing knowledge in installing, setting up, patching and monitoring an Oracle 11g Database. This course is relevant to those using both Oracle 11g R2 and R1.


Oracle SQL

Course Content

Managing the Oracle Instance

  • Initialization Parameters
  • Memory Management
  • Automatic Shared Memory Management (ASMM)
  • Database Startup and Shutdown 
  • Viewing the Alert History 
  • Using Trace Files
  • Data Dictionary: Overview

Managing Database Storage

  • Managing Tables / Data Storage. 
  • Setting Storage Parameters 
  • Managing Tablespaces / Data Files 
  • Automatic Storage Management (ASM)
  • SYSTEM and SYSAUX Tablespaces.
  • Creating Additional Tablespaces 
  • Adding Data Files to a Tablespace 
  • Tablespace Online / Offline 
  • Locally Managed Tablespaces 
  • Multiple Block sizes 
  • Bigfile Tablespaces 
  • Temporary Tablespaces 
  • Database Default Tablespaces 
  • Renaming Tablespaces 
  • Renaming and Relocating Data Files 
  • Dropping Tablespaces and Data Files

Managing Undo Data

  • Managing Rollback Segments 
  • Setting up Automatic Undo Management 
  • Monitoring Undo Segments 
  • Undo Tablespace & Sizing 
  • Undo Advisor

Redo Logs and Control Files

  • Managing Redo Logs 
  • Types of Redo Log 
  • Archiving Modes 
  • Log Switches and Checkpoints 
  • Creating Online Redo Log Groups 
  • Creating Log Group Members 
  • Renaming/Relocating Redo Log Members 
  • Dropping Redo Log Groups / Members 
  • Archiving Redo Logs 
  • Specifying Archived Log Destinations 
  • Manual Archiving of Redo Logs 
  • Control Files 
  • Creating/Dropping Control Files

Database Security

  • Key Concepts 
  • Connecting as SYSDBA/SYSOPER 
  • Password Management 
  • Schemas and Synonyms 
  • Dropping Users 
  • Profile Management 
  • Creating / Altering/ Dropping Roles 
  • Enabling and Disabling Roles 
  • Granting / Revoking System  Privileges and Roles.
  • Granting / Revoking Object Privileges


  • Introduction to Utilities 
  • EXP: Runtime EXPORT Command 
  • EXP Parameters and Operation Notes 
  • Restrictions on Export 
  • IMP: Runtime IMPORT Command 
  • IMP Parameters & Operation Notes 
  • Using Data Pump Features 
  • Transportable Tablespaces

SQL Loader

  • Conventional path 
  • Types of file 
  • The control file

Backup and Recovery Procedures

  • Basic Concepts 
  • Backup Guidelines 
  • Performing Full / Partial Back-ups 
  • Control File Backups in ARCHIVELOG mode 
  • Online Backup 
  • Recovery Mechanisms 
  • Types of failure 
  • Appropriate Recovery Procedures 
  • Restoring Damaged Data Files 
  • Restoring Archived Redo Log Files 
  • Restoring a Full Backup 
  • Closed Database Recovery 
  • Open Database Recovery 
  • Incomplete Media Recovery

Enterprise Mgr and Maintenance

  • Database Control 
  • Server Generated Alerts
  • Reacting to Alerts 
  • Advisor Central


  • Introduction to Database Tuning 
  • Gathering Tuning Statistics 
  • Tuning Memory 
  • Balancing Disk I/O 
  • Resource Contention
  • Automatic Workload Repository (AWR)
  • Automatic Database Diagnostic Monitor (ADDM)

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the request service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.


Our Customers Include