Oracle Database 11g Administration I

Course:  OR11A1
Duration:  5 Days
Level:  I
Course Summary

Oracle 11g Database Management Workshop course provides an educational starting point for administration of the Oracle database. The course begins with an in-depth discussion of the database architecture, then installing the Oracle software and creating an Oracle database are covered.

The Oracle instance, background processes, the SGA and memory structures are explored. As well as administering the initialization parameter file and the procedures for database startup and shutdown. Various models of data concurrency and consistency and alternative isolation levels are explained along with their uses.

A large portion of the class covers common administration tasks such as managing the use of disk space through data files, tablespaces, extents, blocks and rows, the UNDO tablespace and the online redo log.

The effective use of indexes is presented and how Oracle uses indexes to improve query performance.

Since so much access to Oracle’s features is based upon it, a comprehensive overview of the PL/SQL language is conducted, including stored procedures and database triggers.

All aspects of database user creation, maintenance and management are provided. Also including database security and controlling user access to database objects and resources.

There is a review of Oracle’s approach to the “self-tuning database” and the SQL Access and SQL Tuning advisors.

The Oracle data utilities SQL*Loader, Import data pump and Export data pump are described.

Finally an overview of backup and recovery concepts is given along with simple backup and recovery procedures.

« Hide The Details
Topics Covered In This Course

Part 1 Oracle Architecture

  • The instance vs. the database
  • The System Global Area (SGA)
  • The critical background processes

Part 2 Data Dictionary

  • Dictionary table scope
  • Dynamic performance views (V$ views)

Part 3 Installing Oracle 11g Enterprise Edition

  • What the installer does
  • Preparing for an installation
  • Running Oracle Universal Installer (OUI)

Part 4 Database Creation

  • Database creation options
  • Database Configuration Assistant (DBCA) capabilities
  • Database creation steps

Part 5 Database Startup and Shutdown

  • What happens at startup
  • The different startup modes
  • What happens at shutdown
  • The different shutdown options

Part 6 Managing the Initialization Parameter file

  • How the initialization parameter file (‘init.ora’) is used
  • The differences between PFILE and SPFILE
  • Managing PFILEs and SPFILES

Part 7 Managing the System Global Area (SGA)

  • Major components of the SGA
  • Automatic memory management
  • Some critical SGA related parameters

Part 8 Concurrency and Consistency

  • What these two words mean
  • How Oracle manages concurrency and consistency
  • What part UNDO plays
  • Alternative isolation levels

Part 9 Managing Database Storage

  • The parts of the “database”
  • Managing datafiles
  • Managing online redo logs
  • Managing control files

Part 10 Managing UNDO

  • The uses of UNDO data
  • The UNDO tablespace

Part 11 PL/SQL Overview

  • Creating PL/SQL anonymous blocks
  • Creating PL/SQL stored procedures
  • Creating PL/SQL triggers

Part 12 Managing Database Users

  • Creating database users
  • Options at user creation
  • Managing user space allocations

Part 13 Controlling User Access

  • Working with object and system permissions
  • Using ROLEs
  • Controlling resource consumption with PROFILEs

Part 14 Managing Database Security

  • User password management
  • Ensuring password complexity

Part 15 Creating Tables

  • Oracle datatypes
  • Creating tables with CREATE TABLE

Part 16 Maintaining Tables

  • What table characteristics can be changed
  • Modifying table structure with ALTER TABLE
  • Eliminating tables with DROP TABLE

Part 17 Creating Constraints

  • The kinds of constraints
  • How referential integrity is provided
  • Inline vs. out-of-line syntax

Part 18 Maintaining Constraints

  • How can constraints be changed
  • Deferring constraint enforcement
  • Enabling and disabling constraints

Part 19 Effective Indexing

  • Creating B*-Tree indexes
  • Utilizing “super” indexes
  • Monitoring index usage

Part 20 Creating Other Schema Objects

  • Creating sequences
  • Creating views
  • Creating synonyms

Part 21 Working with Statistics

  • What kind of statistics are collected
  • How Oracle uses statistics
  • Operating on statistics with DBMS_STATS

Part 22 Self-managing Database

  • Understanding Oracle’s “Intelligent Infrastructure”
  • The metrics being saved in Automated Workload Repository (AWR)
  • What the Automated Database Diagnostic Monitor (ADDM) does
  • Other self-managing and self-tuning activities

Part 23 Loading and Moving Data

  • Loading data with SQL Loader
  • Creating data exports with Export Data Pump (expdp)
  • Manipulating data exports with Import Data Pump (impdp)

Part 24 Backup and Recovery Concepts

  • Backup and recovery fundamentals
  • Types of backups
  • Recovery and restore
What You Can Expect

Oracle Database 11g: Administration I class enables the student participants to acquire and develop key skills to effectively administer an Oracle11g RDBMS. The participants will learn to configure and start up the Oracle instance and memory components and create the Oracle database Enterprise Manager repository. The student participants will create physical and logical database objects, utilize many of the advanced features of the Oracle Enterprise Manager and the integrated Oracle Data Dictionary to monitor and maintain the Oracle11g database. In addition, they will be introduced to Oracle Backup and Recovery using the RMAN utility and also learn how to secure access to the Oracle database objects with privileges, roles and profiles. Many exercises and lab sessions reinforce the learning objectives and provide participants the opportunity to gain practical hands-on experience.

This class provides preparation for the OCP Oracle Database 11g: Administration I 1Z0-052 test. Oracle Corporation suggests that candidates also have six months of hands-on experience before testing and undertake substantial self-study.

Who Should Take This Course

Oracle developers and novice DBAs

Oracle developers and DBAs wishing to ‘back fill’ gaps in their expertise

Oracle APEX, Forms and Reports developers

Technical managers needing Oracle expertise for project administration

Recommended Prerequisites

Skill with GUI interfaces

Data processing background

An understanding of SQL is required to succeed in this class

Training Style

Instructor Led with typically 50% lecture and 50% lab.

« Hide The Details
Related Courses
Code Course Title Duration Level
Oracle12c -18c New Features For Administrators (Five Days)
5 Days
Oracle BI 11g - System Administration
4 Days
Oracle12c Release 1 & 2 New Features For Administrators
5 Days
Oracle12c New Features For Administrators
5 Days
Oracle Database 11g Administration II & Backup and Recovery Workshop
4 Days

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]