Oracle Training Overview

Oracle8i is the new version of the Oracle server, Oracle8.1.x. This seminar will teach you the critical new features in 8i such as embedded Java, temporary tables and more. Considering the convergence of Oracle, Java and other object technologies (e.g. CORBA) and the complications this can introduce into the learning curve, this class will also help the student understand what additional training paths may be required.

Oracle Training Prerequisites

Hands-on experience with a previous version of Oracle. Familiarity with Oracle8 features such as partitioning is helpful, though not absolutely necessary.

Oracle Training Course duration

1 Day

Oracle Training Course outline

• Introduction
• Oracle8 Partitioning
• What is Partitioning?
• Oracle8 Support
• MAXVALUE and NULLs
• Partition Storage Attributes
• Multiple-Column Partitioning
• Maintenance: Rolling In
• Maintenance: Rolling Out
• Merge Partitions
• Data Dictionary Implications
• Explicit Referencing
• Table Partitioning Restrictions
• Partitioned Indexes
• Local vs. Global Partitioned Indexes
• Oracle8i Partitioning Enhancements
• What's New?
• Hash Partitioning
• Composite Partitioning
• Data Dictionary
• Merge Partitions
• Row Movement
• Optimizer
• Plan Stability Concepts
• Implementing Plan Stability
• DBMS_STATS Concepts
• Using DBMS_STATS
• Automated Statistics Gathering
• Index Statistics
• Database Enhancements
• Drop Column
• Temporary Tables
• Table Reorganization
• Transportable Tablespaces
• Locally Managed Tablespaces
• Multiple Archive Destinations
• Standby Database Enhancements
• Database Event Triggers
• RMAN Enhancements
• Introduction to LogMiner
• Constraint Management Enhancements
• Additional Enhancements
• Index Enhancements
• Function-Based Indexes
• Descending Indexes
• Reverse Key Indexes
• Index-Organized Table Enhancements
• Online Index Rebuilds
• Online Rebuild Limitations
• Index Coalesce
• Installation Enhancements
• Oracle Universal Installer
• Directory Changes
• NT Resource Requirements
• New Users in Starter Database
• Utility Enhancements
• SQL*Loader
• ANDing DEFAULTIF and NULLIF
• Export and Import
• WHERE Clause on Export
• Importing Statistics
• Summary Management Materialized Views
• What is Summary Management?
• What is a Materialized View?
• Creating an M-View
• Updating M-Views
• Query Rewrite
• Indexing M-Views
• Using DBMS_OLAP
• Other Notable Things
• Sources
• Oracle8i and Java
• Oracle's Java Strategy
• 8i's Java Related Components
• Oracle8i "JVM"
• Java Access to Database: JDBC and SQLJ
• Oracle's JDBC Drivers
• What is SQLJ?
• SQLJ Components
• Java Stored Procedures
• CORBA & EJB
• Architecture Changes
• Java Installation
• Oracle8i Components and Commands for Java
• Privileges for Java
• Sources
• Query Features
• ROLLUP & CUBE
• ROLLUP
• CUBE
• Top-N Queries
• New Subquery Support
• The SAMPLE Clause
• The SQL TRIM Function
• LOB Background
• New with 8i: LONG to LOB Conversion
• Temporary LOBs
• Other LOB Enhancements
• Parallel Query Concepts
• 8.1.7 Parallel Support
• What Got Better?
• PL/SQL Enhancements
• Invoker Rights
• Bulk Binding
• Dynamic SQL Background
• And now, NDS!
• SELECT & NDS
• Autonomous Transactions
• Autonomous Transactions Benefits & Syntax
• Autonomous Transactions Notes
• Monitoring & Tracing PL/SQL

• Hardware Requirements
• This course is presentation only. It requires a single instructor PC connected to a projection device.
• A connection to the Internet is desirable (but not required) to show students various Oracle-related sites.
• Software Requirements
• Adobe Acrobat Reader or Acrobat 4.0 or later (for the course presentation)
• Microsoft Internet Explorer 5 or Netscape Navigator 4.5 or above