Winter Savings - Save up to $250 to $2500 on IT Training. Use promo code SNOWBALL

closeClose

SAP IQ Advanced Administration

Course Details
Code: EDB795-v098
Tuition (USD): $3,000.00 • Virtual (4 days)
$3,000.00 • Classroom (4 days)
Course Details
GSA (USD): $2,430.23 • Virtual (4 days)
$2,430.23 • Classroom (4 days)

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

Prerequisites

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

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

Notes

  • This course is designed for experienced SAP IQ administrators.

Course based on software release

  • SAP IQ 16 Service Pack 3