Oracle Training : Oracle9i Differences for Developers

This hands-on course provides a in-depth technical introduction to the new application developer related features provided with Oracle9i Release 2. Detailed working examples, scripts and demonstrations (code provided, of course!) reinforce your understanding and prepare you for implementation in your shop. If you are an experienced Oracle8 or 8i Developer moving to Oracle9i, we guarantee you will benefit from and enjoy this class!.

Oracle Training Prerequisites

Students must already have a working knowledge of Oracle 8 or 8i.

Oracle Training Course duration

2 Days

Oracle Training Objectives

After successfully completing this course, you will be able to:

Use the new SQL and PL/SQL features provided with Oracle9i such as CASE, ANSI joins, Multi-Table Insert and Merge
Implement and use External Tables to access and load data from external sources
Use the new datetime datatype and associated functions
Implement and use Flashback Query to view the database at a previous point in time
Code the new analytic windowing functions such as RANK and DENSE_RANK
Make use of the XMLType datatype to store and access XML documents within a table column
Implement new indexing techniques such as the USING INDEX clause and Skip Scans
Implement List and Range-List Partitioning schemes
Use Resumable Space Management t restart jobs that fail due to space-related errors
And you'll have fun learning it!

Oracle Training Course outline

New SQL features
- MERGE Statement ("Upsert" Operations)
- Multi-Table INSERT
- ANSI Compliant Joins
- The CASE Expression (Introduced in Oracle8i)
- Subquery Factoring (the "WITH" Clause)
- Workshop
Analytic Functions

Introduction
What Do They Do?
Getting Started
Syntax Notes
Partition Clause
Order-By Clause
Windowing Clause
Row Windows
Range Windows
Ranking Functions
Top-N Queries
LAG and LEAD
Closing Thoughts
List of Functions
Resources
Workshop

Flashback Queries - Concepts

Flashback Queries - Use
Flashback Tips
Flashback Limitations
Workshop

External Tables

Concepts
Implementation
Use for Querying External Files
Use for Loading Data
Workshop

XML Support

XMLType Datatype
Using XMLType
Inserting XML Data into XMLType
Extracting XML Data from XMLType
Using XMLType within PL/SQL
Other XML Features
Workshop

Datetime Datatypes

Introduction to 9i Datetime
TIMESTAMP Datatype
TIMESTAMP WITH TIME ZONE Datatype
TIME STAMP WITH LOCAL TIME ZONE Datatype
Datetime Conversions
Time Zone Functions
Workshop

New PL/SQL features

ANSI compliant CASE
Multi-level collections
Metadata Access
9i Record-Based DML
9i Inheritance Support
Did you see the following cool Oracle8i Features?
- 8i Invoker Rights
- 8i Bulk Binds
- 8i Autonomous Transactions
- 8i Database Even Triggers
Workshop

Indexes

Creating Indexes on a Constraint Clause
USING INDEX Example
Index Monitoring - Finding Unused Indexes
Skip Scanning
IOTs and Bitmap Indexes
Bitmap Join Indexes
Workshop

Resumable Space Management

Introduction t Resumable Space Management
Errors Handled
Enabling RSM
Monitoring RSM
Storage Allocation Correction
AFTER SUSPEND Trigger
Import and SQL*Loader
RSM Restrictions
Workshop

Partitioning

Partitioning History
List Partitioning
Composite Range-List Partitioning
Workshop

Hardware/Software Requirements

Hardware Requirements

Minimal Processor: Pentium 166 or Pentium 200
Recommended Processor: Pentium 233 or Pentium 266
RAM: Minimum 128 MB (256 MB recommended)
Oracle Corporation also recommends increasing virtual memory to 200 MB.
- Minimum 200 MB, Maximum 400 MB
- Modify it in the Performance tab of System Properties in the Control Panel
Available Disk Space:
- FAT 4.5 GB for HOME Directory, 140MB for System Drive
- NTFS 2.75 GB for HOME Directory, 140MB for System Drive
- Temp Space - 400 MB
Video: 256 color
A connection to the Internet is desirable (but not absolutely necessary) to show students various Oracle-related sites.

Software Requirements

Windows NT 4.0 (SP5 or Higher) or Windows 2000 (SP 1 or higher)
Oracle9i (Release 2 recommended)
- A new install is strongly recommended if the existing Oracle install is on a freely accessible machine, such as classroom machine.
Microsoft Internet Explorer 5 or Netscape Navigator 4.5 (or later)
Adobe Acrobat Reader or Acrobat 4.0 or later (for the course presentation)*
Student Files
Text Editor*

	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