Performance and Tuning: Adaptive Server Enterprise Query Optimizer

Sybase, Inc.
Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc., U.S.

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

Course Description:

'' Learn how to tune queries and Stored Procedures for optimal performance using Adaptive Server Query Optimizer. Study various techniques for writing high-performance queries that allow the optimizer to use the most efficient query plan, and learn how to diagnose and correct performance problems with existing queries. Gain proficiency in interpreting and modifying optimizer statistics to improve query performance and using simulated statistics for ¡°what if¡± analysis. Acquire a benchmarking tuning methodology.
Course Objectives :
Upon completion of this course, you will be able to:
Discuss tradeoffs involved in performance tuning
Use Sybase utilities to troubleshoot query performance
Ensure your queries are using the most efficient access methods (indexes, table scans, parallel vs. serial)
Write queries which help the Optimizer choose the most efficient query plan
Interpret and modify optimizer statistics to improve query performance
Use simulated statistics for ¡°what if¡± analysis
Tune insert, update, and delete operations
Troubleshoot parallel performance problems
Optimize stored procedure performance
Course Topics :
The Adaptive Server Query Optimizer, showplan and other Sybase utilities, optimizing joins, optimizer statistics, abstract plans, tuning insert, update, and delete operations, parallel query plans, using indexes to reduce I/O, and Stored Procedures.

Who Should Attend :

SQL Developers
Application Developers who use SQL code
Database Administrators and/or Sybase System Administrators who are involved in tuning queries
Performance and Tuning Specialist
Any computer professional who needs an understanding of how the Sybase Query Optimizer works
Prerequisites :

Fast Track to Adaptive Server Enterprise
Advanced Transact-SQL: Tips and Techniques

...''

Phone:1-800-8-SYBASE (800-879-2273)

School Address:

14800 Quorum
Suite 505
Dallas, Texas 75240
United States

8755 West Higgins Road
Suite 1100
Chicago, IL 60631

The Grace Building
1114 Avenue of the Americas, 32nd Floor
New York, NY 10036

Rock Spring Plaza
6550 Rock Spring Drive, Suite 700
Bethesda, Maryland

561 Virginia Rd.
Concord, MA 01742
(978) 287-1500

3820 Mansell Road
Suite 100
Alpharetta , GA 30022

19900 MacArthur Boulevard
Suite 510
Irvine, CA 92612

Jobs & Resumes: Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc.
Houses & Roommates: Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc.

Introduction to SQL Expert
Behind the Scenes with DBCC Commands
Backup Server Unleashed
Securing Adaptive Server Enterprise Communications
Mastering Transact-SQL Programming: Advanced Tips & Techniques
Fast Track to Adaptive Server Enterprise
System and Database Administration: Adaptive Server Enterprise 12.5
Performance and Tuning: Configuring Adaptive Server Enterprise
Advanced Administration and Troubleshooting for Adaptive Server
Troubleshooting Adaptive Server Data Structures
Logical Database Design
Physical Database Design
XML Certification Boot Camp
Introduction to Cascading Style Sheets
Introduction to JavaScript
Introduction to Java 2 Programming
Intermediate Java 2 Programming
Advanced Java 2 Programming
Adaptive Server Anywhere 9.0 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: ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges.