Oracle Training : Oracle9i New Features Overview for Developers

This class will provide you with an overview of the new developer-centric features available in Oracle9i. Release 1 and Release 2 features are discussed. Many code examples are presented. Of course, we will supply you with the scripts! This is a one-day, lecture only course.

Oracle Training Prerequisites

Students must already have a working knowledge of Oracle 8 or 8i, including SQL and PL/SQL experience. Students should be taking the course as an introduction to Oracle9i, not as an introduction to Oracle concepts.

Oracle Training Course duration

1 Day

Oracle Training Objectives

After successfully completing this course, you will understand the major new developer-related features of Oracle9i and be able to determine if and where the feature can be used in your applications.

Oracle Training Course outline

Deprecated Features and Replacements
- Deprecated Features
- LONG, LONG RAW Data Types
- ANALYZE Command
- Export / Import INCREMENTAL Functionality
- Summary
Flashback Query
Concepts
- Using DBMS_FLASHBACK
- Release 2 Statement-Level Flashback
- Flashback Tips
- Flashback Limitations
- Summary
External Tables
- Concepts
- Implementation and Use
- Use for Querying External Files
- Use for Loading Data
- External Table Tips
- Limitations
- Summary
Oracle9i SQL Features
- MERGE Statement
- Multi-Table INSERT Statement
- ANSI Compliant Joins
- Subquery Factoring
- CONNECT BY Extensions
- New Functions
- 8i CASE Expression
- Enhanced LOB Support
- INSERT & UPDATE DEFAULT Value
- Enhanced RENAME Support
- User-Defined Aggregates
- Analytic Functions
- Resources
- Summary
Oracle9i PL/SQL Features
- ANSI CASE Statement
- Associative Arrays
- Record-Based DML
- Multi-Level Collections
- Pipelined Functions
- Native Compilation
- LOB Support
- Accessing metadata with DBMS_METADATA
- UTL_FILE Improvements
- Inheritance and Type Evolution Support
- Triggering Statement Access
- Did you see the following cool Oracle8i Features?
- 8i Invoker Rights
- 8i Bulk Binds
- 8i Autonomous Transactions
- 8i Database Event Triggers
- Summary
New Datatypes
- Introduction to 9i Datetime Data
- TIMESTAMP Datatype
- TIMESTAMP WITH TIME ZONE Datatype
- TIME STAMP WITH LOCAL TIME ZONE Datatype
- Datetime Conversions
- Time Zone Functions
- INTERVAL Datatypes
- Summary
XML Support
- Introduction to XML DB
- XMLType Datatype
- Using XMLType
- Inserting XML Data into XMLType
- Extracting XML Data from XMLType
- Using XMLType within PL/SQL
- Other XML Features
- Summary
Resumable Space Management
- Introduction to Resumable Space Management
- Errors Handled
- Enabling RSM
- Monitoring RSM
- AFTER SUSPEND Trigger
- Import and SQL*Loader Support
- RSM Restrictions
- Summary
Tuning Enhancements for Developers
- Runtime Plan & Statistics
- V$SQL_PLAN and V$SQL_PLAN_STATISTICS
- Dynamic Sampling
- Cursor Sharing
- Forced Rewrite
- Index Skip Scan Access Path
- Compressed Tables
- FIRST_ROWS_n Optimization
- Miscellaneous Enhancements
- Summary
Security for Developers
- 8i Fine Grained Access Control (FCAG) Review
- 9i FGAC Enhancements
- n-Tier Proxy Authentication
- Fine-Grained Auditing
- Other 9i Security Features
- Summary
Index Enhancements for Developers
- Bitmap Join Indexes
- Index Monitoring - Finding Unused Indexes
- Index Skip Scan Access Path
- IOTs and Bitmap Indexes
- The KEEP INDEX Option
- Creating Indexes on a Constraint Clause
- Summary

Hardware/Software Requirements

Hardware Requirements

Video projection

Software Requirements

None- lecture only

	About us Contact us Careers at Wintrac Our Clients Why Wintrac	Register for a free training CD-ROM drawing Refer a client or instructor and earn $$$	Wintrac Inc. 16523 SW McGwire Ct. Beaverton OR 97007
© Wintrac, Inc. All rights reserved. Site Map \| Terms of Use \| Privacy Policy