Oracle Database 10g: SQL Tuning Workshop (Certificate)

Mondale IT Solutions Ltd.
London, Birmingham, Manchester, Leeds, Glasgow, Edinburgh, Reading, Bristol, Exeter, United Kingdom

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

Course Description:

'' his 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. 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:
Forms Developer
PL/SQL Developer
Technical Consultant
Reports Developer
Business Intelligence Developer
Java Developer

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
...''

Elements of this syllabus are subject to change.

Phone:01635 281 888

School Address:

Mondale IT Solutions Ltd
Poplar House
Compton Road
East Ilsley
Newbury
Berkshire
United Kingdom
RG20 7LH

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

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

11i Financials Functional Foundation
11i HRMS System Administration
11i Install, Patch, and Maintain Oracle Applications
11i Oracle Payables Fundamentals
11i System Administrator Fundamentals
Oracle 10g: XML Fundamentals
Oracle AS 10g R3 Java Programming
Oracle Database 10g: Administration
Oracle Database 10g: Performance Tuning
Oracle Database 10g: SQL Fundamentals
Oracle Database 11g Administration
Oracle Database 11g: Introduction to SQL
Oracle Database 11g: Program with PL/SQL
Oracle Reports Developer 10g: Build Reports
Oracle Discoverer Administrator 10g: Develop an EUL
Building an Effective Web Site
Developing Web Applications with Active Server Pages and VBScript
Getting Started with PHP and MySQL
Internet Technology Fundamentals

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.
 

Tips: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.