Oracle 11g - New Features Training Course
| Course code: |
ORAC11GNEW |
| Details: |
3 days, On Demand - Please Enquire
|
| Onsite | Enquire about bringing this course to your offices |
| 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. |
Course Outline
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 sales@jbinternational.co.uk
What you will learn
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
