Web Content Display Web Content Display

Breadcrumb Breadcrumb


Training Schedule Training Schedule

(EDB795) SAP IQ Advanced Administration
Code: EDB795 v98
Type: null
Tuition (USD): $3272
Length: 4 Days
Have a question?

Get In Touch

Have an idea for your next great application development or analytics project?
Let us know so we can make it happen!

Tell Us Your Name

Enter Your Company Information

Write Us a Message

character(s) remaining

Contact us for upcoming dates.
Skills Gained:
1) Implement an optimum server configuration through the use of disk management, memory allocation, and database options Understand the Information Lifecycle Management process 2) Understand the effects of creating system logins, nodes, dbspaces and objects in a Multiplex environment 3) Optimize data provisioning into IQ using bulk loading and row level versioning 4) Manage unstructured data in IQ 5) Implement full text search in IQ 6) Extract and load data into SAP IQ from a variety of external remote sources using Component Integration Services (Smart Data Access) 7) Implement advanced security controls, including encryption and Kerberos 8) Monitor IQ using sp_iqsysmon and other tools 9) Troubleshoot and repair an IQ database 10) Describe the best practices in administering SAP IQ
Who Should Attend?
Database Administrator
  • Essential: Understanding of database concepts and database fundamentals; EDB785: SAP IQ Administration; 2-4 years' DBA experience
What You Will Learn:
  • 1) SAP IQ Overview
  • a) SAP IQ Overview
  • 2) Sizing and Configuration
  • a) Database Sizing Configurations
  • b) Memory Considerations
  • c) CPU and Thread Considerations
  • d) Network Considerations
  • e) Database Options
  • 3) Information Lifecycle Management
  • a) IQ Dbspaces
  • b) Managing Dbspaces
  • c) Object Positioning
  • d) Table Partitioning
  • e) Information Lifecycle Management
  • 4) Multiplex Management
  • a) Multiplex Architecture
  • b) Managing Multiplex Servers
  • c) Running Multiplex Transactions
  • d) Running DDL Commands
  • e) Handling Dynamic Collisions
  • 5) Data Provisioning
  • a) Data Provisioning
  • b) Bulk Loading Best Practices
  • c) Data Copy Best Practices
  • d) Row Level Versioning
  • 6) Unstructured Data Analytics
  • a) Unstructured Data Analytics
  • b) Full Text Search
  • c) Importing and Exporting LOB Data
  • d) Managing LOB Data
  • 7) Remote Data Access
  • a) SAP IQ and Remote Data
  • b) Setting Up Remote Access
  • c) Query Processing
  • d) Troubleshooting Remote Data Access
  • 8) Advanced Security Topics
  • a) SAP IQ Security Management
  • b) Enhancing Data Security
  • c) Data Encryption
  • d) SAP IQ Advanced Security
  • 9) Advanced Monitoring and Diagnostics
  • a) SAP IQ Diagnostic Output
  • b) Analyzing Hardware Resource Allocation
  • c) Using the sp_iqsysmon Monitor
  • 10) Advanced Troubleshooting
  • a) Troubleshooting IQ
  • b) Advanced Database Repair
  • c) Advanced Database Recovery
  • 11) Best Practices
  • a) Data Modeling
  • b) Tables, Datatypes and Indexes
  • c) SQL Development
  • d) System Configuration
  • Notes
  • • This course is designed for experienced SAP IQ administrators.
Course Info:
Course based on software release: SAP IQ 16 Service Pack 3

Course notes and announcements:

1) Students that complete EDB795 and practice the skills learned will be able to expertly administer an SAP IQ system. This course will teach you how to configure, manage, secure, and troubleshoot multiplex and non- multiplex IQ databases.

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, and SAP Certified participant guides.

This 4 day instructor led course qualifies for 32 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.

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