Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
Oracle Database 11g: Getting Started with SQL and PL/SQL New Features $74.95
Oracle Database 11g: Using Dynamic SQL and Implementing Performance Improvements $74.95
Oracle Database 11g: Using Trigger, Data Warehousing, and Pivoting Enhancements $74.95
Oracle Database 11g: Using the PL/SQL Debugger, Collections, and Data Warehousing $74.95

Bundle Price: $169.00
Total Savings: $130.80


Oracle Database 11g: Getting Started with SQL and PL/SQL New Features

To recognize the scope and capabilities of enhancements to SQL and PL/SQL, including tools such as SQL*Plus and SQL Developer, and use them to create reports and scripts, browse and manage database objects, find subpatterns, and track dependencies
  • Using SQL*Plus - recognize ways for using SQL*Plus commands to display the structure of a table and perform some editing and file management tasks.
  • Use SQL Developer - recognize the steps for using SQL Developer and SQL Worksheet to connect to a database, browse and export database objects, and use SQL*Plus to enter and execute SQL and PL/SQL statements.
  • Creating Reports and Migrating with SQL Developer - identify the steps for using SQL Developer to create reports and migrate to an Oracle Database 11g database.
  • Use Language Functionality Enhancements - recognize the steps for using Oracle Database 11g's new SQL and PL/SQL language functionality enhancements.
  • DCN and Lock Enhancements - recognize the scope and uses of Data Change Notification (DCN) and lock enhancements.
  • Using Language Functionality Enhancements - use SQL and PL/SQL language functionality enhancements to connect to a database and create a report, examine dependency at the element level, and modify an exception handler.

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
  • 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.

Oracle Database 11g: Using Trigger, Data Warehousing, and Pivoting Enhancements

To recognize the steps for improving performance, managing scalabilty, enhancing control and processing speed, and reducing network load using enhanced features such as compound triggers, SecureFile LOBs, and PIVOT operations
  • Developing Enhanced Triggers - identify the steps for creating and enabling a compound trigger and control its firing order using new trigger clauses.
  • Implementing SecureFile LOBs - recognize the steps for implementing SecureFile LOBs.
  • Perform PIVOT and UNPIVOT Operations - recognize the steps for performing PIVOT and UNPIVOT operations in various ways on the server side.
  • Implementing Pivoting - create reports with the PIVOT operator.

Oracle Database 11g: Using the PL/SQL Debugger, Collections, and Data Warehousing

To 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 enhancements to improve query execution times.
  • Using the PL/SQL Debugger in SQL Developer - identify the steps for using the PL/SQL Debugger tool in SQL Developer.
  • Debugging a Procedure - debug a procedure using the PL/SQL Debugger.
  • Working with Collections - recognize the steps for making effective use of collections in PL/SQL and deciding which is the best collection to use in a given scenario.
  • Using Data Warehousing Enhancements - recognize the steps for using materialized views and query rewrite enhancements to improve query execution times.
Register Now
Oracle Database 11g: SQL and PL/SQL New Features e-learning bundle
  • Course ID:
    252761
  • Duration:
    5 hours
  • Price:
    $169