SAP IQ Training

Module 1: SAP IQ Overview and Architecture

• Describing SAP IQ
• Describing SAP IQ Architecture

Module 2: Installation

• Steps to Installing SAP IQ

Module 3: SAP IQ Tools

• List of Tools for SAP IQ
• GUI Tools

Module 4: SAP IQ Databases

• SAP IQ Database Design
• Creating SAP IQ Databases

Module 5: Scalability

• Introduction to Scalability
• Memory Use
• Data Loads
• Process Threading Model

Module 6: SAP IQ Data and Index Types

• Defining SAP IQ Datatypes and Index Types
• SAP IQ Null Values

Module 7: Table and Index Creation using SQL Server

• Describing SQL in SAP IQ
• Creating Tables
• Creating Views

Module 8: Data Loading

• Introduction
• Bulk Loads with the LOAD TABLE Statement
• Transaction Processing and LOAD TABLE
• Load from a Flat File: UNIX Example
• Using the INSERT Statement

Module 9: Security Management

• Designing a Security Model
• Plan and Implement Role-Based Security

Module 10: Multiplex

• Creating a Multiplex
• Planning the Configuration
• Multiplex System Privileges

Module 11: Transaction Management and Locking

• Data and Transaction Management
• Locking in the SAP IQ Interface

Module 12: SAP IQ Monitoring

• Monitoring SAP IQ

Module 13: SAP IQ Troubleshooting

• Troubleshooting SAP IQ

Module 14: Backup and Restore

• Backing Up SAP IQ Databases
• Restoring Database Backups