Oracle Database 11g Using Dynamic SQL and Implementing Performance Improvements

To recognize the steps for improving SQL and PL/SQL flexibility, usability, and performance, using dynamic SQL, language enhancements, and a variety of performance enhancements

The learner should have experience and knowledge of SQL and PL/SQL from prior Oracle releases, and hands on experience using PL/SQL

PL/SQL developers, developers, system analysts, data warehouse administrators, and application developers

WEB

Executing Dynamic SQL in PL/SQL| - recognize the steps for using native dynamic SQL and the DBMS_SQL package to specify dynamic SQL statements, using CLOB data types and also abstract data types.|Language Usability Enhancements| - identify the steps for using language enhancements to improve sequence usability, control loop iterations, employ named and mixed notation in calls to PL/SQL, and place a table in read-only mode.|Improving Performance| - recognize the steps for improving the performance of SQL and PL/SQL with a new compiler, a new, faster data type, inlining for faster performance, caching, and flashback enhancements.|Implementing Improved Performance| - examine and then improve performance in Oracle Database 11g.|

123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace: E-Learning available for - ABAP 6. 10 - Access 2003 - Acrobat 6. 0 - ASP - ASP. NET - C - Captivate 1. 0 - Crystal Reports 8. 5 - Crystal Reports v10 -...