Training Course:SQL Performance TuningSchool/Trainer: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. ...''
Please go to the school's official website for training price and schedule: http://www.cbduk.biz
Phone:0800 953 0387
School Address:
175 Tottenham Court Road London, W1T 7NU UK
Jobs & Resumes: London Houses & Roommates: London
Other training courses offered by Catalyst Learning:
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. |
|
|