The goal of this course is to teach Database Administrators how to install the Oracle Database 11g software and perform the tasks required to manage an Oracle database. Enterprise Manager is used throughout to teach students how to quickly accomplish the required task. Emphasis is on the self-managing capabilities and automatic features of Oracle Database 11g. This course is targeted towards Database Administrators of small to medium sized businesses.
Learn To:

• Install Oracle Database 11g software and create a database
• Use Enterprise Manager Database Control to manage the database
• Manage database storage structures and schema objects
• Administer users and security
• Back up and recover the Oracle database
• Monitor the database and use the Advisors

Course Objectives:

• Install Oracle Database 11g
• Create a database
• Use Enterprise Manager Database Control
• Configure and manage the Oracle Network environment
• Manage database storage structures
• Administer users and security
• Manage schema objects
• Back up and recover the database
• Monitor the database
• Use the Advisors
• Use the Support Workbench
• Manage the Oracle Database software

Course Topics:

Overview of Oracle Database Administration

• Structure of a Relational Database
• SQL
• Components of an Oracle Instance and Database
• Basic Tasks of an Oracle DBA
• Tools Used to Administer an Oracle Database

Installing Oracle Database and Creating the Database

• Using the Oracle Universal Installer to Install the Oracle Database Software
• Using DBCA to Create a Database
• Using DBCA to Manage Templates

Using Oracle Enterprise Manager Database Control and SQL*Plus

• Overview of Administering the Database Using Enterprise Manager
• Starting the Enterprise Manager Console Process
• Granting Enterprise Manager Administrative Privileges
• Setting Enterprise Manager Preferred Credentials
• Using SQL*Plus to Access Your Database

Configuring the Oracle Network Environment

• Tools for Configuring and Managing the Oracle Network
• Using the Enterprise Manager Net Services Administration Page
• Managing the Oracle Net Listener with Enterprise Manager
• Using the Listener Control Utility
• Oracle Net Naming Methods
• Using Enterprise Manager to Configure Local Naming
• Using Oracle Net Manager to Configure Local Naming

Managing the Oracle Instance

• Oracle Instance Management
• Starting the Instance and Opening the Database
• Viewing and Modifying Initialization Parameters
• Managing Memory Components
• Viewing the Alert Log

Managing Database Storage Structures

• Oracle Database Structures
• Multiplexing the Redo Log
• Enlarging the Database
• Creating, Modifying, and Dropping Tablespaces
• Reclaiming Space in Your Tablespace
• Managing Undo Data
• Using the Undo Advisor to Compute the Minimum Undo Tablespace Size

Administering Users and Security

• Overview of Users and Security
• Creating, Modifying, and Dropping Users
• Unlocking a User Account and Resetting the Password
• Setting the Password Policy
• Administering Privileges and Roles

Managing Schema Objects

• Creating, Modifying, and Dropping Tables
• Understanding Data Integrity and Defining Constraints
• Viewing the Contents of a Table
• Creating and Dropping Indexes
• Managing Views
• Managing Program Code Stored in the Database
• Managing Access to Schema Objects
• Loading Data

Performing Backup and Recovery

• Backup, Restore, and Recovery Concepts
• Configuring the Database for Backup and Recovery
• Configuring Backup Settings
• Backing Up the Database
• Using the Oracle-Suggested Backup Strategy
• Performing Backup Maintenance Tasks
• Using Oracle Advised Recovery to Recover the Database
• Performing Flashback Table and Flashback Drop

Monitoring the Database and Using the Advisors

• Monitoring General Database State, Workload, and Performance
• Setting Metric Thresholds
• Setting Up Direct Alert Notification
• Viewing ADDM Performance Analysis and Responding to Findings
• Using the SQL Tuning and SQL Access Advisors
• Configuring the Automatic SQL Tuning Advisor
• Viewing Automatic SQL Tuning Results

Investigating, Reporting, and Resolving Problems

• Using the Enterprise Manager Support Workbench
• Workflow for Investigating, Reporting, and Resolving a Problem
• Performing the Tasks to Investigate and Report a Critical Error

Managing Oracle Database Software

What you will learn:
In this course, the concepts and architecture that support backup and recovery, along with the steps of how to carry it out in various ways and situations, are covered in detail. This includes how to define and test your own backup and recovery scenarios.
Also, the students learn to manage memory effectively and to perform some performance evaluation and tuning tasks, including using some of the advisors. All types of flashback technologies, scheduling jobs inside and outside of the database, and controlling system resource usage are covered. Topics are reinforced with hands-on practices.
Learn To:

Course Objectives:

Course Topics:

Database Architecture and ASM

Configuring for Recoverability

Using the RMAN Recovery Catalog

Configuring Backup Specifications

Creating Backups

Performing User-Managed Backup and Recovery

Using RMAN to Perform Recovery

Using RMAN to Duplicate a Database

Performing Tablespace Point-in-time Recovery

Monitoring and Tuning RMAN

Using Flashback Technology

Using Flashback Database

Diagnosing the Database

Managing Memory

Managing Database Performance

Using the Segment Advisor

Managing Resources

Automating Tasks with the Scheduler

Administering the Scheduler

Globalization

What you will learn:

This course is designed to give students a firm foundation in basic administration of Oracle Database 11g. In this class, students learn how to install and maintain Oracle Database 11g. Students gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practices.

Course Objectives:

Course Topics:

Exploring the Oracle Database Architecture

Preparing the Database Environment

Creating an Oracle Database

Managing the Oracle Instance

Configuring the Oracle Network Environment

Managing Database Storage Structures

Administering User Security

Managing Schema Objects

Managing Data and Concurrency

Managing Undo Data

Implementing Oracle Database Security

Database Maintenance

Performance Management

Backup and Recovery Concepts

Performing Database Backups

Performing Database Recovery

Moving Data

Enhancing Database Capabilities

What you will learn:
Students learn how to use Oracle Database 11g automatic tuning features such as SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor, and practice these tuning methods. The course focuses on the tuning tasks expected of a DBA: reactive tuning of SQL statements, maintaining SQL statement performance, and tuning the Oracle Database Instance components. Throughout the course, students practice the art of tuning an Oracle Instance through a series of workshops. The methodology is practiced in the workshops rather than taught.
Course Objectives:

Course Topics:

Introduction

Monitoring With Basic Tools

Using Automatic Workload Repository

Identifying the Problem

Identifying Problem SQL Statements

Influencing the Optimizer

SQL Plan Management

Change Management

Using Metrics and Alerts

Using AWR Based Tools

Monitoring an Application (Using Services)

Baselines

Tuning the Shared Pool

Tuning the Buffer Cache

Tuning PGA and Temporary Space

Automatic Memory Management

Tuning Block Space Usage

Tuning I/O

: Performance Tuning: Summary

Using Statspack

What you will learn:

This course is designed to introduce the students to Oracle Application Express 3.0. The course covers various Application Express components and wizards to build applications and database objects that are easy to deploy. The students learn how to build forms and reports and incorporate different types of items and shared components. Creating and utilizing various navigation components as well as session management and debugging are discussed. In addition, students incorporate access control, and session protection to enforce application security. Once the application is complete, students learn how to define their packaged application and export the application. Students will also use all the Utilities and Report capabilities that Oracle Application Express provides to build a robust application.

Course Objectives:

Course Topics:

Introducing Oracle Application Express

Interacting with the Database by Using SQL Workshop

Building an Application

Creating Reports

Creating Forms

Working with Pages and Regions

Adding Items and Buttons

Understanding Session State and Debugging

Including Page Processing

Adding Shared Components That Aid Navigation

Adding Other Shared Components

Displaying Dynamic Content

Working with Themes and Templates

Administering Oracle Application Express Workspaces

Implementing Security

Deploying Your Application

Using Utilities

What you will learn:

This course is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database administration. In this class, you'll learn how to install and maintain an Oracle database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. You will also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques.

Course Objectives:

Course Topics:

Introduction (Database Architecture)

Installing the Oracle Database Software

Creating an Oracle Database

Managing the Oracle Instance

Managing Database Storage Structures

Administering User Security

Managing Schema Objects

Managing Data and Concurrency

Managing Undo Data

Implementing Oracle Database Security

Configuring the Oracle Network Environment

Proactive Maintenance

Performance Management

Backup and Recovery Concepts

Performing Database Backups

Performing Database Recovery

Performing Flashback

Moving Data

What you will learn:

This course advances your success as an Oracle professional in the area of database administration. In this class, you'll learn how to configure an Oracle database for multilingual applications. You will practice various methods of recovering the database using RMAN and Flashback technology. Database performance monitoring tools will be covered, in addition to the steps to take to resolve common problems and improve performance. You will also learn how to administer a database efficiently by using database technologies such as the Resource Manager, the Scheduler, Automatic Storage Management (ASM), and VLDB features. You will set up a secure database using Virtual Private Database, and learn how to efficiently move data from database to database. The lesson topics are reinforced with structured hands-on practices and a workshop

Course Objectives:

Course Topics:

Introduction

Configuring Recovery Manager

Using Recovery Manager

Oracle Secure Backup

Recovering from Non-critical Losses

Incomplete Recovery

Flashback

Dealing with Database Corruption

Monitoring and Managing Memory

Automatic Performance Management

Monitoring and Managing Storage I

Monitoring and Managing Storage II

Automatic Storage Management

VLDB Support

Managing Resources

Automating Tasks with the Scheduler

Database Security

Data Movement

Using Globalization Support

Workshop

What you will learn:

Minimize the downtime associated with any outage and prevent data loss by learning how to use Oracle Data Guard. The course details Data Guard architecture as well as the creation of physical and logical standby databases. In addition, it examines the performance implications of using various Data Guard features and offers some troubleshooting tips.
Learn to use Enterprise Manager Grid Control to create and manage your Data Guard configuration. A workshop that gives students the opportunity to apply what they have learned to meet stated business requirements reinforces skills.

Course Objectives:

Course Topics:

Oracle Data Guard: Overview

Understanding the Oracle Data Guard Architecture

Using Oracle Data Guard Broker and Enterprise Manager

Creating a Configuration and Physical Standby Database by Using Enterprise Manager

Creating a Physical Standby Database by Using SQL

Configuring Data Protection Modes and Log Transport Services

Creating a Logical Standby Database by Using Enterprise Manager

Creating a Logical Standby Database by Using SQL

Performing Switchover and Failover

Enabling Fast-Start Failover

Using Data Guard in a Real Application Clusters Configuration

Other Considerations for Oracle Data Guard

Workshop

What you will learn:

This course is designed to give the Database Administrator a firm understanding of the components required to successfully deploy an Oracle 10g Database on Enterprise Linux. Students will learn how to configure the Linux operating system for optimal performance with an Oracle database. Then they will install and create an Oracle 10g database on Linux. In addition, the students will also learn how to tune the database to take advantage of the Linux operating system and the Enterprise level features of the OS.
Learn To:

Course Objectives:

Course Topics:

Introduction to Linux

Preparing Linux for Oracle

Installing Oracle on Linux

Managing Storage

Automatic Storage Management (ASM)

Creating the Database

Customizing Oracle on Linux

Managing Memory

Using Linux Measurement Tools

Tuning Oracle on Linux

Debugging Oracle on Linux

What you will learn:

Get the most out of your 10g Database by learning performance tuning methods that maximize the utility of the database. Students learn how to benefit from Oracle Database 10g automatic tuning features, as well as practicing the manual tuning methods using the statspack tool. After clearly defining the various methodologies one can use to tune an Oracle Database, the course covers the various tunable components of an Oracle Database. Throughout the course, students experience hands-on the tuning of an Oracle Database by practicing through a series of workshops.

Course Objectives:

Course Topics:

Performance Tuning Overview

Statistics and Wait Events

Metrics, Alerts, and Baselines

Using Statspack

• Install Statspack
• Create Statspack snapshots
• Generate Statspack reports
• Identify the major sections of the Statspack report

Using AWR

Reactive Tuning

Tuning the Shared Pool

Tuning the Buffer Cache

• Size the buffer cache
• Resolve common performance issues related to the buffer cache
• Use common diagnostic indicators to suggest a possible solution

Automatic Shared Memory

Checkpoint and Redo Tuning

Tuning I/O

Tuning PGA and Temporary Space

Tuning Block Space Usage

Initial Configuration

What you will learn:

This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks and are introduced to stored procedures and functions. They learn about declaring variables, trapping exceptions and they also learn to declare and control cursors.
In class students learn to develop, execute and manage PL\SQL stored program units like procedures, functions, packages and database triggers. Student also learns to manage object dependencies and recompilation of invalid objects. This course also describes the characteristics and ways of manipulation of large objects. Students are introduced to the utilization of some of the Oracle-supplied packages.
Learn To:

Course Objectives:

Course Topics:

Introduction to PL/SQL

Declaring PL/SQL Identifiers

Writing Executable Statements

Interacting with the Oracle Server

Writing Control Structures

• Build Boolean Conditions with Logical Operators
• Use Iterative Control with Looping Statements

Working with Composite Data Types

Using Explicit Cursors

Handling Exceptions

Creating Stored Procedures

Creating Stored Functions

Creating Packages

Using More Package Concepts

Utilizing Oracle Supplied Packages in Application Development

Dynamic SQL and Metadata

Design Considerations for PL/SQL Code

Managing Dependencies

Manipulating Large Objects

Creating Triggers

Applications for Triggers

Understanding and Influencing the PL/SQL Compiler

What you will learn:

This course offers students an introduction to the general features and capabilities of Oracle Database 10g Release 1 for Oracle Real Application Clusters (RAC).
Students learn how to configure and administer a database for use with Real Application Clusters. The course also explains how to setup and use Automatic Storage Management (ASM) in a Real Application Clusters environment. Lectures are reinforced with hands-on practices designed to walk the student through the RAC administration.

Course Objectives:

Course Topics:

Introduction

Architecture and Concepts

RAC Installation and Configuration Part I

RAC Installation and Configuration Part II

RAC Database Instances Administration

Administering Storage in RAC Part I

Administering Storage in RAC Part II

Services

High Availability of Connections

Managing Backup and Recovery in RAC

RAC Performance Tuning

Design for High Availability

This course offers students an introduction to Oracle Database 10g database technology. In this class students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, create database objects, and query meta data.
In addition, the advanced features of SQL in order to query and manipulate data within the database are taught. Advanced querying and reporting techniques are explained. Schema objects that are useful for data warehousing and other application areas are discussed in detail. Students learn about manipulating large data sets and storing and retrieving dates according to different time zones.
Learn to:

Course Objectives:

Course Topics:

Introduction

Writing SQL SELECT Statements

Restricting and Sorting Data

Using Single-Row Functions to Customize Output

• Categorize the character functions into case manipulation and character manipulation types
• Use the character manipulation functions in the SELECT and WHERE clauses
• Explain and use the DATE and numeric functions
• Use the SYSDATE function to retrieve the current date in the default format
• Introduce the DUAL table as a means to view function results
• List the rules for applying the arithmetic operators on dates
• Use the arithmetic operators with dates in the SELECT clause

Reporting Aggregated Data Using the Group Functions

Displaying Data from Multiple Tables

Using Sub queries to Solve Queries

Using the SET Operators

Manipulating Data

Using DDL Statements to Create and Manage Tables

Creating Other Schema Objects

Managing Objects with Data Dictionary Views

Controlling User Access

Manage Schema Objects

Manipulating Large Data Sets

Generating Reports by Grouping Related Data

Managing Data in Different Time Zones

Searching Data Using Advanced Sub queries

Hierarchical Retrieval

Regular Expression Support

What you will learn:

Oracle Enterprise Manager 10g Grid Control delivers centralized management functionality for the complete Oracle IT infrastructure, including systems running Oracle and non-Oracle technologies. With a broad set of administration, configuration management, provisioning, end-to-end monitoring, and security capabilities, Oracle Grid Control reduces the cost and complexity of managing grid computing environments. Robust service level management functionality within Oracle Grid Control dramatically improves service levels through rich transaction and end-user performance monitoring and deep diagnostics for multi-tier Internet applications. Oracle Grid Control also offers a comprehensive extensibility framework for management of custom applications and integration with other management tools. These capabilities allow companies to deliver superior performance for their systems and applications, while continually reducing management complexity and costs.
The participants gain knowledge on the installation and configuration of the Grid Control framework. The out-of-box capability to manage Oracle targets as well as the ability to extend Grid Control to manage non-Oracle targets is presented. Hands-on practices help students learn how use the robust features of Grid Control to manage, monitor, and administer their data center.
This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certification.
Learn to:

Course Objectives:

Course Topics:

Introduction

Grid Control Architecture

Deploying Grid Control

Deploying the Oracle Management Agent

Securing Grid Control

Monitoring Grid Control

Configuring Grid Control

Common Managed Targets - Host

Common Managed Targets – Oracle Database

Common Managed Targets - Oracle Application Servers

Monitoring your Data Center

Groups

Systems and Services

Job System

Configuration Management

Provisioning

Information Publisher

Monitoring Oracle Collaboration Suite

Management Plug-ins

Upgrade to Grid Control 10.2

24 x 7 ORACLE support
Remote Database Monitoring & Tuning
Remote OS Monitoring & Tuning
Remote Database Administration
Remote DBA Services
Linux Monitoring Services
Unix Monitoring Services
24 x 7 Network Monitoring Services
Network Auditing
System Auditing
Network Monitoring Services
Data Center Services
Network Security Services
IDS Deployment
Network Scanner Deployment

Disclaimer: Oracle Is a Trade Mark of Oracle Corporation USA