Microsoft training courses, Cisco training courses, Prince2 training courses, ISEB training courses with locations nationwide
Call now to speak to an experienced Training Advisor
 
     
 
Home
  
How it works
  
About the quality of your course
 
Managed services
  
Partner CourseMonster
  
 
 
Thousands of Microsoft, ISEB, ITIL, Cisco and Prince2 Training Courses and more
  
 
Browse Oracle Training Courses

Database 11g: New Features

Course Code: O1112      Days: 1
Show all Oracle Courses
Scheduled Dates
Locations filtered. Show all UK course locations.
Request availability or book by selecting a date:
Central London
City
London (EC1) 01/12/08 £ 340
London (EC1) 02/02/09 £ 395
London (EC1) 17/03/09 £ 395
London (EC1) 14/04/09 £ 395
England
Yorkshire (West)
Leeds (LS1) 12/12/08 £ 340
Prices exclude VAT.
Why do prices vary? Using CourseMonster, you search the schedules of over 100 training companies in one convenient location. Choose the city, date and price that best suits you.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.

Course Overview

This course is designed to introduce the new features and enhancements in Oracle11g database to existing DBAs and those familiar with previous versions of Oracle's family of RDBMS products (7, 8, 8i, 9i, 10g).

The course fulfils the need of DBAs to remain up to date with new 11g development as well as considering the impact/opportunities available through the implementation of Oracle 11g database.

Audience

  • Database Administrators
  • Support Engineer
  • Data Warehouse Administrator
  • Technical Consultant

Prerequisites

  • PC Fundamentals
  • Programming Experience
  • Working Knowledge of SQL

Course Outline

Installation and Enhancements

  • Oracle Database 11g Installation: Changes
  • Oracle Database Upgrade Enhancements
  • Upgrade Performance Enhancement
  • Upgrade Process
  • Oracle Database 11g Release 1: Upgrade Paths
  • Database Upgrade Assistant (DBUA)
  • Hot Patching: Overview

Change Mgt. Unit Overview

  • Change Management in Oracle Database 11g
  • Challenges Faced by DBAs When Performing Changes
  • Lifecycle of Change Management
  • Setting Up a Test Environment by Using the
  • Snapshot Standby Database

Database Replay

  • System Architecture: Capture
  • System Architecture: Processing the Workload
  • System Architecture: Replay
  • Pre-Change Production System
  • Supported Workloads
  • Database Replay Workflow in Enterprise Manager
  • Using the Capture Wizard
  • Packages and Procedures

Automatic SQL Tuning

  • Automatic SQL Tuning in Oracle Database 11g
  • Selecting Potential SQL Statements for Tuning
  • Maintenance Window Timeline
  • Automatic Tuning Process
  • DBA Controls
  • Automatic SQL Tuning Task
  • Automatic SQL Tuning: Fine Tune
  • Automatic SQL Tuning Considerations

Intelligent Infrastructure

  • Automatic Workload Repository Baselines
  • Performance Monitoring and Baselines
  • Automated Maintenance Tasks
  • Resource Manager: New EM Interface

Performance Enhancements


How to make a booking for the O1112 course
 
  CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.  
     
CourseMonster® Patent Pending © SeaKom, All Rights Reserved - Channel partners with Business Training Partnership