www.jbinternational.co.uk sales@jbinternational.co.uk Call Free 0800 028 6400

JB International 1345 High Road London, N20 9HR +44 (0) 20 8446 7555

 

Oracle 11g - New Features Training Course UK

Dates and full course list

Oracle 11g - New Features Training Course Overview

Course Code:	ORC0050
Price:	£1250
Duration:	3 days
Date:
Who should attend:	The course is suitable for technical personnel involved in the development and maintenance of Oracle applications and those who have completed the Introduction to SQL and/or SQL*Plus course.
Prerequisite Skills:	Delegates should have a good knowledge of their operating system, SQL*PLUS and PL/SQL and previous versions of Oracle.

The course outlines the new features of the Oracle 11g database and tools which are relevant to a developer, and provides hands-on experience through real-world scenarios.

Course Content

This course has been developed for real-world, commercial scenarios by our expert instructors. See below for detailed syllabus. If you have a technical question, please email

Course Objectives

1. 11g Database new features.
2. 11g SQL & PLSQL enhancements
3. The enhancements to the Oracle 11g toolset.

Oracle 11g New Features Training Course Outline

Overview of enhancements and new features

-for developers
-for DBAs

Oracle configuration parameter changes

New parameters
Deprecated Parameters spfile changes

ASM - Automatic storage management enhancements

Rman enhancements

Flashback new features

Transaction backout
Data Archives

Standby database enhancements

lost-write detection
Archive log compression
Physical standby real time query
Snapshot databases

Data Pump new features

Oracle security enhancements

Password related changes
Fine grained access control new features
Tablespace Encryption

Oracle Data Warehousing new features

Interval, reference, system partitioning
extended composite partitioning
Virtual columns
Materialized View enhancements
pivot and unpivot clauses
Table Compression

SQL enhancements

Invisible Indexes
DDl locking changes
new add column functionality
read only tables
SQL query result cache

PL/SQL enhancements

Trigger enhancements
- Created enabled/disabled
- Follows clause
- Compound
Inlining
function result cache
Dynamic SQL enhancements
Ref cursor enhancements
sequence enhancement
continue statement
Bind aware peeking views

XMLDB new features

Binary XML storage
partitioning support XMP
XQuery enhancements
XML DB Repository enhancements
XML Developers Kit
XML index support
XML columns,tables,partitions
XML schema

Java new features

JDK support in 11g
JDBC 4.0 support

Associated Courses

Oracle 11g New Features Training Course for Programmers and DBAs

Introduction to Oracle SQL

Introduction to Oracle PL/SQL

Oracle 10g DBA Combined ('Fundamentals')

Oracle 10g - New Features for Developers

Oracle 10g DBA - part 1

Oracle 10g DBA - part 2

Oracle 10g Performance & Tuning

Oracle 6i Reports

Oracle 6i Forms

Oracle Forms & Reports 5-day Hybrid

Oracle 9i Intro to SQL

Oracle 9i Intro to PL/SQL

Oracle 9i New Features

Oracle 9i Performance Tuning