Feedback

Feedback to trainingforit.co.uk


Site comment Site ratings
Email (optional)

Content

Design

Ease of use

Overall

Oracle 10g SQL Performance Tuning

Summary
Length:
2 days
Price:
795 GBP excl. VAT
Training Provider:
StayAhead Training plusStayAhead Training
Location:
Training Method:
Startdate:  
London: 13/02/2012, 02/04/2012, 07/06/2012, 28/08/2012, 08/10/2012, 17/12/2012
Manchester: 04/04/2012 09:3009:30

About Oracle 10g SQL Performance Tuning

Oracle 10g SQL Performance Tuning Course Overview
This course introduces the delegate to the main concepts of Oracle SQL performance tuning.  It is designed to give delegates practical experience in analyzing and tuning the performance of SQL.  This course is suitable for users of Oracle Database 10g and Oracle Database 11g.

Skills Gained
The delegate will practise:
  • Tuning Database Applications for Optimal Performance
  • Managing Statistics
  • Creating and Using Indexes
  • Structuring SQL Statements for Performance
  • Using the SQL Optimizers
  • Examining the Execution Plan of a SQL Statement using EXPLAIN PLAN
  • Examining the Efficiency of SQL Statements using SQL Trace and Autotrace
  • Using Hints to Influence Execution Plan
  • Identifying Unused Indexes

Who will the Course Benefit?
This Oracle 10g SQL Performance Tuning course is designed for SQL programmers, application developers/designers and technical support professionals who are required to tune the performance of an Oracle application running under Oracle 9i, 10g or 11g.

Course Objectives
To provide the skills needed to monitor and tune an Oracle database application.

Requirements
A working knowledge of SQL is required.  This can be obtained by attendance on the pre-requisite Oracle SQL course.

Pre-Requisite Courses
  • Oracle SQL




Follow-On Courses
  • Oracle Reports


  • Oracle Forms - Part I




NOTE: Course technical content is subject to change without notice.

Oracle 10g SQL Performance Tuning Training Course
Course Contents - DAY 1
Course Introduction
  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: INTRODUCTION TO ORACLE PERFORMANCE TUNING
  • Tuning Overview
  • Oracle Tuning Process
  • Planning a Routine Monitoring Regime
  • Setting Suitable Goals
  • Tips for Avoiding Problematic Queries

Session 2: TOOLS FOR EVALUATING SQL STATEMENTS
  • Overview of SQL Statement Tuning
  • Tools to Assist in SQL Tuning
  • Explain Plan
  • Autotrace
  • SQL Trace
  • The tkprof Program
  • Interpreting SQL Trace

Session 3: THE OPTIMIZER
  • SQL Optimizer
  • OPTIMIZER_MODE Initialization Parameter
  • Rule Based Optimizer
  • Cost Based Optimizer
  • The Analyze Command
  • Managing Statistics with DBMS_STATS
  • Automatic Statistics Gathering

Session 4: SORTS
  • How Oracle Processes Sorts
  • Temporary Disk Space Assignment
  • SQL Operations that Use Sorts

Session 5: INDEXES
  • Index Overview
  • B*Tree Indexes
  • Access Paths with Indexes
  • Index Scans
  • Conditions That Stop Indexes Being Used
  • Parameters Affecting Optimizer Index Choice

Session 6: ADVANCED INDEXES
  • Bitmap Indexes
  • Key Compressed Indexes
  • Index Organized Tables
  • Function Based Indexes
  • Descending Indexes
  • Invisible Indexes

Oracle 10g SQL Performance Tuning Training Course
Course Contents - DAY 2
Session 7: JOINS
  • Joining Tables
  • Nested Loops Join
  • Merge Join
  • Cluster Join
  • Hash Join
  • Anti Join and Semi Join
  • Outer Joins
  • Star Join

Session 8: SEQUENCES AND VIEWS
  • Sequence Caching
  • Views
  • View Merging
  • Inline Views

Session 9: USING HINTS
  • Using Hints to Influence Execution Plan

  • Optimization Mode and Goals
  • Access Methods
  • Query Transformations
  • Join Orders
  • Join Operations
  • Hint Examples

Session 10: MISCELLANEOUS
  • Syntax Considerations
  • Array Size
  • hared Pool
  • Intelligent Cursor Sharing
  • Virtual Columns
  • Result Caching
  • Some PL/SQL Issues

Continuing studies

Follow on courses: Oracle Reports, Oracle Forms - Part I

Expenses

£795.00

About StayAhead Training

technical it training

SQL, Oracle, UNIX and Linux experts

StayAhead Training are recognised as one of the top 50 IT Training organisations in the UK and the first choice provider of UNIX, Linux, MySQL and Oracle training courses for many of the UK's most prominent organisations.

StayAhead Training was established in 1992 and now have training centres in London, Birmingham, Manchester, Leeds, Edinburgh and Bristol. Because of this, StayAhead are able to offer a large range of scheduled, tailored and onsite training. Independent of where you are based, StayAhead can help you and your firm's IT requirements be reality.

StayAhead IT Training works with some of the largest names in the IT training industry to provide courses on behalf of Parity Training, Global Knowledge, New Horizons and many more.

unix, linux, oracle, sql, javaSpecialist IT training

StayAhead Training have a formidable reputation for quality and expertise within the UNIX, Oracle, Linux and MySQL arena and enjoy an enviable position in the UK by being amongst the top IT Technical training organisations.

The UNIX curriculum not only covers standard UNIX but includes a range of Solaris, AIX, HP-UX, Linux, SUSE, LPI & Red Hat Linux training. The Oracle curriculum also has depth with courses available for DBAs, Developers and Designers. If certification is important to you then again we do not disappoint taking delegates to the level required to take the examinations in Solaris, Red Hat, SUSE, LPI, MySQL, Oracle Forms Developer and Oracle DBA. With the Oracle e-business suite growing in popularity a range of Oracle Financials courses are also available.

StayAhead's training flexibility comes from developing their own courses that include high quality course material, written not only to support the learning process, but can also act as a helpful reference guide on the delegates return to work.

In-house IT training

In addition to the public schedule of courses provided, StayAhead offer all courses in-house at a client's site, or at a StayAhead location. All courses can be tailored to meet our clients' specific needs. For courses at the client's site StayAhead can provide all the necessary hardware and software.

StayAhead's focus on IT training

StayAhead understands the best approach for such technical IT training is always to be enthusiastic, business-like, informal yet professional. Whether delegates attend a StayAhead Training scheduled course or an on-site course, each event is approached in a professional manner.

StayAhead's style of delivery is designed to foster the development of learning. Instructor led tutorials are followed by practical exercises. The style is experiential allowing delegates to take ownership and solve problems for themselves. Research shows that the pace of learning is greatly accelerated when delegates are shown HOW to solve their problems rather than just why they should.

specialist it training


plus Show all courses with StayAhead Training

Request information - obligation free

Get more information from StayAhead Training by filling out the following form. This is a free service for you and the course provider to help you find the most suitable training.
To request information from StayAhead Training, please fill out the following details:
* =  Required field
Email Address*
First Name*
Last Name*
Company
Position
Town/City*
Telephone*
Start date
Number of participants
Message*
Rules

Contact information for StayAhead Training

StayAhead Training

6 Long Lane, Barbican
EC1A 9HF London

Phone no: 020 7600 6116
www.stayahead.com

More Information
Request Information
To request information from Oracle 10g SQL Performance Tuning, please fill out the following details:

What happens now?
Write a course review
Have you studied » Oracle 10g SQL Performance Tuning at » StayAhead Training? Share your experience & help others to pick the right course. Set grades (1-5) where 1= very poor & 5 = excellent.
V. Poor | Poor | OK | Good | Excellent
Trainer / Provider
Venue / Facilities
Course Materials
Networking with other delegates

Do you recommend the provider:


Need help finding the right course?

  
By submitting your e-mail, you become a member of Trainingforit.co.uk