Flash Sale: Save 15% on IT Training


SAP IQ Advanced Administration

  • Tuition USD $3,000 GSA  $2,430.23
  • Reviews star_rate star_rate star_rate star_rate star_half 1451 Ratings
  • Course Code EDB795-v098
  • Duration 4 days
  • Available Formats Virtual, Classroom

Skills Gained

  • Implement an optimum server configuration through the use of disk management, memory allocation, and database options Understand the Information Lifecycle Management process
  • Understand the effects of creating system logins, nodes, dbspaces and objects in a Multiplex environment
  • Optimize data provisioning into IQ using bulk loading and row level versioning
  • Manage unstructured data in IQ
  • Implement full text search in IQ
  • Extract and load data into SAP IQ from a variety of external remote sources using Component Integration Services (Smart Data Access)
  • Implement advanced security controls, including encryption and Kerberos
  • Monitor IQ using sp_iqsysmon and other tools
  • Troubleshoot and repair an IQ database
  • Describe the best practices in administering SAP IQ

Who Can Benefit

  • Database Administrator


  • Essential:
       -Understanding of database concepts and database fundamentals
       -EDB785: SAP IQ Administration
       -2-4 years' DBA experience
  • Recommended:

Course Details

Course Content

  • SAP IQ Overview
       -SAP IQ Overview
  • Sizing and Configuration
       -Database Sizing Configurations
       -Memory Considerations
       -CPU and Thread Considerations
       -Network Considerations
       -Database Options
  • Information Lifecycle Management
       -IQ Dbspaces
       -Managing Dbspaces
       -Object Positioning
       -Table Partitioning
       -Information Lifecycle Management
  • Multiplex Management
       -Multiplex Architecture
       -Managing Multiplex Servers
       -Running Multiplex Transactions
       -Running DDL Commands
       -Handling Dynamic Collisions
  • Data Provisioning
       -Data Provisioning
       -Bulk Loading Best Practices
       -Data Copy Best Practices
       -Row Level Versioning
  • Unstructured Data Analytics
       -Unstructured Data Analytics
       -Full Text Search
       -Importing and Exporting LOB Data
       -Managing LOB Data
  • Remote Data Access
       -SAP IQ and Remote Data
       -Setting Up Remote Access
       -Query Processing
       -Troubleshooting Remote Data Access
  • Advanced Security Topics
       -SAP IQ Security Management
       -Enhancing Data Security
       -Data Encryption
       -SAP IQ Advanced Security
  • Advanced Monitoring and Diagnostics
       -SAP IQ Diagnostic Output
       -Analyzing Hardware Resource Allocation
       -Using the sp_iqsysmon Monitor
  • Advanced Troubleshooting
       -Troubleshooting IQ
       -Advanced Database Repair
       -Advanced Database Recovery
  • Best Practices
       -Data Modeling
       -Tables, Datatypes and Indexes
       -SQL Development
       -System Configuration


  • This course is designed for experienced SAP IQ administrators.

Course based on software release

  • SAP IQ 16 Service Pack 3

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals, and private on sites. View our group training page for more information.

Very good training! The instructor is a specialist and the material is great!

Sean was a fantastic instructor! He went beyond the material to help one understand!

Excellent remote class environment and it was a good experience of remote learning.

Very informative and helpful. Provided lots of extra resources and explained the process clearly.

Outstanding job on the facilitator of this course (Ruben) and great information taught throughout the duration!

Ruben did a fantastic job facilitating this course! The only downfall is trying to cram all this information into 2 days! Incredibly overwhelming...

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward