Oracle 11g New Features for Developers Training

Duration: 
1 days
Codes: 
TP1633,11G

Overview

This one (1) day course gives students the opportunity to learn about and practice with the new developer-related features and enhancements in Oracle Database 11g Release 1. Students examine the benefits and use of the new features in hands-on practice sessions to reinforce their understanding of the new developer capabilities in Oracle Database 11g Release 1.

Audience

Oracle Database Developers.

Skills Gained

At the end of this course the students should be able to:

  • Understand the Upgrade Paths to Oracle 11g Release 1
  • Identify and Use the Application Development New Features and Enhancements
  • Use the SQL Performance Analyzer

Prerequisites

At least 6 months of Oracle Database developer experience.

One day

Course Outline

Outline of Oracle 11g New Features for Developers Training 1. Oracle Database 11g Release 1: Upgrade Paths 2. Application Development New Features

  • Client-Side Query Cache
  • Sequences in PL/SQL Expressions
  • Named and Mixed Notation for PL/SQL Programs in SQL
  • New Compound Trigger Type
  • PL/Scope
  • PL/SQL CONTINUE Statement
  • SIMPLE_INTEGER Data Type

3. Performance Enhancements

  • Automatic SQL Tuning
  • SQL Performance Analyzer Overview
  • SQL Performance Analyzer Data Dictionary Views
  • SQL Plan Management Overview
  • SQL Plan Baseline Architecture

4. Miscellaneous New Features and Enhancements

Related Courses

 

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.