IQ for Developers Bespoke Course

Course Overview

Learn Sybase IQ architecture, concepts, and terminology from a developer's perspective while setting up, loading and maintaining a Sybase IQ database. Understand the major differences between Sybase ASE and Sybase IQ when coding, optimizing the system and making performance enhancing decisions. Instructions on how to build effective query plans, applying the appropriate use of joins and group by clauses in a Sybase IQ platform will help you enhance your capabilities in fine-tuning the environment for optimum retrieval speed.

Audience

Developers who will be using a Sybase IQ environment as their programming environment.

Skills Gained

After completing this course, you should be able to:

• Identify differences between Sybase ASE & Sybase IQ
• Locate references that document all differences
• Identify and use Query Plans
• Explain the ad-hoc Join algorithms available with Sybase IQ
• Optimize queries using Query Optimization
• Use the Index Advisor
• Choose the correct Sybase IQ index and data types
• Create Sybase IQ tables and indexes
• Load data into Sybase IQ from a variety of sources
• Create and load join indexes
• Use Sybase IQ client tools

Prerequisites

• Understanding of relational database concepts, including relational database design
• Familiarity with Structured Query Language (SQL) and other database fundamentals
• Solid 2-4 years Development experience

Course Outline

List of main topics:

• Sybase IQ Overview and Environment
• Sybase IQ Architecture and Terminology
• Sybase IQ Index and Data Types
• Creating Tables, and Indexes
• Using Sybase IQ client Tools
• Loading Data into Sybase IQ
• Transaction Management & Locking
• Difference between Sybase ASE & Sybase IQ
• Overview of Query Plans, Joins & Group Bys
• Query Optimization Options & User Selectivity