Call for Latest Dates
Call us on 0870 7777 388 for availability on this course.
Have questions or need a better city/date? Ask now.
|
Course Overview 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. Audience - Database Administrators who will assume responsibility of an Sybase IQ production environment
Skills Gained - Effectively administer an Sybase IQ (Simplex or Multiplex)
- Choose the correct Sybase IQ index types
- Create Sybase IQ databases, tables, and indexes
- Load data into Sybase IQ from a variety of sources
- Create and load join indexes
- Backup and restore an Sybase IQ database
- Monitor and troubleshoot an Sybase IQ installation
- Learn performance and tuning techniques for Sybase IQ
- Set up a Multiplex Sybase IQ environment
Prerequisites - 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
Course Outline - 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
How to make a booking for the EDB694 course
|
