Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - Oracle: Application Development and Tuning


distance-learning center

Application of Classic Teaching Models Mobile Classrooms

Professional Distance-learning

IT Training Services


Oracle: Application Development and Tuning
DURATION: 4 days

FEE: $1,580

Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

There is a surcharge associated with training two or fewer students.


  • Programmer
  • Database Administrator
  • System Designer
  • System Analyst
  • IT Professional


    1. The Application Environment
      • Utilize the Data Dictionary to examine the architecture and database.
      • Use the Oracle utilities to load a database.
    2. Maintaining Data Integrity
      • Create a table for testing locking and read consistency.
      • There are several techniques for ending a transaction: 1- Issue a Rollback on the current transaction and review the results. 2- Examine what happens to the current transaction if a DDL statement is executed. 3- Examine what happens to the current transaction if the session is killed.
      • Experiment with the options available for maintaining read consistency.
      • Code DML for experimenting with a data lock.
    3. PL/SQL Programming Techniques
      • Code a program which uses a dynamic PL/SQL reference cursor.
      • Recognize the pitfalls to avoid with dynamic SQL.
    4. Oracle PL/SQL Extensions
      • Code the utilities which will improve performance and result in more efficient application maintenance.
    5. Improving Query Performance
      • Write and execute SQL using hints to determine when they should be used and the effects of hints.
    6. Tuning the Application
      • Use the Profiler API to profile run-time behavior and identify performance bottlenecks.
      • Oracle provides a Trace API for tracing the execution of programs on the server; trace the execution by subprogram or exception.
    7. SQL Statement Tuning
      • Change the execution plan for running queries without changing the code itself; this will serve to insulate an application execution plan against any structural changes or upgrades.
      • Utilize Stored Outlines for storing the execution plan in Oracle tables; this will later be referred to by the optimizer for executing the queries and optimizer plan stability.
    8. Tuning the Operating System
      • Adjust optimizer statistics and parameters.
      • Optimize the instance.
    9. Design
      • Given the case study provided by the instructor, design and create a logical and physical model.
    10. Optimizing SQL
      • Use the TKPROF utility to summarize trace information.
      • Utilize the EXPLAIN PLAN and code queries to perform analysis on the results.
    11. Data Access Methods
      • Experiment with various indexes to determine the best index for a specified situation.
    12. The Optimizer
      • Code SQL and influence the optimizer.
      • Ascertain the filter factor used by the optimizer.
      • Ascertain the guidelines used by the cost based optimizer.
    13. Gathering Statistics
      • Perform optimization analyses before and after statistics are generated.

Web-based Training Services


Quality Distance-learning

Bandwidth Requirements
Classroom Management System
Bi-directional Communication
Value Added Service

Common Questions
Courseware Superior by Design
Technology Updates

Learning Path

SYS-ED Website
Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID. Client organizations will be assigned to a preference center.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.
SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.