Oracle10g Developer New
Features Training
© 2010 by Burleson
Consulting
* Learn the most important
10g new features and when to use them.
* Learn important new 10g features for SQL and PL/SQL.
* Learn and understand 10g new features for Oracle forms and
reports.
* Understand the important new architecture changes in
10g.
* Learn important new JAVA
features in Oracle 10g.
* See the new XML features in Oracle 10g.
|
|
Unlike mediocre
Oracle10g new features training, this course examines all Oracle10g
new features with an eye on those features that are the most
important to Oracle10g developers.
This Oracle10g new features training is special because
this course is taught by a veteran Oracle Certified DBA with more
than 20 years of full-time experience.
 |
|
Oracle Database 10g
New Features
Oracle10g Reference for
Advanced Tuning & Administration
Mike Ault, Daniel Liu, Madhu
Tumma
ISBN 0-9740716-0-9
|
This course is designed for practicing
Oracle professionals who have basic experience with Oracle. Prior
experience with Oracle is not required, but experience using Oracle
database is highly desirable.
|
This course was designed by Donald K. Burleson, an acknowledged
leader in Oracle database administration. Author of more than
30 database books, Burleson was chosen by Oracle Press to write
five authorized editions, including Oracle High-Performance SQL
tuning. Burleson also served as the Editor for the
premier book Oracle10g
New Features for the DBA by Rampant TechPress. Burleson Consulting instructors offer
decades of real world DBA experience in Oracle features, and they
will share their Oracle secrets in this intense Oracle 10g
new features training.
Course Duration
This is an
intensive 3-day, 4-day or 5-day Oracle10g Developers new
features overview, customized to meet your specific needs.
This course is a comprehensive overview of new Oracle10g
development features, taught by one of our leading Oracle10g
trainers.
Oracle10g Developer New Features
5-Day Syllabus
Copyright © 2010 by
Donald K. Burleson
|
Oracle 10g SQL Enhancements
- Regular Expressions
- Regular Expressions Perl Compatibility
(R2)
- Case-Insensitive Sort
- Case-Insensitive Search
- Accent-Insensitive Sort/Search
- Affect on Index Use
- Text Literal Quote Character
- MERGE Enhancements
- Partition Outer Join
- MODEL Clause
- ORA_ROWSCN
- New Datatypes
- New Functions
- XQuery (R2)
- Error Logging Clause (R2)
- Miscellaneous SQL Features
Oracle 10g PL/SQL Enhancements
- Performance: Compiler
- Optimization Comparison
- Compiler Warnings
- FORMAT_ERROR_BACKTRACE
- GET_CPU_TIME
- FORALL Improvements
- Regular Expressions Support
- Quoting Mechanism
- Native Compilation Review
- Native Compilation: New Stuff
- Introducing UTL_MAIL
- Using UTL_MAIL
- Nested Table and VARRAY Enhancements
- Wrapping Packages (Obfuscation) with
DBMS_DDL.CREATE_WRAPPED (R2)
- PL/SQL Conditional Compilation (R2)
- DBMS_OUTPUT Improvements
- Miscellaneous New Features
Forms New Features
ODS
forms web architecture
Configuring forms services
-
Forms
services components
-
Configuring the forms servlet
-
Configuring the forms runtime engine
-
Configuring fonts & icons
Development & migration considerations
-
Development considerations
-
Client
vs. Application server
-
Developing for optimum performance
-
Removing
obsolete elements
-
Incorporating web-specific processing
XML
in Oracle10g
-
Overview of XML and
XSL
-
XMLElement()
Function
-
XMLForest()
Function
-
XMLConcat()
Function
-
XMLAgg() Function
Architecture
changes
Single Sign on
Support
Java
Support
The Java
Importer
Image
Support
Javascript
support
OC4J & BI Bean
support
Debugger
enhancements
|
|
|
This is a BC Oracle training
course (c) 2010
|
