sap-Sybase IQ Administration

Duration: 4 days

Gain a working knowledge of Sybase IQ through a combination of lecture presentations and hands-on laboratory exercises. Learn Sybase IQ architecture, concepts, and terminology while setting up, loading and maintaining an Sybase IQ database. The course also covers must-know important technical information to increase the performance and tuning of Sybase IQ.

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

  • Choose the correct Sybase IQ index types
  • Create Sybase IQ databases, tables, and indexes
  • Load data into Sybase IQ
  • Create and load join indexes
  • Learn performance and tuning techniques for Sybase IQ
  • Understand Multiplex Sybase IQ environment

This course is geared at database administrators who will assume responsibility of an Sybase IQ production environment with:

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

Please find the course objectives below:

  • Introduction to Sybase IQ
    • Overview
    • Installation of sap Sybase IQ
    • Sybase IQ Architecture and Terminology
    • Different terminologies in IQ
    • Connection in sap Sybase IQ
    • IQ Database – Planning & Creation
    • Configure IQ Server / Database
    • IQ Temp Store
    • IQ Transaction Log
    • Index, etc
  • Connecting to Server
    • Sybase Central and database management
    • Connecting with DBISQL
    • Sending commands – example
    • Few Example to work in Sybase IQ Environment (queries)
  • Managing Database using Sybase Central
  • Configure memory and tuning.
  • Define SAP IQ data types and index types
  • Concept of Indexes in IQ
  • Sybase IQ Index Types
    • Compare
    • High Group
    • High Non Group
    • Low Fast
    • Word
  • Creating Databases, Tables, and Indexes
  • Temp Tables
  • Loading Data into Sybase IQ
  • Overview of Query Optimization
  • Manage SAP IQ security
  • Multiplex Architecture and advantage
  • Manage transactions and locking in SAP IQ
  • Monitor SAP IQ
For an onsite course please contact us