KT-3084 Oracle10g SQL Tuning for Developers and DBAs Training - Minneapolis, Minnesota IT MN Technical Financial New York, NY
Knowledge Transfer Microsoft Certified Silver Training Partner CPLS
Knowledge Transfer is a Microsoft Certified Silver Learning Partner
Oracle University

 

Microsoft Certified Training Partner CTEC
Search for a Course Topic:
Public Courses
Corporate Services & Training
 

 

 



 Course Search
Keyword
Course #
State

 Training Delivery
 
Training Delivery
Custom Curriculum
Course List
Certifications
 
 Main Menu
 
Home
View Courses
Site Index
 
 


Oracle10g SQL Tuning for Developers and DBAs


Description: 

This hands-on course will provide you with the skills necessary to create scalable, high performance SQL-based Oracle applications (proactive tuning).  You will also learn how to identify existing high-load, poor performing SQL statements and tune them (reactive tuning). Particular attention is paid to making the best use of Oracle architecture, bench-marking various SQL formulations and identifying the best schema object (e.g. heap table, IOT, etc.) for a given situation.

Oracle10g introduces automatic tuning features such as the Automatic Workload Repository, Automatic Database Diagnostic Monitor and SQL Tuning Advisor.  These features are covered in this class.  

The course also includes a lesson on tuning PL/SQL programs.  This includes using bulk processing and profiling to identify high-load statements.

Working examples are included throughout the course book.  Students have access to electronic versions of all sample scripts and lab solutions.  Approximately 50% of class time is spent on hands-on exercises.

As with all of our courses, this class is highly customizable to your specific training requirements.  Hands-on workshops constitute approximately 50% of the class.

 
Click here to view the Course Outline
     
Prerequisite: 

Solid experience with Oracle SQL.  PL/SQL programming is required to understand the lesson on PL/SQL tuning. This knowledge can be obtained via the following SkillBuilders courses:

  • Introduction to Oracle for Developers  The skills taught in the introductory class are required for successful completion of this Tuning course.
  • Advanced SQL Queries for Oracle10g databases  The skills taught in this Advanced course are not required, but helpful.  For example, prior knowledge of the Oracle Analytic functions will help you when you learn to improve the performance of a complex join by converting it into an analytic function call.
  • PL/SQL Programming Workshop  Required to successfully complete the PL/SQL Tuning lesson
 
   
     
Duration: 
3 Days  
     
     

View Printer Friendly Page

 


To Inquire About Future Classes

Request a class date

if one is not scheduled.