back to Course Categories | back | print
Oracle9i R2 New Features for DBAs and Developers          

Duration: 5 days

Description 
This course combines the Oracle9i New Features for DBA and developer courses to give a comprehensive overview of the new features in Oracle9i Release 1 and Release2. Students will learn the new feature/functionality on the database and application side.

Topics

  • New globalization and Unicode features
  • New CROSS, NATURAL, INNER and OUTER join syntax
  • Database workspaces
  • Data Guard
  • Data Guard Logical standby
  • Automated consumer group switching
  • Improved memory management
  • Real Application Clusters and Cache Fusion
  • New data warehouse features
  • New view constraints
  • MERGE statements
  • FOR UPDATE WAIT statement
  • Grouping sets
  • New built-in SQL functions
  • PL/SQL enhancements
  • Analytical functions
  • Table enhancements
  • Multiple table inserts
  • Default column value changes
  • CBO enhancements
  • Enhancements to object-relational features
  • Multiple block sizes
  • Multiple block sizes
  • Enhanced security features
  • New Java and XML features
  • Enhancements to Standby databases
  • Automated consumer Group switching
  • Global index management
  • Extensions to Advanced Queuing
  • Data warehouse enhancements
  • CASE expressions
  • Cursor subqueries
  • List partitioning
  • New schema objects
  • Using External tables

Prerequisites

  • Working experience in an Oracle8i environment.


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design