Loading Course Schedule...
Gain a working knowledge of Sybase IQ 15.4 through a combination of lecture presentations and hands-on exercises. Learn Sybase IQ architecture, concepts, and terminology while setting up, configuring, administering and maintaining a Sybase IQ database in both a simplex and multiplex environment. The course covers must-know monitoring and troubleshooting methods, as well as important technical information to increase the efficiency of the Sybase IQ DBA. You will also be heavily involved in creating a multiplex configuration of Sybase IQ to support large query loads, creating numerous tables and extracting and loading gigabits of data in to your environments.
Understanding of relational database concepts and database fundamentals 2-4 years DBA experience
5 Days/Lecture & Lab
New Administrators of Sybase IQ
Overview and Architecture::Installation::Sybase IQ Tools::Sybase IQ Databases::Server and Database Configuration::Memory Configuration::Data Types and Index Types::Creating Tables and Indexes::Loading Data::Advanced Loading Data::User Administration and Security::Using Sybase IQ::IQ Programming::Stored Procedures and Functions::Transaction Management::Query Plans::Performance and Tuning::Multiplexing Architecture::Multiplex Configuration::Backup and Restore::Monitoring and Troubleshooting