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
A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.
You will learn to:
- Explore the PIVOT and UNPIVOT Data warehousing operators
- Use the SQL Developer interface
- Write SQL statements that include the new functions added to enhance regular expression support functionality
- Use the enhancements added to native dynamic SQL and to DBMS_SQL which enable more interoperability between the two methodologies
- Use element level dependency tracking
- Write compound triggers and use the enhancements made to triggers
- Practice the performance improvements
- Use Secure File LOBS
- Write SQL and PL/SQL calls to sequences that are simpler
- Use the new CONTINUE statement to control loops