Overview/Description To test your knowledge on the skills and competencies being measured by the vendor certification exam. TestPrep can be taken in either Study or Certification mode. Study mode is designed to maximize learning by not only testing your knowledge of the material, but also by providing additional information on the topics presented. Certification mode is designed to test your knowledge of the material within a structured testing environment, providing valuable feedback at the end of the test. Target Audience Individuals seeking practice in a structured testing environment,...

Overview/Description 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 Target Audience Database administrators, application developers, and database operators Prerequisites Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases and the SQL programming language; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata Expected...

Overview/Description 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 Target Audience PL/SQL developers, developers, system analysts, data warehouse administrators, and application developers Prerequisites The learner should have experience and knowledge of SQL and PL/SQL from prior Oracle releases, and hands on experience using PL/SQL Expected Duration (hours) 1.3 Lesson ObjectivesOracle Database 11g: Using Dynamic SQL and Implementing Performance Improvements...

Overview/Description 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. Target Audience PL/SQL developers, developers, system analysts, data warehouse administrators, and application developers Prerequisites The learner should have experience and knowledge of SQL and PL/SQL from prior Oracle releases, and hands on experience using PL/SQL Expected Duration (hours) 1.2 Lesson ObjectivesOracle Database 11g: Using the PL/SQL...