ORACLE DATABASE 11G R2: NEW AND ADVANCED FEATURES FOR DEVELOPERS– GTD6

Course Description

This Oracle 11g course will present some of the most advanced features available to database developers

^^

Duration

3 days

^^

Target Audience

The target audience for this course is senior application developers. Using these features one can rely upon less-frequently used database options to extend the capabilities and flexibility of business applications.

^^

Course Prerequisites

Those who wish to attend this course require attendance of the courses below, similar courses, or have the equivalent experience.

If you have any questions or doubts as to whether you meet the pre-requisites for this course, or indeed are wondering which course best suits you, please consult with us to discuss your suitability for course attendance.

^^

Suggested Follow on Courses

Please contact us for further details.

^^

Course Content

MOVING DATA: EXPORT & IMPORT

• MANAGE DIRECTORY OBJECTS

• ABOUT THE DATA PUMP ARCHITECTURE

• DATA PUMP EXPORT

• DATA PUMP IMPORT

SECURITY ENHANCEMENTS

• TRANSPARENT DATA ENCRYPTION

• What Is A Database Wallet?

• TDE Encryption Algorithms

• COLUMN ENCRYPTION

ORACLE SECUREFILES

• LOB CONCEPTS & TERMINOLOGY

• BASICFILES LOB

• Table DDL With LOBs

• Controlling LOB Physical Storage

• Initialize Internal LOBs

• Initialize External LOBs

• LOB Columns & SQL

• SECUREFILES LOBS

• MIGRATING BASICFILES TO SECUREFILES

INDEXES WITHIN THE APPLICATION SCHEMA

• B-TREE INDEXES

• Indexes & Performance

• Rebuild & Coalesce Indexes

• Creating Very Large Indexes

• Data Dictionary Storage

• FUNCTION-BASED INDEXES

• COMPRESSED INDEXES

• REVERSE-KEY INDEXES

• BITMAP INDEXES

• BITMAP JOIN INDEXES

• LINGUISTIC INDEXES

• INVISIBLE INDEXES

ADVANCED TABLES: CLUSTERS & IOTS

• ABOUT INDEX CLUSTERS

• ABOUT HASH CLUSTERS

• ABOUT INDEX-ORGANIZED TABLES

• Defining Index-Organized Tables

ADVANCED TABLES: EXTERNAL TABLES

• ABOUT EXTERNAL TABLES

• Creating The Table

• ORACLE_LOADER ACCESS PARAMETERS

• The General Access Parameters

• Access Parameters Which Define Fields

• Performance Considerations

• ORACLE_DATAPUMP ACCESS DRIVER

• MANAGING EXTERNAL TABLE PROPERTIES

ADVANCED TABLES: SPECIALIZED TABLES

• TEMPORARY TABLES

• COMPRESSED TABLES

• READ-ONLY TABLES

• COLUMN DEFAULT VALUES

• VIRTUAL COLUMNS

• UNUSED COLUMNS

 

PROCESSING HIERARCHIES

• WHY WE NEED HIERARCHIES

• PROCESSING 1:N HIERARCHIES

• Oracle-Specific Form

• ANSI/ISO Standard SQL Form

• PROCESSING M:N HIERARCHIES

• Bill-of-materials (Explosion & Implosion)

• More Explosion Examples

• More Implosion Examples

• ADVANCED HIERARCHY PROCESSING

USING THE DATABASE RESULT CACHE

• ABOUT THE RESULT CACHE

• CONFIGURING THE RESULT CACHE

• RESULT_CACHE_MAX_SIZE

• RESULT_CACHE_MODE

• RESULT_CACHE_MAX_RESULT

• RESULT_CACHE_REMOTE_EXPIRATION

• USING THE RESULT CACHE

• MANAGING & MONITORING RESULT CACHE

• Managing The Cache With DBMS_RESULT_CACHE()

• Monitoring The Cache With The System Views

SQL NEW & ADVANCED FEATURES

• ASYNCHRONOUS COMMIT OPTIONS

• HANDLING DML ERRORS

• INFLUENCING LOCKING BEHAVIOR

• REGULAR EXPRESSIONS

PL/SQL PROGRAMMING ENHANCEMENTS

• PROGRAM LOGIC ENHANCEMENTS

• DATABASE-RESIDENT TRIGGERS

• USING COMPOUND TRIGGERS

EDITION-BASED REDEFINITION

• WHY ONLINE REDEFINITION?

• EDITION-BASED ARCHITECTURE

• IMPLEMENTING EDITIONS

• USING EDITIONS

REDEFINITION WITH CROSS-EDITION TRIGGERS

• REDEFINITION THEORETICAL CHALLENGES

• FORWARD CROSS-EDITION TRIGGERS

• REVERSE CROSS-EDITION TRIGGERS

• POST-UPGRADE TASKS

• Prepare To Transform Legacy Data

• Transform Legacy Data

• Retire The Old Application

© 2011 Sideris Courseware Corporation

^^

See more Database Technologies courses