Oracle Database 10g: New & Advanced Features For Developers

Request more details:

Description:
The purpose of this course is to present some of the most advanced features available to database developers. Many of these features are either newly available with the Oracle10g release or have been substantially improved with that release. Among the specific subjects presented in this course are: A review of the grid-computing and manageability architecture available from the Oracle 10g release of the database and the application server. Database flashback technology, including flashback queries, flashback table, flashback versions query and flashback transaction query capabilities. Creating and using directory objects within the database. The Data Pump Export and Import utilities. A comprehensive look at all index types available when building an application schema, including B-tree internals, function-based, compressed, reverse key, linguistic, bitmap and bitmap join indexes. A comprehensive look at all table types available when building an application schema, including heap-organized tables, index clusters, hash clusters, index-organized tables, external tables, temporary tables and compressed tables. Advanced SQL hierarchal data processing capabilities available from the CONNECT BY PRIOR and related language structures. Enhanced SQL and transactional capabilities, including asynchronous commits, DML error trapping and use of regular expressions. Enhanced PL/SQL programming capabilities and compiler directives. A brief glimpse into the Enterprise Manager database interface which may be of occasional use to senior developers.

View other Oracle Courses available
Prerequisites:
The target audience for this course is senior application developers.
ORACLE FLASHBACK TECHNOLOGY :
about flashback technology
flashback query
flashback table
flashback drop
flashback versions query
flashback transaction query
querying flashback_transaction_query
guarantee undo retention
MANAGING DATA: EXPORTING & IMPORTING DATA :
create directory objects
about the data pump architecture
data pump export
data pump import
data pump data dictionary views
using the em interface
INDEXES WITHIN THE APPLICATION SCHEMA :
b-tree indexes
function-based indexes
compressed indexes
reverse-key indexes
bitmap indexes
bitmap join indexes
linguistic indexes
accessing index objects using the em interface
ADVANCED TABLES: CLUSTERS & IOTS :
about index clusters
about hash clusters
about index-organized tables
ADVANCED TABLES: EXTERNAL TABLES :
about external tables
oracle_loader access parameters
records parameter
badfile parameter
logfile parameter
discardfile parameter
load when parameter
skip parameter
the location clause
reject limit clause
fields terminated by parameter
missing field values parameter
oracle_datapump access driver
viewing & altering properties of external tables
user_external_tables
user_external_locations
using alter table
ADVANCED TABLES: TEMPORARY & COMPRESSED TABLES :
why we need hierarchies
processing 1:n hierarchies
processing m:n hierarchies
bom data model
advanced hierarchy processing
connect_by_root()
connect_by_isleaf
SQL NEW & ADVANCED FEATURES :
asynchronous commit options
handling dml errors
regular expressions
column encryption
miscellaneous enhancements
PL/SQL NEW & ADVANCED FEATURES :
handling string literals
database trigger enhancements
compression with utl_compress()
lz_compress()
lz_uncompress()
collection enhancements
miscellaneous enhancements
INFLUENCING ORACLE10G PL/SQL COMPILATION :
plsql_warnings
plsql_optimize_level
pl/sql native execution