SAP IQ Administration

Code: EDB785v10

5 days

List Tuition : $3,750.00 USD

Course Overview

    Download PDF 

In this course, you will learn how to keep SAP IQ operating, stable, and productive for your users while you explore the optional and advanced features of the product.

Database administrators

  • SAP IQ architecture
  • Install SAP IQ
  • Connect to SAP IQ
  • Plan for and create an SAP IQ database
  • Configure the server and database
  • Configure memory
  • Define SAP IQ data types and index types
  • Load data and manage data loading issues
  • Manage SAP IQ security
  • Create and manage multiplexes
  • Manage transactions and locking in SAP IQ
  • Monitor SAP IQ
  • Troubleshoot SAP IQ
  • Back up and restore SAP IQ databases

1. SAP IQ Overview and Architecture

  • Describing SAP IQ
  • Describing SAP IQ Architecture

2. Installation

  • Installing SAP IQ

3. SAP IQ Tools

  • Connecting to SAP IQ

4. SAP IQ Databases

  • Planning for SAP IQ Databases
  • Creating SAP IQ Databases

5. Server and Database Configuration

  • Configuring the Server

6. Memory Configuration

  • Configuring Memory

7. SAP IQ Data and Index Types

  • Defining SAP IQ Datatypes and Index Types

8. Table and Index Creation

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

9. Data Loading

  • Loading Data

10. Additional Data Loading Topics

  • Inserting data
  • Resolving Data Loading Issues

11. Security Management

  • Designing a Security Model
  • Implementing a Security Model
  • Migrating Authorization

12. Multiplex

  • Creating a Multiplex
  • Managing a Multiplex
  • Managing Resources through Logical Servers

13. Transaction Management and Locking

  • Describing Transactions and Locking in SAP IQ

14. SAP IQ Monitoring

  • Monitoring SAP IQ

15. SAP IQ Troubleshooting

  • Troubleshooting SAP IQ

16. Backup and Restore

  • Backing Up SAP IQ databases
  • Restoring SAP IQ databases

17. Licensing and Premium Features

  • Generating SAP IQ Licenses
  • Understanding of database concepts and database fundamentals
  • Knowledge of SQL
  • Minimum of two years of DBA experience is highly recommended

Request a Discounted Quote

Bring Training to You

Request schedule for this course

Request a Quote for this Class

We provide government and government contractor discounts, please request a quote


total option: 0

Hotel and Travel can be included on your quote.
For immediate response, you can call 1-855-515-2170 or we will provide a quote within 4 business hours. Travel must be booked 14 days before training for rate to apply.

Learn How to Become a Managed Learning Member

Request a Quote

Thank you for requesting a quote, we will be in touch shortly with a quote. If you need immediate assistance, please call 855-515-2170.

Request Other Date

Request date or location you need

Don’t see the date or location you need? Contact us and let us know, we are adding dates and locations daily.