Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 

Introduction to Oracle 8i New Features

© 2007-2016 by Burleson Corporation

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

 

 

Key Features

* Employ optimizer Plan stability.

* Learn new table access methods.

* Review table and index partitioning and how it effects developers.

* Reduce PL/SQL-to-SQL engine switches within cursors.

* Implement security policies with functions and then use those functions to implement row-level security on tables or views.

  

Course Description

This Oracle8i New Features training was designed by Donald K. Burleson. A retired Adjunct Professor Emeritus, Burleson has taught hundreds of Oracle classes and developed Oracle curriculums for several major universities. Author of more than 30 bestselling Oracle books, Burleson was chosen by Oracle Press to write five officially authorized books.  Burleson Corporation instructors offer decades of real world DBA experience in Oracle features, and they will share their Oracle secrets in this intense Oracle 8i new features training.

Book Required

  • N/A

Audience

This course is designed for the working Oracle professional and the amount of previous experience with Oracle is incidental.
Previous experience with relational database management and SQL is helpful, but this class is self-contained and has no formal prerequisites.

Curriculum Design

This course was designed by Donald K. Burleson, an acknowledged leader in Oracle database administration.  Author of more than 20 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle High-Performance SQL tuning.  Burleson Corporation instructors offer decades of real world DBA experience in Oracle features, and they will share their Oracle secrets in this intense Oracle 8i new features training.



Oracle8i New Features
Syllabus

© 2007-2016 by Donald K. Burleson

 

 

DAY 1 – Oracle8i database object enhancements

New Oracle SQL features

            Cursor sharing

            Optimizer Plan stability

            Improvements to the CBO

            New table access methods

                        Function-based indexing

                        STAR joins for data warehouse

            New SQL built-in functions

            New SQL syntax

Oracle8i and object-orientation

Creating abstract data types

Object-oriented SQL

Oracle8 Nested Tables

VARRAYS within tables

Using object ID’s in Oracle queries

 

DAY 2: - Core changes in Oracle8i

Oracle Database Enhancements

Materialized views – Show the use of MV and how they are used to improve performance of data warehouse queries.

Partitioning – Review of table and index partitioning and how it effects developers.

Large objects – The uses for LOB, BLOB, and NCLOB datatypes, and how table rows are stored offline

Parallel Query and Parallel DML – The Oracle8i improvements to parallel query and parallel DML

STATSPACK – How the STATSPACK utility improves system monitoring

New Oracle packages in Oracle8i – These include dbms_java, dbms_profiler, dbms_sql, dbms_lob, dbms_trace, dbms_utility and dbms_aq

 

DAY 3 – PL/SQL and Java

 

PL/SQL Tables – Defining and using PL/SQL tables

Autonomous transactions - procedures that run inside their own independent transactions

Invoker rights and PL/SQL - running packaged procedures as self, as package owner, etc

Native dynamic SQL  - Bulk binds and collects - Reducing PL/SQL-to-SQL engine switches within cursors (“bulking” up updates/selects/etc, also function syntax enhancement for those functions that have no dependency on the database)

System-level database triggers - With this feature and Advanced Queueing (AQ), you can take advantage of the publish/subscribe capabilities of Oracle8i

Fine-grained access control - This feature lets you implement security policies with functions and then use those functions to implement row-level security on tables or views.

PL/SQL and Java – Calling Java methods from within PL/SQL

REF cursors - Parameter passing (new options for passing large parameters by reference, such as PL/SQL tables)

 

Please note that while the knowledge gained from this Oracle training may be valuable when preparing for Oracle certification exams, the content of this course is not for Oracle Certification, including the Certified Professional (OCP) or Oracle Certified Associate (OCA) programs.

This is a BC Oracle training course (c) 2002-2016

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational