What You Always Wanted to Know about Microsoft Azure Certifications - Live Webinar

closeClose
sap Training

SAP IQ Administration

Course Details
Code: EDB785-v010
Tuition (USD): $4,090.00 • Virtual (5 days)
$4,090.00 • Classroom (5 days)
Course Details
GSA (USD): $3,400.50 • Virtual (5 days)
$3,400.50 • Classroom (5 days)

Skills Gained

  • 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

Who Can Benefit

  • Database Administrator

Prerequisites

  • Essential:
       -Understanding of database concepts and database fundamentals
       -Knowledge of SQL
  • Recommended:
       -2-4 years' DBA experience

Course Details

Course 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
  • Licensing and Premium Features
       -Generating SAP IQ Licenses
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward