|
Provided by: 123-CBT Computer Based Training Oracle Database 11g Using Trigger Data Warehousing and Pivoting Enhancements |
 |
Training
Provided by 123-CBT Computer Based Training
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
|
|
||||||||
Oracle Database 11g Using Trigger Data Warehousing and Pivoting Enhancements
Overview:
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 operationsPre-Requisites:
The learner should have experience and knowledge of SQL and PL/SQL from prior Oracle releases, and hands on experience using PL/SQLTarget Audience:
PL/SQL developers, developers, system analysts, data warehouse administrators, and application developersModality:
WEBLesson:
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.|
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
