Oracle Database 11g: New & Advanced Features for Developers Courses and other IT courses from TEKsystems Education Services

Note: All fields are required

First Name:

Last Name:

Company:

Title:

Email Address:

Phone Number:

Address:

City:

State:

Zip Code:

Which Topic(s) Currently Interests Your Organization:

Tell Us More:

I have an immediate training or educational service need and I wish to be contacted today

I am a current TEKsystems Education Services client and wish to speak to someone

I have a training budget approved and I am ready to talk to someone about the details of my organization’s training need

I do not have an approved training budget, but I have a need and would like to talk to TEKsystems Education Services about their solutions

Unfortunately, I do not have a group training request

At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.

My Delivery Method Needed Is:

Instructor-Led Classroom Training

Instructor-Led Virtual Training

Self-Paced Online Training

Code Number:

We Value Your Privacy!

Course Code:	RT 515
Course Abstract:	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 Oracle 11g release or have been substantially improved with that release.
Audience:	This course is designed for individuals who are senior application developers. Using these features one can rely upon less-frequently used database options to extend the capabilities and flexibility of business applications.
Duration:	5 days
Learning Outcomes:	Upon completion of this course, the participant will be able to: > Creating and using directory objects within the database. > 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. > 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. > 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. > How to use the result cache to achieve dramatic performance improvement for frequently executed SQL queries and PL/SQL functions. > Enhancements to the PL/SQL programming language and coding capabilities. > New and advanced SQL language application development capabilities. > Review the goals of change management, change assurance and how these are implemented with Real Application Testing technology available with the Oracle 11g database. > Learn how to perform the capture of a production database workload while not interfering with the applications or users involved. > Learn how to replay the production workload on a test database configuration, providing a real-world test of how an actual application will function in an envisioned database configuration. > Learn how to configure clients which will simulate the network interaction of real-world users in a test configuration. > Perform a detailed analysis of application execution within proposed database configurations to assess whether the application performance will progress or regress as a result of the proposed change. > Use the SQL Performance Analyzer tool to measure progression or regression of individual SQL statements under a proposed database configuration, providing a detailed level of change assurance before the change ever occurs
Course Topics:	*Using SQL Developer & Oracle SQLPlus** About SQL Developer Using SQLPlus Moving Data: Export & Import* Manage Directory Objects About The Data Pump Architecture Data Pump Export Data Pump Import Security Enhancements Transparent Data Encryption Column Encryption Oracle Securefiles LOB Concepts & Terminology Basicfiles LOB Alter Table Securefiles LOBS Migrating Basicfiles To Securefiles Indexes within the Application Schema B-Tree Indexes Function-Based Indexes Compressed Indexes Reverse-Key Indexes Bitmap Indexes Bitmap Join Indexes Linguistic Indexes Invisible Indexes Advanced Tables: Clusters & IOTS About Index Clusters Truncate Cluster 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 Advanced Tables: Specialized Tables Temporary Tables Compressed Tables Read-Only Tables Column Default Values Virtual Columns Unused Columns SET UNUSED Clause Processing Hierarchies Why We Need Hierarchies Processing 1: N Hierarchies Processing M: N Hierarchies Advanced Hierarchy Processing CONNECT_BY_ROOT () CONNECT_BY_ISLEAF 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 the Result Cache V$RESULT_CACHE_MEMORY V$RESULT_CACHE_OBJECTS V$RESULT_CACHE_DEPENDENCY SQL New & Advanced Features Asynchronous Commit Options Handling DML Errors Influencing Locking Behavior DDL_LOCK_TIMEOUT Parameter Regular Expressions PL/SQL Programming Enhancements Program Logic Enhancements SIMPLE_INTEGER Integer Data Type Database-Resident Trigger Enhancements Using Compound Triggers Change Management Understanding the Application Architecture Systems Infrastructure Changes Change Management Lifecycle Workload Capture Preparing the Capture Database Workload Capture Using the EM Wizard Workload Capture Using the API Configure the Replay Database Requirements of a Replay Database RMAN Duplicate Database Replay Preprocess Captured Workload Replay Prerequisites Replay Workload Monitor the Replay Operation Replay Analysis Launch Replay Analysis Conduct Configuration Change Analysis Use the PL/SQL API SQL Performance Analyzer About SQL Performance Analysis Managing SQL Tuning Sets SQL Performance Analyzer Tasks SQL Performance Analysis
Prerequisites:	The following courses are mandatory prerequisites: Oracle Database 11g: Introduction to SQL – Complete Library Oracle Database 11g: Program with PL/SQL – Complete Library

Oracle Database 11g: New & Advanced Features for Developers Course

Hot Courses

Top Skills

Testimonials

Agile
AJAX and Web 2.0
Business Analysis
Business Practices
Cisco
Communications
Customer Service/Communications
Data Warehousing
Database Developer
End User
Enterprise Architecture
Internet Application Developer
Lotus
Mainframe
Messaging Infrastructure
Networking
Operating Systems
Programming Languages
Programming Methodologies
Project Management
Project Management
Quality Assurance
Relational Databases
Reporting Tools
SAP
Scrum Master
Security
Server Applications
SQL & PL/SQL Programming
Testing
Testing and Quality Assurance
Virtualization
Web Technologies
Wireless Technology