Feedback

Feedback to trainingforit.co.uk


Site comment Site ratings
Email (optional)

Content

Design

Ease of use

Overall

Oracle Database 11g Release 2 for Experienced 10g Database Administrators

Summary
Length:
5 days
Price:
1,795 GBP excl. VAT
Training Provider:
StayAhead Training plusStayAhead Training
Location:
Training Method:
Startdate:  
London: 12/03/2012, 21/05/2012, 16/07/2012, 17/09/2012, 19/11/2012
Bristol: 19/03/2012 09:3009:30
Leeds: 25/06/2012, 13/08/2012, 29/10/2012

About Oracle Database 11g Release 2 for Experienced 10g Database Ad...

Oracle Database 11g Release 2 for Experienced 10g Database Administrators Course Overview
This Oracle Database 11g Release 2 for Experienced 10g Database Administrators course is designed to provide the knowledge and
skills needed to maintain successful and efficient day-to-day operation of Oracle
Database 11g Release 1 and Release 2.  The Oracle Database 11g Release 2 for
Experienced 10g Database Administrators course will give experienced Oracle database
administrators practical experience in installing, configuring, administering and
implementing an Oracle Database 11g Release 2.  Database
administrators will gain a practical understanding of the new features of
Oracle Database 11g Release 2 and how these can be implemented in their
current Oracle installations.

Skills Gained
The delegate will practise:
  • Installing Oracle Database 11g Release 2 Software
  • Creating an Oracle Database Using New Features
  • Using SQL and PL/SQL New Features
  • Using New Memory Management Features
  • Using Real Application Testing
  • Using Database Replay to Capture, Process and Replay Workloads
  • Using the Data Recovery Advisor and Flashback
  • Using Transaction Management using Flashback and LogMiner
  • Using RMAN New Features
  • Using Data Pump Data Compression
  • Using Performance Tuning New Features
  • Using New Security Features
  • Using New Schema Management Functionality
  • Using AutoTask
  • Using Data Warehouse and BI New Features

Who will the Course Benefit?
This Oracle Database 11g Release 2 for Experienced 10g Database Administrators course is designed for experienced Oracle 10g database administrators and technical support staff.

Course Objectives
This Oracle Database 11g Release 2 for Experienced 10g Database Administrators course is designed to provide the skills needed install, upgrade, implement and support Oracle Database 11g Release 1 and Release 2.

Database administrators will gain a practical understanding of the new features of Oracle Database 11g Release 1 and Release 2 and how these can be implemented in their current Oracle installations.

Examinations
The Oracle Database 11g Release 2 for Experienced 10g Database Administrators course covers the major topics required for the Oracle examination IZO-050: Oracle Database 11g: New Features for Administrators.

Before taking any exam, ensure you have the recommended experience.  The Oracle website lists all exam requirements and these are updated regularly.

Exams are not included as part of the course.

Requirements
Delegates who wish to attend this Oracle Database 11g Release 2 for Experienced 10g Database Administrators course should have good understanding of Oracle Database 10g administration.

Follow-On Courses
  • Oracle 11g SQL Performance Tuning


  • Oracle 10g Application Server Administration




NOTE: Course technical content is subject to change without notice.

Oracle Database 11g Release 2 for Experienced 10g Database Administrators Training Course
Course Contents - DAY 1
Course Introduction
  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: NEW MANAGEMENT FEATURES
  • Log File Changes
  • Parameter File Management Changes
  • Automatic Diagnostic Repository
  • ADRCI Command Line Tool
  • Automatic Memory Management
  • Memory Advisor Views
  • New Management Parameters

Session 2: INSTALLING AND CONFIGURING ORACLE DATABASE 11g
  • Install Oracle Database 11g
  • Deinstall Oracle Database 11g
  • The Database Configuration Assistant
  • Online Patching

Session 3: UPGRADING TO ORACLE DATABASE 11g
  • Upgrading to Oracle Database 11g Release 1 and 2
  • Upgrade the Time Zone File and Timestamp with Timezone Date
  • Oracle Parameter Changes
  • Online Dictionary View Changes

Session 4: OVERVIEW OF ORACLE RESTART
  • Control Oracle Restart
  • Use the srvctl Utility
  • Manually Add Components to the Oracle Restart Configuration


Session 5: NEW SECURITY FEATURES
  • Automatic Secure Configurations
  • Default Passwords
  • Case Sensitive Passwords
  • Profiles and the Password Verify Function
  • Default Auditing
  • Tablespace Master Key Re-key
  • Transparent Tablespace Encryption
  • Data Masking
  • Oracle SecureFile LOBs
  • Access Control Lists on Network Services
  • Oracle Secure File Masking
  • Security and OEM

Oracle Database 11g Release 2 for Experienced 10g Database Administrators Training Course
Course Contents - DAY 2
Session 6: STORAGE ENHANCEMENTS
  • Use 4KB Sector Disks
  • Table Compression
  • Hybrid Columnar Compression
  • Segment Creation on Demand

Session 7: ADDM AND AWR NEW FEATURES
  • ADDM New Features
  • ADDM New Views
  • ADDM for RAC
  • Manage ADDM through DBMS_ADDM
  • Find Classifications
  • Directives
  • AWR New Features
  • Altered Retention of AWR Snapshots
  • AWR Baseline New Features
  • Adaptive Metric Thresholds

Session 8: NEW SCHEDULER FEATURES
  • Scheduler Automated Maintenance Tasks
  • Auto Task Architecture
  • Auto Task Dictionary Views
  • Use OEM to Manage Auto Task
  • Manage Auto Task Manually
  • The Auto Task Maintenance Windows

Session 9: SCHEMA MANAGEMENT NEW FEATURES
  • DDL Wait Option
  • Add Columns with a Default Value
  • Virtual Columns
  • Improved Online Index Creation and rebuild
  • Invisible Indexes
  • Read Only Tables

Session 10: APPLICATION DEVELOPMENT NEW FEATURES
  • SQL
  • New SQL*Plus Commands
  • Lock Table Parameter
  • Client Side Result Cache
  • Server Result Cache
  • Use Table Automation to Control Result Caching
  • Regular Expression Enhancements
  • Named Notation
  • PL/SQL
  • PL/SQL Function Cache
  • Automatic Subprogram Inlining
  • PL/SQL Scope
  • PL/SQL Native Compilation
  • Dynamic SQL in PL/SQL
  • Dynamic SQL and REF Cursors
  • Trigger Enhancements
  • Simple Integer Datatype
  • PL/SQL CONTINUE Statement
  • Natural Sequences

Oracle Database 11g Release 2 for Experienced 10g Database Administrators Training Course
Course Contents - DAY 3
Session 11: UTILITIES FOR TROUBLESHOOTING DATA CORRUPTION
  • Automatic Block Corruption Reporting
  • Automatic Quarantine of Corrupt Redo Segments
  • Protection from Data Corruption
  • Improvements to Analyze Validate Structure
  • Proactive Monitoring with the Health Monitor

Session 12: RECOVERY MANAGER NEW FEATURES
  • Automatic Channel Failover
  • Parallel Backups
  • Compressed Backups
  • Improved Handling of Long Term Backups
  • Backup Failover of Archived Redo Logs
  • Archived Redo Log Deletion Policy
  • Undo Backup Optimization
  • Improved Block Media Recovery
  • Stored Scripts with Substitution Values
  • Virtual Private Catalogs
  • Merge Catalogs
  • Backup up Catalogs
  • Active Database Duplication
  • TSPITR Enhancements and Modifications

Session 13: DATA RECOVERY ADVISOR
  • Overview of the Data Recovery Advisor
  • Use the Data Recovery Advisor through OEM
  • Use the Data Recovery Advisor through the RMAN Command Line
  • Proactive Health Checks with the Validate Command
  • Data Recovery Advisor Dictionary Views

Session 14: FLASHBACK TECHNOLOGY
  • Flashback Transaction Backout
  • Flashback Transaction Wizard
  • Enterprise Manager Log Miner Interface
  • Oracle Total Recall
  • Flashback Data Archive Overview
  • Flashback Data Archive Architecture
  • Flashback Data Archive Workflow

Session 15: DATABASE REPLAY
  • Overview of Database Replay
  • The Database Replay Process
  • Capture Workload
  • PreProcess the Captured Workload
  • Replay Workload
  • Database Replay Usage
  • The DBMS_Workload Package

Oracle Database 11g Release 2 for Experienced 10g Database Administrators Training Course
Course Contents - DAY 4
Session 16: DATA PUMP NEW FEATURES
  • Dump File Set Compression
  • Encryption Enhancements
  • Data Remapping
  • Rename Table
  • Dump File Overwrite
  • Partitioned Tables
  • The Transportable Parameter
  • The Data_Options Parameter
  • The exp Utility Deprecated
  • Data Pump Legacy Mode

Session 17: OVERVIEW OF DATA GUARD NEW FEATURES
  • Compression of Archived Redo Logs
  • Lost Write Detection
  • Higher Availability with Fast Start Failover Enhancements
  • Real Time Query Capable Physical Standby Database
  • Rolling Upgrades to Physical Standby
  • Block Change Tracking on a Physical Standby Database
  • SQL Apply Logical Standby
  • RMAN and Data Guard
  • Snapshot Standby Database
  • Clone a Running Database
  • Oracle Active Data Guard
  • Real Time Query Apply Lag Time

Session 18: ORACLE DATABASE ADVISORS
  • Repair Advisors and Fault Diagnostics
  • The SQL Repair Advisor
  • The SQL Access Advisor
  • The Streams Performance Advisor
  • The Advisor Views

Session 19: OVERVIEW OF ASM CHANGES AND NEW FEATURES
  • SYSASM Role
  • Disk Group Attributes
  • Fast Disk Resync
  • Preferred Mirror Read
  • Compatibility Settings
  • ASM Support for Variable Allocation Unit Sizes
  • Drop Diskgroup Force
  • The asmcmd Command Line Interface
  • New ASM Documentation
  • Oracle Database 11g Release 2 New Features

Oracle Database 11g Release 2 for Experienced 10g Database Administrators Training Course
Course Contents - DAY 5
Session 20: NEW DIAGNOSTIC FEATURES
  • Oracle Database 11g Fault Diagnostic Automation
  • Automatic Diagnostic Workflow
  • Problems and Incidents
  • Incident Packaging Service
  • Temporary Tablespace Shrink
  • EM Support Workbench Overview

Session 21: PERFORMANCE TUNING NEW FEATURES
  • Improved Statistics Gathering
  • Real-Time SQL Monitoring
  • Monitoring and Tuning usage model
  • Setting up Notification rules
  • Using the Advisors
  • The SQL Performance Analyzer
  • Automatic SQL Tuning
  • Manual Creating and Use of SQL Tuning Sets
  • Intelligent Cursor Sharing
  • SQL Plan Management
  • Temporary Tablespace Shrink
  • Test Case Builder
  • SQL Monitoring in Oracle Database 11g R2
  • View Session Details
  • View the SQL Monitoring Report

Session 22: DATA WAREHOUSE AND BI NEW FEATURES
  • Partitioning Enhancements
  • Data Pump Single-Partition Imports
  • Materialized Views and Query Rewrite Enhancements
  • The PIVOT and UNPIVOT Clauses
  • Data Compression
  • Enhancements to the Degree of Parallelism
  • In Memory Parallel Query
  • System Managed Indexes for List Partitioning

Session 23: RESOURCE MANAGER CHANGES AND NEW FEATURES
  • I/O Calibration
  • Default Maintenance Plan
  • Built-In Resource Plans
  • Resource Manager Statistics in AWR
  • Resource Manager Plan Directive New Features
  • Instance Caging

Continuing studies

Follow on courses: Oracle 11g SQL Performance Tuning, Oracle 10g Application Server Administration

Expenses

£1,795.00

About StayAhead Training

technical it training

SQL, Oracle, UNIX and Linux experts

StayAhead Training are recognised as one of the top 50 IT Training organisations in the UK and the first choice provider of UNIX, Linux, MySQL and Oracle training courses for many of the UK's most prominent organisations.

StayAhead Training was established in 1992 and now have training centres in London, Birmingham, Manchester, Leeds, Edinburgh and Bristol. Because of this, StayAhead are able to offer a large range of scheduled, tailored and onsite training. Independent of where you are based, StayAhead can help you and your firm's IT requirements be reality.

StayAhead IT Training works with some of the largest names in the IT training industry to provide courses on behalf of Parity Training, Global Knowledge, New Horizons and many more.

unix, linux, oracle, sql, javaSpecialist IT training

StayAhead Training have a formidable reputation for quality and expertise within the UNIX, Oracle, Linux and MySQL arena and enjoy an enviable position in the UK by being amongst the top IT Technical training organisations.

The UNIX curriculum not only covers standard UNIX but includes a range of Solaris, AIX, HP-UX, Linux, SUSE, LPI & Red Hat Linux training. The Oracle curriculum also has depth with courses available for DBAs, Developers and Designers. If certification is important to you then again we do not disappoint taking delegates to the level required to take the examinations in Solaris, Red Hat, SUSE, LPI, MySQL, Oracle Forms Developer and Oracle DBA. With the Oracle e-business suite growing in popularity a range of Oracle Financials courses are also available.

StayAhead's training flexibility comes from developing their own courses that include high quality course material, written not only to support the learning process, but can also act as a helpful reference guide on the delegates return to work.

In-house IT training

In addition to the public schedule of courses provided, StayAhead offer all courses in-house at a client's site, or at a StayAhead location. All courses can be tailored to meet our clients' specific needs. For courses at the client's site StayAhead can provide all the necessary hardware and software.

StayAhead's focus on IT training

StayAhead understands the best approach for such technical IT training is always to be enthusiastic, business-like, informal yet professional. Whether delegates attend a StayAhead Training scheduled course or an on-site course, each event is approached in a professional manner.

StayAhead's style of delivery is designed to foster the development of learning. Instructor led tutorials are followed by practical exercises. The style is experiential allowing delegates to take ownership and solve problems for themselves. Research shows that the pace of learning is greatly accelerated when delegates are shown HOW to solve their problems rather than just why they should.

specialist it training


plus Show all courses with StayAhead Training

Request information - obligation free

Get more information from StayAhead Training by filling out the following form. This is a free service for you and the course provider to help you find the most suitable training.
To request information from StayAhead Training, please fill out the following details:
* =  Required field
Email Address*
First Name*
Last Name*
Company
Position
Town/City*
Telephone*
Start date
Number of participants
Message*
Rules

Contact information for StayAhead Training

StayAhead Training

6 Long Lane, Barbican
EC1A 9HF London

Phone no: 020 7600 6116
www.stayahead.com

More Information
Request Information
To request information from Oracle Database 11g Release 2 for Experienced 10g Database Administrators, please fill out the following details:

What happens now?
Write a course review
Have you studied » Oracle Database 11g Release 2 for Experienced 10g Database Administrators at » StayAhead Training? Share your experience & help others to pick the right course. Set grades (1-5) where 1= very poor & 5 = excellent.
V. Poor | Poor | OK | Good | Excellent
Trainer / Provider
Venue / Facilities
Course Materials
Networking with other delegates

Do you recommend the provider:


Need help finding the right course?

  
By submitting your e-mail, you become a member of Trainingforit.co.uk