Oracle 10g Database - New Features for Administrators

Displaying courses for United States [Change]

Overview

In this course, students identify the most important new features provided in Oracle Database 10g.

Objectives

Upon successful completion of this course, students will be able to:
  • install and configure Oracle Database 10g, and identify the processes for upgrading and cloning existing databases.
  • manage Oracle databases using the advisors that make up the advisory framework.
  • manage storage in Oracle databases by using alerts and new tablespace features.
  • use Automatic Storage Management to manage files.
  • improve data stability by using enhancements to Oracle Flashback and new data backup, recovery, and restore features.
  • optimize applications by using new SQL features and performance enhancements.
  • tune database performance by identifying and using a variety of new performance-enhancing features.
  • manage scheduled jobs using the Scheduler tool.
  • load and unload data by using the Data Pump tool and other new features.
  • increase security of Oracle databases using new VPD and auditing features.

Audience

Students should be experienced with Oracle databases up to and including Oracle9i, and/or already be certified with Oracle9i. Students should have knowledge of Oracle database utilities, architecture, and terminology, as well as SQL.

Syllabus

Installing, Upgrading, and Cloning Oracle Database 10g

  • Installing Oracle Database 10g
  • Upgrading a Database to Oracle Database 10g
  • Database Cloning
  • Enterprise Manager Enhancements

Managing Oracle Database 10g with the Advisory Framework

  • The Advisory Framework
  • Automatic Database Diagnostic Monitor
  • MTTR Advisor
  • Optimize Redo Logfile Size
  • Manage the Undo Tablespace
  • Reclaim Wasted Space from Tables and Indexes
  • Improve the Performance of SQL Queries Using SQL Tuning Advisor
  • Optimize SQL Statements by Using the SQL Access Advisor

Managing Storage in Oracle Database 10g

  • Monitor and Manage Server-Generated Alerts
  • Manage Tablespaces

Automating Storage Management

  • Automatic Storage Management
  • Set Up Initialization Parameters and Start an ASM Instance
  • Administer ASM Disk Groups
  • Migrate Your Database to ASM Using RMAN

Improving Backup and Recovery with New Enhancements

  • Restoring Data with Oracle Flashback
  • Configure and Manage the Flash Recovery Area
  • Improve Database Backups
  • Improving Restore and Recovery Operations

Using New SQL Features and Performance Enhancements

  • Managing Optimizer Statistics
  • Improved Support for Strings Using Regular Expressions
  • Write MERGE Statements with the New Conditions and Extensions
  • Use Additional Linguistic Comparison and Sorting Methods in SQL
  • Use Partitioned Outer Join Syntax for Densification
  • Simplify SQL by Using Interrow Calculations

Tuning Database Performance

  • Use the Performance Pages of the Database Control
  • Monitor and Maintain the Automatic Workload Repository
  • Diagnose Recent Issues with the Active Session History
  • Automate Shared Memory Management
  • Control Database Resources with Resource Manager Enhancements
  • Improving Performance with Additional Enhancements
  • Diagnose Performance Problems in Multitier Environments

Managing Scheduled Jobs

  • Simplify Management Tasks by Using the Scheduler
  • Reuse Scheduler Components for Similar Tasks
  • View Information About Job Executions and Job Instances

Loading and Unloading Data

  • Export and Import Using Data Pump
  • Unload Data into External Tables
  • Transportable Tablespaces and Different Platforms
  • Copy Files Using the Database Server

Securing Oracle Databases

  • Apply a Column-Level VPD Policy
  • Apply VPD Policy Types
  • Maximize Audit Efficiency Using Fine-Grained Auditing
  • Audit Database Changes with the Uniform Audit Trail

Training provider

Teaching mode:
Online - Self paced
Classroom - Instructor Led
Duration: 3 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Oracle Database
United States
This skill has an average salary of
US$96,517
and is mentioned in
2.88%
of job ads in this area.
Database
United States
This skill has an average salary of
US$76,936
and is mentioned in
14.10%
of job ads in this area.
Database Administration
United States
This skill has an average salary of
US$93,461
and is mentioned in
0.52%
of job ads in this area.
SQL
United States
This skill has an average salary of
US$92,768
and is mentioned in
7.30%
of job ads in this area.