SAP Sybase IQ - training


SAP SYBASE IQ ADVANCED ADMINISTRATION


Duration: 4 days

Goals:
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

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