|
Provided by: 123-CBT Computer Based Training Oracle Database 11g Using the PL SQL Debugger Collections and Data Warehousin |
![]() |
Training
Provided by 123-CBT Computer Based Training
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.
|
|
||||||||
Oracle Database 11g Using the PL SQL Debugger Collections and Data Warehousin
Overview:
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.Pre-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:
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.|
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
-...

