D50000GC10
Edition 1.0
August 2007
What you will learn:
In this course students learn new features of SQL and PL/SQL in Oracle Database 11g. This course introduces you to the SQL Developer tool, using which you learn various enhancements in language functionality and triggers.
Students learn to practice the language usability enhancements and utilize the performance improvement features such as in lining and flashback, code trigger enhancements to achieve more control over the triggers. Enhancements to the dynamic SQL features are also discussed in this course. Students also learn about the reengineered LOB data type that offers advanced, next-generation functionality such as intelligent compression and transparent encryption. Additionally, students explore the data warehousing usability enhancements with the new SQL PIVOT and UNPIVOT operators.
Learn To:
Practice the performance improvements
Monitor dependency tracking and change notification
Write compound triggers and use the enhancements made to triggers
Use Secure File LOBS
Use the SQL Developer interface
Write SQL statements that include the new functions added to enhance regular expression support functionality
Download:
http://rapidshare.com/files/80567060/D50000GC10_ppt.rar
Password: www.bluelibrary.org
1 comment:
Another resource that is helpful. Thanks for explaining the Oracle Database 11g: SQL and PL/SQL New Features. I appreciate your efforts.
sap upgrade planning
Post a Comment