SAP IQ Administration

COURSE OUTLINE:

Description

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.

Audience

Database administrators

Prerequisites

Understanding of database concepts and database fundamentals
Knowledge of SQL
Minimum of two years of DBA experience is highly recommended

Learning Objectives

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

RELATED COURSES

Technical Training
SAP

SAP Mobile Platform 3.0 Agentry Essentials

SAP Agentry is a core and fundamental mobile application development component in SAP Mobile Platform (SMP) 3.0. This course covers the SAP Agentry metadata driven application development paradigm topics to satisfy the technical skill set requirements for developers and other mobility professionals who need to learn how to develop meta-data driven SMP Agentry mobile applications. The course will enable you to apply SAP Agentry concepts to your own projects. Extensive hands-on exercises are included to allow you to practice the concepts learned in the course. This course is based on software release SAP Mobile Platform 3.0 SP05 Server/SP06 SDK.

Technical Training
SAP

SAP Business Planning and Consolidation(BPC440v10)

In this course, you will learn all of the key steps to set up consolidation based on the SAP Business Planning and Consolidation, version for SAP NetWeaver. You will learn consolidation-specific configuration and how to use the consolidation central tool. You will also learn how to use the data manager to execute currency translations, and perform eliminations for example. Additionally, you will be introduced to the EPM add-in for Excel.

This course is based on software release:

BPC 10.1 NW Standard Model SP5
SAP BW 7.4 SPS10
HANA SPS9
EPM add-in SP21
Design Studio 1.4
Analysis for Office 1.4.9

Technical Training
SAP

Enterprise Architecture Modeling with SAP PowerDesigner 16.5

In this course, you will learn how SAP PowerDesigner is used as a modeling tool that supports Enterprise Architecture (EA) from business goals through implementation using unique Link and Sync technology. Gain knowledge about how to remove silos, increase alignment, and improve business agility to respond to changes in business, technology, competition, and regulations.

Technical Training
SAP

AS ABAP – Performance Analysis (ADM315v15)

In this course, you will learn about performance monitoring and tuning of SAP systems based on AS ABAP.

This course is based on software release EHP7 FOR ERP 6.0.