Course Description
This Oracle 11g courseware training guide book will present some of the most advanced features available to database developers. In addition to receiving the print copy of this course book, all students will receive e-Learning modules.
Course 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 Outline:
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 INDEXE
• 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