Feedback

Feedback to trainingforit.co.uk


Site comment Site ratings
Email (optional)

Content

Design

Ease of use

Overall

Oracle Database 11g Release 2 New Features Seminar

Summary
Length:
1 day
Price:
395 GBP excl. VAT
Training Provider:
StayAhead Training plusStayAhead Training
Location:
Training Method:
Startdate:  
London: 04/04/2012, 06/06/2012, 29/08/2012

About Oracle Database 11g Release 2 New Features Seminar

Oracle Database 11g Release 2 New Features Seminar Course Overview
This Oracle Database 11g Release 2 New Features Seminar is designed to give delegates an appreciation of the new features available in Oracle Database 11g Release 1 and 2 and of how these features may affect current Oracle installations.

Skills Gained
The delegate will gain an understanding of:
  • Installation changes
  • Upgrade issues
  • Enterprise Manager changes
  • Hot patching
  • SQL new features
  • PL/SQL new features
  • New memory management features
  • Database Replay to capture, process and replay a workload
  • ASM improvements
  • The Data Recovery Advisor and Flashback
  • Transaction management using Flashback and LogMiner
  • RMAN new features
  • Data Guard improvements
  • Performance tuning new features
  • New security features
  • New schema management functionality
  • Data warehousing enhancements
  • Miscellaneous new features

Who will the Seminar Benefit?
This Oracle Database 11g Release 2 New Features Seminar is designed for Oracle professionals who need an understanding of Oracle Database 11g Release 1 and 2 new features.  This seminar is suitable for users of Release 1 and Release 2.

Seminar Objectives
By the end of the Oracle Database 11g Release 2 New Features Seminar, the delegate will have gained an appreciation of the new features available in Oracle Database 11g Release 1 and 2 and how these can be implemented.

Requirements
Delegates should have an appreciation of the features available in an Oracle Database 10g database.

Note
There is no practical content within this Oracle Database 11g Release 2 New Features Seminar.

Follow-On Courses
  • Oracle Database 11g Release 2 for Experienced 10g Database Administrators




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

Oracle Database 11g Release 2 New Features Seminar 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
  • Automatic Diagnostic Repository (ADR)
  • Parameter file management changes
  • Automatic Memory Management

Session 2: INSTALLING ORACLE DATABASE 11G
  • Oracle Grid Infrastructure and Oracle Restart
  • Installing Oracle Database 11g
  • The DBCA
  • Online patching

Session 3: UPGRADE TO ORACLE 11G
  • Changes in 11g Release 1 and 2
  • Upgrade to Oracle Database 11g Release 2
  • New parameters
  • Deprecated parameters
  • Obsolete parameters

Session 4: DATABASE SECURITY ENHANCEMENTS
  • Case sensitive passwords
  • Default password
  • Privileges audited by default
  • Password verify function
  • Transparent tablespace encryption
  • Fine grained access to database network services
  • Data masking
  • Securefile LOBs
  • Security and OEM

Session 5: ADDM AND AWR NEW FEATURES
  • ADDM New features
  • AWR New features

Session 6: NEW SCHEDULER FEATURES
  • Auto Task overview
  • Auto Task architecture
  • Auto Task dictionary views
  • Use OEM to manage Auto Task
  • Manage Auto Task manually
  • The Auto Task maintenance windows
  • Email Notification
  • File Watcher
  • Remote Database Jobs
  • Multiple Destination Jobs

Oracle Database 11g Release 2 New Features Seminar Training Course
Course Contents - DAY 1 (Purchasing continued)
Session 7: SCHEMA MANAGEMENT NEW FEATURES
  • DDL wait option
  • Add columns with default value
  • Virtual columns
  • Invisible indexes
  • Read only tables

Session 8: APPLICATION DEVELOPMENT NEW FEATURES
  • New SQL commands
  • Lock table parameter
  • Client side caching
  • Server result cache
  • Named notation
  • PL/SQL function cache
  • PL/SQL native compilation
  • Natural sequences
  • When Others Then Null
  • Create trigger as enabled or disabled
  • Compound triggers
  • Create trigger follows clause
  • PL/SQL Continue statement

Session 9: NEW AND ENHANCED UTILITIES PREVENTING AND DETECTING DATA CORRUPTION
  • Automatic block corruption reporting
  • Automatic quarantine of corrupt undo segments
  • Protection from data corruptions
  • Improvements to ANALYZE ... VALIDATE STRUCTURE
  • Proactive Monitoring with the Health Monitor

Session 10: RMAN ENHANCEMENTS
  • RMAN ENHANCEMENTS
  • Automatic channel failover
  • Parallel backup and restore for very large files
  • Multisection backups
  • Improved handling of long-term backups
  • Backup failover for archived redo logs
  • Archived redo log deletion policy
  • Undo backup optimization
  • Improved block corruption detection
  • Improved block media recovery
  • Substitution variables
  • Compressed backups
  • Virtual private catalogs
  • Merge catalogs
  • Backup a recovery catalog

Session 11: DATA RECOVERY ADVISOR
  • Data Recovery Advisor overview
  • DRA through the RMAN command line
  • Use DRA through OEM

Session 12: FLASHBACK DATA ARCHIVE
  • Flashback history
  • Flashback transaction backout
  • Transaction management with LogMiner and Flashback Data Archive
  • LogMiner Interface in OEM
  • Oracle Total Recall
  • Create a Flashback Data Archive
  • Flashback query

Oracle Database 11g Release 2 New Features Seminar Training Course
Course Contents - DAY 1 (Purchasing continued)
Session 13: DATABASE REPLAY
  • Overview of Database Replay
  • The Database Replay process
  • Capture a workload
  • Pre process the captured workload
  • Replay the workload
  • Database Replay usage
  • The DBMS_WORKLOAD Packages

Session 14: DATA PUMP NEW FEATURES
  • The exp utility deprecated
  • Dump file set compression
  • Encryption enhancements
  • Rename table
  • Dumpfile overwrite
  • Partitioned tables
  • The transportable parameter
  • The data options parameter
  • Data Pump legacy mode

Session 15: STANDBY DATABASE
  • RMAN duplicate database
  • Active database duplication
  • Snapshot standby database
  • Real time query
  • Lost write protection

Session 16: ORACLE DATABASE ADVISORS
  • Repair advisors and fault diagnostics
  • The SQL Repair Advisor
  • The SQL Access Advisor
  • The Streams Performance Advisor
  • New DBA Advisor views

Session 17: ASM CHANGES AND NEW FEATURES
  • SYSASM role
  • Disk group attributes
  • Fast disk resync
  • Preferred mirror read
  • Support for variable extent sizes
  • Drop diskgroup force
  • Metadata backup and restore
  • ASM Cluster File System (ACFS)
  • ASM Dynamic Volume Manager (DVM)
  • ASM intelligent datapPlacement
  • ASM File Access Control

Session 18: DIAGNOSTICS NEW FEATURES
  • Fault diagnostic automation
  • Automatic diagnostic workflow
  • Problems and incidents
  • Incident packaging service
  • EM Support Workbench

Oracle Database 11g Release 2 New Features Seminar Training Course
Course Contents - DAY 1 (Purchasing continued)
Session 19: PERFORMANCE TUNING NEW FEATURES
  • Improved statistics gathering
  • Real time SQL monitoring
  • SQL Performance Analyzer
  • Intelligent cursor sharing
  • SQL Plan management
  • Temporary tablespace shrink
  • Test Case Builder

Session 20: NEW DATA WAREHOUSE AND BI FEATURES
  • Partitioning enhancements
  • Materialized view enhancements
  • Query rewrite enhancements
  • PIVOT and UNPIVOT commands
  • Data compression
  • Enhancements to the degree of parallelism
  • In memory parallel query

Session 21: RESOURCE MANAGER CHANGES AND NEW FEATURES
  • I/O calibration
  • Resource Manager new features
  • Default maintenance plan
  • New built in plans
  • Resource Manager statistics in AWR
  • Instance Caging

Continuing studies

Follow on course: Oracle Database 11g Release 2 for Experienced 10g Database Administrators

Expenses

£395.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 New Features Seminar, please fill out the following details:

What happens now?
Write a course review
Have you studied » Oracle Database 11g Release 2 New Features Seminar 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