Oracle Database 10g: SQL Tuning Workshop

QA Ltd.
Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course is designed to give the experienced SQL Developer or DBA a firm foundation in SQL tuning techniques. The participant learns the necessary knowledge and skills to effectively tune SQL in the Oracle Database 10g Release 2. They learn about tuning methodology as well proactive tuning and reactive tuning methods. Students are introduced to the benefits of the new automatic tuning mechanisms available in Oracle Database 10g. On completion of the course they are able to compare and contrast the steps involved to tune manually as in prior releases as well as use the automatic SQL tuning features provided in the current release. Students gain a thorough conceptual understanding of the Oracle Optimizer, and reinforce instructor-led learning with structured hands-on practices. The course uses a series of challenge-level workshops, allowing students to “play, discover, and learn�at their own level and pace. The students learn to use the Oracle diagnostic tools and facilities: Automatic SQL Tuning components, EXPLAIN, SQL Trace and TKPROF, SQL*Plus AUTOTRACE. Students also learn to influence the behavior of the Optimizer by changing the physical schema and modifying SQL statement syntax.

This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirement.

Audience
Business Intelligence Developer
Forms Developer
Java Developer
PL/SQL Developer
Reports Developer
Technical Consultant

Course Objectives
Describe the basic steps in processing SQL statements
Describe the causes of performance problems
Understand where SQL tuning fits in an overall tuning methodology
Describe Automatic SQL Tuning
Use the diagnostic tools to gather information about SQL statement processing
Understand Optimizer behavior
Influence the optimizer behavior
Influence the physical data model so as to avoid performance problems
Outline
Database Architecture overview
Following a Tuning Methodology
Designing Applications for performance
Introducing the optimizer
Optimizer Operations
Displaying Execution plans
Gathering Statistics
Application Tracing
Identifying High Load SQL
Automatic SQL Tuning
Introduction to Indexes
Advanced Indexes
Optimizer Hints and Plan Stability
Materialized Views and Temporary Tables ...''

Elements of this syllabus are subject to change.

Phone:0844 871 2080

School Address:

TEL: 0844 871 2080
E-mail us: info@qa.com

Jobs & Resumes: Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough
Houses & Roommates: Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough
Travel Agencies: Birmingham, Bristol, Edinburgh, Leeds, London, Manchester,

Search other schools for Oracle Database 10g: SQL Tuning training resources.

Oracle Enterprise Manager 10g Grid Control
oracle ids
oracleas discoverer 10g:queries and reports
Migrate from SQL Server to Oracle Database 10g
Oracle 10g Database
Oracle 10g: Java Programming
Oracle Application Server 10g R2
oracle database 10g
oracle database 10g: program with pl/sql
Oracle Forms Developer 10g
oracle reports developer 10g
oracleas discoverer 10g
oracle database 11g
oracle database 11g: program with pl/sql
Advanced Perl with CGI and Web Applications
Perl 5 Object Oriented Programming
Perl
Perl DBI module

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.