Introduction to Oracle
8i New Features
© 2007-2009
by Burleson Consulting
* 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.
|
|
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 Consulting
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.
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.
|
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 Consulting
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-2009 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-2009
|
