Participants will be introduced to the new and improved features of Oracle 11g that concern Application Developers. Several exercises involve practice using new items discussed in the class. Objectives include:
- Gain knowledge of Oracle 11g features that are geared to developers
- Understand how existing database features have been improved in Oracle 11g
- Become aware of some 11g DBA oriented features that will impact developers
- Use new 11g SQL features, functions, and analytic functions
- Add Virtual Columns to table definitions when appropriate
- Improve XML performance using Binary XML, XMLIndex, and securefile
- Create code using new 11g PL/SQL features and data types
- Take advantage of the 11g SQL Results Cache features and PL/SQL Results Cache
- Improve application maintainability with new 11g Trigger features
- Understand Oracle 11g integration features with Java, Microsoft .NET, and PHP
- Be able to discuss Edition-Based Redefinition (EBR) and its benefits
Course Features
- Lecture 0
- Quiz 0
- Duration 2 Days
- Skill level All levels
- Language English
- Students 2
- Assessments Yes
Introduction to Oracle 11g
- iSqlPlus and SQLPLUSW gone
- SQL*Plus
- SQL Developer
- Virtual Columns
- Computer Exercise: Using Virtual Columns
XML DB Binary XMLTYPE
- Oracle XML DB Review
- Binary XMLTYPE features
- XMLType index
- LOB Securefile
- Computer Exercise: Working with XML Data
SQL Pivot/Unpivot
- New SQL Functions
- REGEXP_COUNT
- CUBE _TABLE
- XMLCAST
- XMLDIFF
- XMLEXISTS
- XMLPATCH
- Overview of Cube Organized Materialized Views
- Computer Exercise: Using New SQL Features
New Analytic Functions
- LIST_AGG
- NTH_VALUE
- Computer Exercise: Analytic Functions
Recursive Subquery
- Comparison to CONNECT
- Computer Exercise: Using Recursive Subqueries
Executable External Directory Objects
- Read-only Tables
- Invisible Indexes
- Data Pump “Legacy Mode”
- Optional Computer Exercise: Using New DBA-ish 11g Features
Results Cache
- Oracle support for Results Cache
- Computer Exercise: Working with the Results Cache
PL/SQL Results Cache
- PL/SQL compiler enhancement
- Computer Exercise: Using PL/SQL Results Cache
Trigger improvements
- Compound Triggers
- Trigger FOLLOWS
- Computer Exercise: Trigger Improvements
New PL/SQL datatypes
- Assign sequence numbers in PL/SQL
- PL/SQL CONTINUE
- Computer Exercise: New PL/SQL Features
Mixed-Parameter CALL
Pro*C/C++ and Pro*COBOL Improvements
New JDBC driver support Java 5 (1.5) & 6
Microsoft .NET and Visual Studio Support
PHP Enhancements
Edition-Based Redefinition (EBR)
