Oracle SOA Suite 11g: SOA Security and Adoption Planning
This course provides an introduction to the topic of securing services and composite applications. It also describe the activities involved in SOA adoption planning.Â
Oracle-Supplied Packages and DBMS_SCHEDULER
To use Oracle-supplied packages
To create and work with Oracle 10g packages
To create and manage triggers
To identify the benefits associated with records and collections, declare and initialize nested tables and VARRAYs, and create and reference an INDEX BY table and table of records
To implement a suitable conditional control statement in PL/SQL, simple and searched CASE expressions, and a suitable loop construct
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
Using PL/SQL with an Oracle Server
To write lexical units in their correct format in a PL/SQL block, perform data conversion in PL/SQL, write PL/SQL anonymous blocks, and recognize the correct structure of a PL/SQL program block
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 ...
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 ...