Oracle Database 11g: SQL and PL/SQL New Features - Self-Study Course

The release of Oracle Database 11g brings with it numerous new features and enhancements to SQL and PL/SQL. This course is designed to teach you about the various enhancements in language functionality and triggers and demonstrates language usability enhancements and performance improvement features, such as inlining and flashback. It also demonstrates how to maintain greater control over triggers as well as enhancements to dynamic SQL. The re-engineered LOB data type that offers advanced, next-generation functionality, and data warehousing usability enhancements with the new SQL PIVOT and UNPIVOT operators is also covered here
Audience

• PL/SQL Developer
• Developer
• System Analysts
• Data Warehouse Administrator
• Data Warehouse Developer

Course Topics
Course Objectives

• Recognize the steps for improving SQL and PL/SQL flexibility, usability, and performance
• Recognize the steps for improving performance, managing scalability, enhancing control and processing speed, and reducing network load
• Recognize ways to utilize the PL/SQL Debugger to analyze your code, identify the uses and benefits of collections, and identify the steps for employing data warehousing enhanceme
• Recognize the scope and capabilities of enhancements to SQL and PL/SQL, including tools such as SQL*Plus and SQL Developer