SQL Performance Tuning

Catalyst Learning
London, United Kingdom

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

Course Description:

'' By the end of the course, the delegate will be able to tune applications for optimal performance; optimize SQL queries for faster access and tune code to reduce disk I/O and reduce network traffic.

Topics Covered:

Tuning Database Applications for Optimal Performance
Managing Statistics
Creating and Using Indexes and Clusters
Creating and Using Views
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
Using Parallel DML
Identifying Unused Indexes
PL/SQL Tuning Issues
Using the SQL Tuning Advisor and SQL Access Advisor

Requirements:

A working knowledge of SQL and is required. This can be obtained by attendance on the pre-requisite courses.
...''

Phone:0800 953 0387

School Address:

175 Tottenham Court Road
London, W1T 7NU
UK

Jobs & Resumes: London
Houses & Roommates: London

Nortel Networks
MCDST, MCSA, MCSE, MCDBA, MCAD, MCSD
Novell
Relational Databases
Introduction to SQL
ORACLE Overview
PL/SQL
ORACLE Fundamentals
Oracle Program with PL/SQL
PL/SQL Web Applications
Forms Web Deployment
DBA Fundamentals
Oracle Database 10g DBA using Enterprise Manager
10g Discoverer for Administrators
Oracle 10g Application Server Administration
Oracle 11i System Administration
Oracle Financials

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: Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent.