Knowledge United

Course Description : 

Learn Sybase IQ query plans and advanced optimization features and techniques. Explore the major differences between Sybase ASE and Sybase IQ while optimizing the system and making performance enhancing decisions.  Instructions on how to build effective query plans and apply the appropriate use of join algorithms will help enhance capabilities in fine-tuning a Sybase IQ environment for optimum retrieval speed. You must attend the "Administering Sybase IQ for the Data Warehouse" class prior to enrolling in this class.

Course Objectives :

Upon completion of this course, you will be able to:

• Identify differences between Sybase ASE & Sybase IQ
• Identify and use Query Plans
• Explain the ad-hoc Join algorithms available with Sybase IQ
• Optimize queries using Query Optimization

• Use the Index Advisor

Course Topics: 

• Differences Between Sybase ASE and Sybase IQ
• Query Plans
• Joins and Group by
• Optimizing Queries
• Query Optimization Options and User Selectivity

Who Should Attend: SQL Developers and Database Administrators who will assume responsibility of an Sybase IQ production environment

Prerequisites: 

• Administering Sybase IQ for the Data Warehouse (EDB698 or EDB782)
• Understanding of relational database concepts, including relational database design,
• Familiarity with Structured Query Language (SQL) and other database fundamentals
• Solid 2-4 years DBA or SQL Developer experience.

Skill: Expert

Format:
90% Lecture
10% Labs