Oracle 11g Administrator Class

Overview

The Oracle Database 11g: Administration course will prepare you to become certified as an Oracle Database 11g Administrator Certified Associate as well as laying the foundation for the Oracle Database 11g Administrator Certified Professional certification. This course will cover some of the more in-depth database administration topics, such as configuration, security, backups, and recovery. These topics, along with a strong emphasis on database management, will prepare you for the exam.

Target Audience:

This course is for anyone who is preparing for the Oracle Database 11g Administration I (1Z0-052) exam.

Pre-requisites:

Database administrators, developers with data management responsibilities and others involved in the management or deployment of Oracle 11g databases. Oracle Database 11g basics, or equivalent experience will be of advantage.

Course Outline:

Overview of Oracle 11g Administration

Your responsibilities as an Oracle 11g DBA

Configuring the instance and database

Maintaining security

Balancing user requirements and resources

Ensuring database availability

 

The Oracle 11g Architecture

Processing transactions with the server

Identifying types of Oracle 11g processes and memory structures

Determining database file structure

Archiving redo log information

Sizing the Result Cache for optimising repeated queries

 

Building an Oracle 11g Database

Creating the database

Setting the initialisation parameters

Simplifying memory allocation with memory targets

Establishing network connectivity

Converting from text-based to server parameter files

Configuring control files and redo log files

 

Starting and stopping the Database

Mounting and opening the database with SQL*Plus

Authenticating connections having SYSDBA privilege

Closing the database and shutting down the instance

 

Automating Database Management

The Oracle Enterprise Manager architecture

Navigating the graphical interface

Comparing command-line and graphical techniques

 

Administering with Database Control

Equipping Database Control to manage additional databases

Setting thresholds and generating alerts

Verifying changes in the data dictionary

Performing privilege management

 

Performing Flashback Operations

Managing space for rollback and read consistency

Configuring UNDO tablespaces

Monitoring expansion of rollback segments

Swapping to an alternative UNDO tablespace

 

Resetting Data to recent points in time with Flashback

Tracking changes to data values with row history

Obtaining transaction history with Flashback Transaction

Performing efficient recovery of data with Flashback Table

Retrieving dropped tables and dependent objects from the recycle bin

 

Securing the Database

Establishing user accounts

Authenticating users with sophisticated password checking

Allocating space quotas for user schemas

Limiting resource usage through profiles

 

Enforcing Security

Granting and revoking system and object privileges

Simplifying privilege management with roles

Preventing changes to read-only tables

 

Controlling Database Storage

Defining logical and physical structures

Creating, altering, and dropping tablespaces

Handling sort data efficiently with temporary tablespaces

Comparing traditionally managed and Oracle-managed files

 

Configuring Storage Patterns for Database Objects

Structuring data and index segments

Sizing database objects by defining extents and block occupancy

Eliminating row migration with PCTFREE and Data Pump

Compressing table data to conserve storage

Shrinking tables and indexes online to regain space

 

Partitioning to Support Administration and Availability

Creating table partitions and subpartitions

Selecting partitioning methods: range, list, hash, interval

Partitioning tables based on virtual columns

Setting up automatic partition allocation

Referencing the partitioning method in child tables

Administering partitions with merge, split, add and drop

 

Maintaining Index Partitions

Maximising performance with local and global indexes

Monitoring index partition usage

Rebuilding unusable indexes

 

Duration: 

5 Days