Microsoft training courses, Cisco training courses, Prince2 training courses, ISEB training courses with locations nationwide
Call now to speak to an experienced Training Advisor
 
     
 
Home
  
How it works
  
About the quality of your course
 
Managed services
  
Partner CourseMonster
  
 
 
Thousands of Microsoft, ISEB, ITIL, Cisco and Prince2 Training Courses and more
  
 
Browse Oracle Training Courses

Oracle SQL 9i: Performance Tuning (2 day)

Course Code: OSP      Days: 2
Show all Oracle Courses
Scheduled Dates (sort by: location | date)
Request availability or book by selecting a date:
Central London
City
London (EC1) 04/12/08 £ 725
London (EC1) 05/02/09 £ 725
London (EC1) 19/03/09 £ 725
London (EC1) 14/05/09 £ 725
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.

Course Overview

This course is designed for SQL Programmers, Application Designers/Developers and Technical Support Professionals who are required to tune the performance of an Oracle application.

Skills Gained

This course will enable delegates to:

  • Identify PL/SQL Tuning Issues.
  • Use the SQL Tuning Advisor and SQL Access Advisor.
  • Tune Database Applications for Optimal Performance.
  • Manage Statistics.
  • Create and Use Indexes, Clusters, Views and Materialized Views.
  • Structure SQL Statements for Performance.
  • Use the Cost Based Optimizer.
  • Examine the Execution Plan for a SQL Statement Using SQL Trace and Autotrace.
  • Use Hints to Influence Execution Plan.
  • Use Parallel DML.
  • Identify Unused Indexes.

Prerequisistes

Oracl Oracle PL/SQL

Course Outline

  • Introduction to Oracle Performance Tuning
  • Tools for Evaluating SQL Statements
  • The Optimizer
  • Sorts
  • Indexes
  • Advanced Indexes and Clusters
  • Joins
  • Sequences and Views
  • Hints
  • Parallel DML
  • SQL Access Advisor
  • SQL Tuning Advisor


How to make a booking for the OSP course
 
  CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.  
     
CourseMonster® Patent Pending © SeaKom, All Rights Reserved - Channel partners with Business Training Partnership