Oracle 11g Database Administrators Fundamentals I

Course code: O1110

5 days £2,500.00

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.

Course content >

Who Should Attend?

Anyone who needs to install, administer, monitor, patch and support an Oracle 11g R1 or R2 database.

  • Analyst/Designers
  • Analyst/Programmers
  • Database Administrators
  • Support Technicians


Attendees should have a understanding of relational database concepts and operating system knowledge in addition to attending (or have the equivalent knowledge) of Oracle 11g SQL;

Course Contents

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.

Built on continuous hands on labs iTrain's course is an essential toolkit for all Database Administrators covering the essential 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.

Training Course Contents

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)

Follow on course: Oracle 11g Database Administrator Fundamentals Part II

Contact us for more information