Contact us

Let‘s talk about data analytics for your company

Contact us

Trainings: SAP IQ administration

  • 2-day course, 16 hours
  • Price: 700 EUR+ VAT (Invoice by Infotrust, SIA)
  • In Latvian
  • Online or live

Goals

Participants will learn how to:

  • Describe the 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 datatypes 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

Audience

  • Database Administrators

Prerequisites

Essential

  • Understanding of database concepts and database fundamentals
  • Knowledge of SQL

Recommended

  • 2-4 years of DBA experience

Content

SAP IQ Overview and Architecture

  • Describing SAP IQ
  • Describing SAP IQ Architecture

Installation

  • Installing SAP IQ

SAP IQ Tools

  • Connecting to SAP IQ

SAP IQ Databases

  • Planning for SAP IQ Databases
  • Creating SAP IQ Databases

Server and Database Configuration

  • Configuring the Server

Memory Configuration

  • Configuring Memory

SAP IQ Data and Index Types

  • Defining SAP IQ Datatypes and Index Types

Table and Index Creation

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

Data Loading

  • Loading Data

Additional Data Loading Topics

  • Inserting data
  • Resolving Data Loading Issues

Security Management

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

Multiplex

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

Transaction Management and Locking

  • Describing Transactions and Locking in SAP IQ

SAP IQ Monitoring

  • Monitoring SAP IQ

SAP IQ Troubleshooting

  • Troubleshooting SAP IQ

Backup and Restore

  • Backing Up SAP IQ databases
  • Restoring SAP IQ databases

Generating SAP IQ Licenses

By registering, You confirm that You have read and agreed to the Privacy policy&Infotrust statement. Any questions: riga@theinfotrust.com.

Registration

By registering, you confirm that you have read our Privacy and Cookie Policy, agree to fill in your contact details and do not object to their future use, inviting to similar events or sending Qlik-related news (no more than once a month, and you can opt out of any newsletter When).

Thanks for reading and accepting Privacy policy & Infotrust statement

Get data analytics news into your inbox

Infotrust team once a month shares BI news, products updates, technology trends and invitations to events and trainings. Mark your interests: