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