Call : (+91) 99 8080 3767
Mail : info@EncartaLabs.com
EncartaLabs

SAP IQ - Administration

( Duration: 5 Days )

By attending SAP IQ - Administration training course, you will learn 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

Essential:

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

Recommended:

  • 2-4 years' DBA experience

This SAP IQ - Administration workshop is ideal for Database Administrators

COURSE AGENDA

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

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top