Welcome to Oracle 11g

Short course

In Edinburgh, London and Manchester

Price on request

Description

  • Duration

    1 Day

This course is designed to introduce the new features and enhancements in Oracle11g database to existing DBA's and those familiar with previous versions of Oracle's family of RDBMS products (7, 8, 8i, 9i, 10g). This course is ideal for those that need a high level technical review of the new features offered in the latest release of the Oracle database. Suitable for: Database Administrators. Support Engineer. Data Warehouse Administrator. Technical Consultant. Project Managers.

Facilities

Location

Start date

Edinburgh (Midlothian/Edinburghshire)
See map
2nd Floor, 37 George Street, EH2 2HN

Start date

On request
London
See map
18-20 Farringdon Lane, EC1R 3AU

Start date

On request
Manchester (Greater Manchester)
Pall Mall Court, 61 - 67 King Street, M2 4PD

Start date

On request

About this course

PC Fundamentals. Working Knowledge of SQL. Programming Experience.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Training Course Objectives:
This course is designed to introduce the new features and enhancements in Oracle11g database to existing DBA's and those familiar with previous versions of Oracle's family of RDBMS products (7, 8, 8i, 9i, 10g).
This course is ideal for those that need a high level technical review of the new features offered in the latest release of the Oracle database.
Training Course Contents: Introduction
  • Oracle Database Innovation
  • Enterprise Grid Computing
  • Oracle Database 11g: Focus Areas
  • Management Automation
  • Oracle Database 11g: New Features Overview Seminar
  • Oracle Database 11g: Change Management Overview Seminar
Managing Storage
  • Automatic Storage Management (ASM) Enhancements
  • ASM Fast Mirror Resync: Overview
  • Setting Up ASM Fast Mirror Resync
  • ASM Preferred Mirror Read: Setup
  • ASM Scalability & Performance Enhancements
  • SYSASM & ASM Disk
  • ASMCMD Extensions
  • SecureFiles: Overview
Data Recov. Advisor, Flashback
  • Repairing Data Failures
  • Data Recovery Advisor
  • Listing Data Failures
  • Advising on Repair
  • Setting Corruption-Detection Parameters.
  • Flashback Data Archive
  • Creating a Flashback Data Archive: Example.
  • Using Flashback Data Archive: Examples
RMAN, Data Guard Enhancements
  • RMAN Enhancements in Oracle Database 11g
  • Duplicating a Database
  • Active Database Duplication: Selecting the Source
  • RMAN DUPLICATE Command
  • Creating a Standby Database with the DUPLICATE Command
  • Parallel Backup and Restore for Very Large Files
  • Using RMAN Multisection Backups
  • Archival Database Backup
Security: New Features
  • Security Enhancements
  • Secure Default Configuration
  • Enabling the Built-in Password Complexity Checker
  • Managing Default Audits
  • Privileges Audited By Default
  • Adjusting Security Settings
  • Setting Security Parameters
  • Setting Database Administrator Authentication
Intelligent Infrastructure
  • Automatic SQL Tuning in Oracle Database 11g
  • Moving Window Baseline
  • Baseline Templates
  • Generating Baseline for a Single Time Period
  • Using EM to Quickly Configure Adaptive Thresholds
  • Changes to Procedures and Views
  • Automated Maintenance Tasks
  • Default Maintenance Resource Manager Plan
Datawarehousing Enhancements
  • SQL Access Advisor in Oracle Database 11g
  • Oracle Partitioning
  • Partitioning Enhancements
  • Interval Partitioning
  • Interval Partitioning: Example
  • Moving the Transition Point
  • System Partitioning
  • Composite Partitioning Enhancements
Performance Enhancements
  • Statistic Preferences: Overview
  • Partitioned Tables and Incremental Statistics in Oracle Database 11g
  • Hash-Based Sampling for Column Statistics
  • Multicolumn Statistics: Overview
  • Expression Statistics: Overview
  • Deferred Statistics Publishing: Overview
  • Query Result Cache
  • Setting Up the Query Result Cache

Welcome to Oracle 11g

Price on request