title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Oracle Database 11g R2: New & Advanced Features For Developers
Duration
5 Days
Course
DBOR-921
Available Formats
Classroom Training, Online Training
Course Description
Overview
This Oracle Database 11g R2: New & Advanced Features For Developers course is designed to provide students with some of the most advanced features available to database developers.Objectives
Upon completion of the Oracle Database 11g R2: New & Advanced Features For Developers course, students will be able to:
- Create and use directory objects within the database
- Get a comprehensive look at all index types available when building an application schema, including B-tree internals, function-based, compressed, reverse key, invisible, linguistic, bitmap and bitmap join indexes
- Get 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, read-only and compressed tables
- Understand advanced SQL hierarchal data processing capabilities available from the CONNECT BY PRIOR and related language structures
- Use enhanced SQL and transactional capabilities, including asynchronous commits, DML error trapping and use of regular expressions
- Understand how to use the result cache to achieve dramatic performance improvement for frequently executed SQL queries and PL/SQL functions
- Preview enhancements to the PL/SQL programming language and coding capabilities
- Use new and advanced SQL language application development capabilities
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.
Prerequisites
- DBOR-917 ORACLE DATABASE 11g R2: INTRODUCTION TO SQL - COMPLETE LIBRARY
- DBOR-920 ORACLE DATABASE 11g R2: PROGRAM WITH PL/SQL - COMPLETE LIBRARY
Topics
- MANAGE dictionary objects
- ABOUT the data pump architecture
- DATA pump export
- DATA pump import
- TRANSPARENT data encryption
- WHAT is a database wallet?
- TDE encryption algorithms
- COLUMN encryption
- LOB concepts & terminology
- BASICFILES LOB
- TABLE DDL with LOBs
- CONTROLLING LOB physical storage
- INITILIAZE internal LOBs
- INITILAIZE external LOBs
- LOB columns & SQL
- SECUREFILE LOBs
- MIGRATING basicfiles to securefiles
- B-TREES 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
- ABOUT index clusters
- ABOUT hash clusters
- ABOUT index-organized tables
- DEFINING index-organized tables
- ABOUT external tables
- CREATING the tables
- ORACLE_LOADER access parameters
- THE general access parameters
- ACCESS parameters which define fields
- PERFORMANCE considerations
- ORACLE_DATAPUMP access driver
- MANAGING external table properties
- TEMPORARY tables
- COMPRESSED tables
- READ-only tables
- COLUMN default values
- VIRTUAL columns
- UNUSED columns
- WHY we need hierarchies
- PROCESSING 1:N hierarchies
- ORACLE-SPECIFIC form
- ANSI/ISO standard SQL form
- PROCESSING M:N hierarchies
- BILL-of-materials (explosion & impolsion)
- MORE explosion examples
- MORE implosion examples
- ADVANCED hierarchy processing
- ABOUT the result cache
- CONFIGURING the result cache
- RESULT_cache_max_size
- RESULT_cache_mode
- RESULT_cache_max_result
- RESULT_cache_remote_experation
- USING the result cache
- MANAGING & monitoring result cache
- MANAGING the cache with DBMS_RESULT_CACHE()
- MONITORING the cache with the system views
- ASYNCHRONOUS commit options
- HANDLING DML errors
- INFLUENCING locking behavior
- REGULAR expressions
- PROGRAM logic enhancements
- DATABASE-resident triggers
- USING compound triggers
- WHY online redefinition?
- EDITION-based architecture
- IMPLEMENTING editions
- USING editions
- REDEFINTION theoretical challenges
- FORWARD corss-edition triggers
- REVERSE cross-edition triggers
- POST-upgrade tasks
- PREPARE to transform legacy data
- TRANSFORM legacy data
- RETIRE the old application
Related Courses
-
Oracle Database 11g: SQL Fundamentals I
DBOR-915- Duration: 3 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,100.00 USD
-
Oracle Database 11g: SQL Fundamentals II
DBOR-916- Duration: 3 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,100.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
Exam Terms & Conditions
??exam-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.