Home    |    Instructor-led Training    |    Online Training     
         
 
Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Unisys Mainframe
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle8i New Features Overview
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/Software Requirements
  • 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

Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved
Copyright © SB