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

Total time
Logo Oracle University

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

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 Wareh…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Usability, Data Warehouse, PL/SQL, Oracle 11G, and Web Accessibility.

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

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.