|
(703) 246-9100 Northern Virginia (804) 285-5830 Central Virginia (757) 420-3810 Tidewater Area (800) 294-7497 Toll Free (804) 285-3722 Fax |
Oracle9i New Features for Developers
Duration: 3 days
|
(703) 246-9100 Northern Virginia (804) 285-5830 Central Virginia (757) 420-3810 Tidewater Area (800) 294-7497 Toll Free (804) 285-3722 Fax |
Oracle9i New Features for Developers
Duration: 3 days
Familiarize developers experienced with Oracle8i what new features are available in Oracle9i
Course Objectives:
Write SQL statements using new SQL99 syntax, DML syntax and join syntax
Differentiate and use new 9i datatypes for date and time data
Use new SQL extensions from both 8i and 9i that support DSS queries
Code PL/SQL objects and collections using new 9i enhancements
Describe new features available in the InterMedia and Spatial data cartridges
Use the new XML development platform in the 9i database
Course Topics:
Support for the 1999 SQL Standard
Join syntax
CASE statements
COALESCE and NULLIF expressions
Newly allowed subqueries
Using new SQL features in PL/SQL
New Date/time Datatypes
TIME_ZONE parameter
TIMESTAMP datatypes
INTERVAL datatypes
New date functions
Data Warehousing Enhancements
ROLAP operators
DSS function enahancements
Enhancements to INSERT statements
MERGE statements
GROUPING SETS
WITH clauses
Introduction to external tables
PL/SQL Enhancements
Native compilation
Bulk binding
Bulk dynamic SQL
Enhanced PL/SQL tables
Enhancements to Objects and Collections
Type inheritance and hierarchies
Substitutable object types
Widening and narrowing
Type dependencies
Multilevel collections
Tuning Enhancements
Enhancements to index-organized tables
Stored SQL execution plans and stored outlines
CBO enhancements
Literal replacement of bind variables
XML in Oracle9i
Overview of XML and XSL
The Oracle9i XDK
The XMLType
DBMS_XMLGEN
Data Definition and Security Enhancements
Online table redefinition
Online index rebuilding
Virtual Private Database
Global Application Context
Row-level security
Database Workspaces
What are workspaces?
Benefits of workspaces
Using workspaces
Audience:
Database developers
Database designers
Required Prerequisites:
At least 1 year development experience with Oracle8i databases
Strong familiarity with SQL and PL/SQL
Suggested Prerequisites:
Introduction to Oracle: SQL and SQL*Plus
PL/SQL Programming
Oracle Database Design
Providing Specialized Educational Classes--Expanding skills today to meet the challenges of tomorrow