Exploring 11g Best Practices & New Features for Database Developers & DBAs

מק"ט: #3552 | משך קורס: 8 שעות אק'

Oracle Database 11g brings many new features and enhancements to SQL and PL/SQL. These will help improve your applications and database performance, enhance applications functionality, provide better security for your applications and increase your productivity as a database developer and administrator while making database development processes simpler and faster.
This course will present best practices for implementing and using Oracle database 11g R1 and R2 new SQL and PL/SQL programming language features and enhancements which have significant impact on database application development and that can be used for improving programming functionality, application performance and usability.
Participants in this course will learn about new performance and storage related features, virtual columns, new SQL functions, new DML & DDL enhancements, locking enhancements, new trigger options, bulk binding enhancements, subprogram inlining, partitioning enhancements, new security features and miscellaneous SQL and PL/SQL new features.
This course includes real life examples and live demonstrations and is followed with various SQL and PL/SQL scripts to demonstrate the implementation of Oracle database 11g important new features, guidelines and best practices for database developers and administrators.

*שדות חובה
PDF version


  • Use new performance and storage related features
  • Use virtual columns and new SQL functions
  • Use new PL/SQL features including new trigger options, bulk binding enhancements and subprogram inlining
  • Use new partitioning features and enhancements
  • Use miscellaneous SQL and PL/SQL best practices and new features

קהל יעד

  • Oracle database SQL & PL/SQL developers
  • Applicative database administrators
  • Data warehouse developers
  • Developers

תנאי קדם

Taken Oracle SQL and PL/SQL course or equivalent hands on experience in writing SQL statement and programming using PL/SQL in Oracle database


Course Introduction

  • Introducing course agenda and goals
  • Getting to know the course environment
  • Database schemas used in the course

Oracle SQL Developer Overview

  • Introduction to Oracle SQL Developer main features
  • Oracle SQL Developer complete solution for end-to-end database development and administration
  • Oracle SQL Developer main features for simplifying database development and management


DML & DDL New Features

  • DML error logging
  • Using the recycle bin
  • Locking enhancements
  • Read only tables


Caching new features

  • SQL query result cache
  • PL/SQL function result cache


Partitioning Enhancements and Storage Related New Features

  • Introduction to new table compression feature
  • Segment creation on demand
  • Oracle database 11g – bringing partitioning to perfection
  • Composite partitioning enhancements
  • Interval partitioning
  • Virtual column-based partitioning
  • Reference partitioning
  • System partitioning

PL/SQL New Features

  • Dynamic SQL enhancements
  • Using names and mixed notation
  • Trigger new features: new compound trigger type, the FOLLOWS clause and enabling/disabling triggers
  • The CONTINUE statement
  • Subprogram Inlining
  • Introduction to Edition-Based Redefinition
  • Finer grained dependencies
  • Using sequences in PL/SQL expressions
  • Working with database and object privileges: using invokers vs. definers rights
  • Conditional compilation
  • Improving PL/SQL performance using BULK operations

SQL & PL/SQL Miscellaneous New Features

  • SQL*Plus miscellaneous new features
  • New SQL functions: LISTAGG & PIVOT
  • Important pseudo column and functions: ORA_ROWSCN, SCN_TO_TIMESTAMP & TIMESTAMP_TO_SCN
  • Security enhancements
  • Virtual columns
  • Invisible indexes
  • Careful about assumptions…