Training
Provided by 123-CBT Computer Based Training
Course Overview
This course is the second in a two-part series on SQL Statement Tuning. This course will help application developers to design SQL statements that can reuse parsing and influence the optimizer to improve performance.
Learn To:
- Identify the factors that affect network traffic.
- Identify the factors that affect parsing.
- Identify the guidelines for the reuse of parsed code.
- Identify the factors in SQL code design that affect response time.
- Identify the methods to improve network performance.
- Identify the differences in optimization approaches.
- Influence the cost-based optimization to improve performance.
Content Emphasis
Skills-Based
Audience
Application Developers, Database Administrators, and Designer/Developers.
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: SQL and Parsing
Duration: 2 - 3 Hour(s)
- Identify the advantages of using array processing.
- Enable array processing in SQL*Plus.
- Identify the advantages of using server-side code.
- Identify whether a given code uses an explicit or an implicit cursor.
- Identify the advantage of using explicit cursors.
- Identify the advantages of using explicit cursors.
- Identify the language that will process a given task in the minimum possible time.
- Identify the methods used for maintaining a shared pool.
- Identify the contents of a shared SQL area.
- Sequence the steps performed in the Oracle Server for processing a SQL statement.
- Identify the benefits of sharing cursors.
- Identify whether or not the given pair of statements will share cursors.
- Identify the guidelines for coding SQL in order to share cursors.
- Match the columns of the V$LIBRARYCACHE view with the information that they contain.
- Match the columns of the V$SQLAREA view with the information that they contain.
Unit 2: Efficient SQL Code Design: Guidelines
Duration: 2 - 3 Hour(s)
- Identify the type of the SQL statements that are most likely to benefit from tuning.
- Identify the conditions that will block the use of indexes in a given code.
- Identify the guidelines for writing the SQL code that requires low response time.
- Identify whether or not a query to accomplish a given task should use a given view.
- Identify the type of query that will be appropriate in a given situation.
- Select the query that will produce minimum network traffic in a given situation.
- Identify the guidelines to be followed when testing SQL statements.
Unit 3: Influencing the Optimizer
Duration: 2 Hour(s)
- Identify the functions of the optimizer.
- Identify the transformations that an optimizer makes to a SQL statement.
- Match the operators with the transformation made to them by the optimizer.
- Determine whether a given condition has good or bad selectivity.
- Determine the type of selectivity that a given condition with bind variable will have.
- Identify the steps used by the optimizer in rule-based optimization.
- Identify the benefits of cost-based optimization.
- Identify the steps used by the optimizer in cost-based optimization.
- Set the optimization approach at the instance level by using the OPTIMIZER_MODE initialization parameter.
- Collect the statistics of a table by using the ANALYZE command.
- Identify the guidelines for using histograms.
- Collect histogram data for a specific column in a table.
- Match the various join methods with the situation in which they are used.
- Match the data retrieval methods available to the optimizer with their features.
- Match the access path hints with the optimizer functions they enable.
- Specify a hint for the FULL access path in a given query.
- Sequence the steps in preparing for a star query.
- Identify the hint that gives the highest performance when used in a give type of star query.
- Set up a hash join at the instance level.
Training Avaliability and Delivery
| This is primarily online training |  | This is an online eLearning or CBT training program |  | This program may be available on CD |  | Contact 123-CBT Computer Based Training for more information |
|
| Training Presented in: | English |
|
Related Keywords:
oracle sql pl sql
databases enterprise
oracle
information technology
cd web
Training Program Details
--
About 123-CBT Computer Based Training - Training Provider
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
- Dreamweaver MX
-...
More Oracle SQL PL SQL Training from 123-CBT Computer Based Training
Click here for more information or to take this course
| 
