Back to Search Results

Training Course Summary:

This course provides the student with a working knowledge of Sybase IQ through a combination of lecture presentations and hands-on laboratory exercises. Students learn Sybase IQ architecture, concepts, and terminology while setting up, loading and maintaining an Sybase IQ database. The course also covers must-know monitoring and troubleshooting methods, as well as important technical information to increase the performance and tuning of Sybase IQ. Students create a multiplex configuration of Sybase IQ to support large query loads, as well as create tables and load data.

Pre-Requisites:

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

Who Should Attend:

Database Administrators who will assume responsibility of an Sybase IQ production environment

Training Course Overview/Content:

Sybase IQ Product Overview and Environment
Sybase IQ Architecture and Terminology
Installing and Configuring Sybase IQ
Sybase IQ Index Types
Creating Databases, Tables, and Indexes
Sybase IQ Memory Configuration
Loading Data into Sybase IQ
Sybase IQ Operational Data Administration
Join Indexes
Backup and Restore
Monitoring and Troubleshooting
Performance and Tuning
Creating a Multiplex Database
Multiplex Architecture
Multiplex Loading