Training Schedule Training Schedule

(EDB785) SAP IQ Administration
Code: EDB785 v10
Type: null
Tuition (USD): $3750
Length: 5 Days
Have a question?

Contact Us

character(s) remaining

Location Date Guaranteed to Run
Live Virtual, US 03/18/2019
Live Virtual, US 06/03/2019

Not finding any suitable dates? Contact us for additional availability: training@dunnsolutions.com

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 Should Attend?
Database Administrator
Prerequisites:
  • Essential: Understanding of database concepts and database fundamentals; Knowledge of SQL
  • Recommended: 2-4 years' DBA experience
What You Will Learn:
  • 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
Course Info:
Course based on software release: SAP IQ 16 Service Pack 3

Course notes and announcements:

1) Students that complete EDB785 and practice the skills learned will be able to administer all basic functionality of SAP IQ; this course will teach you how to keep SAP IQ up, running, stable and productive for your users while you explore the optional and advanced features of the product.

This is a SAP CERTIFIED Course. Your course will include Full Class Delivery of the comprehensive standard SAP curriculum agendas, SAP Certified Instructor, Demonstration and Presentation, Student Hands on exercises, Access to SAP Hosted servers/training environment, SAP Certified e-book participant guides and SAP Certified Hard copy participant guides.

This 5 day instructor led course qualifies for 40 CPE Credits. CPE Credits are currently available only for publicly scheduled courses delivered live at SAP locations and our Authorized Education Partner locations. CPE Credits are not available for virtual live classroom sessions.

With virtual live classroom training you get comprehensive training from SAP experts using seamless over-the Web connectivity. The same content delivered in SAP's traditional "brick and mortar" classrooms is presented during virtual live classroom deliveries. As in SAP's traditional classrooms, SAP virtual live classroom stresses hands-on learning providing each registered student with exclusive access to live SAP systems throughout each course. Each Virtual Live class is taught by a SAP Certified Instructor and will include an e-book student guide for you to download and keep. CPE Credits are currently available only for publicly scheduled courses delivered live at SAP locations and our Authorized Education Partner locations. CPE Credits are not available for virtual live classroom sessions.