Sybase IQ: Understanding Optimization and Improving Performance

Sybase USA
Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond, United States

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

Course Description:

'' Learn through lectures and intensive hands-on instruction how to get the most out of your Sybase IQ. Explore how to optimize queries and indexes to achieve optimal query processing by thoroughly understanding the principles of the Sybase IQ runtime engines. This will allow you to better design indexes & queries that run optimally in your own environment. Use the Index Advisor and monitoring tools to troubleshoot and repair inefficient and ineffective queries. You will then learn how to read and interpret Query Timing Diagrams and Query Plans to troubleshoot your queries or indexes.

Course Objectives :
Upon completion of this course, you will be able to:
Design and implement indexes that are efficient & effective
Read Query Plans and illustrate how the nodes of query plans affect query processing, including joins & group by nodes
Explain how the query engine processes queries
Demonstrate how to setup, execute and interpret query timing diagrams ...''

Elements of this syllabus are subject to change.

Phone:1-800-8-SYBASE

School Address:

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

Irvine Learning Center
19800 MacArthur Blvd. Suite 855
Irvine, CA 92612


Jobs & Resumes: Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond
Houses & Roommates: Atlanta, Bethesda, Boulder, Chicago, Concord, Dallas, Irvine, New York, Richmond
Travel Agencies: Atlanta, Chicago, Dallas,

Search other schools for Sybase IQ: Understanding Optimization and Improving Performance training resources.

ASE 15 MIGRATION FOR THE DATABASE ADMINISTRATOR
Powering Up with ASE 15.0
Sybase IQ Query Plans and Optimization
Sybase IQ for Developers
Sybase IQ: Migrating to Sybase IQ 15
Fast Track to PowerBuilder
Reporting with InfoMaker 10.0
Moving to PowerBuilder 9.0
Advanced PowerBuilder Controls
C# for the PowerBuilder Developer
Moving to PowerBuilder 11
Building Applications using PowerBuilder Foundation

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 provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day.