#FN-848

Managing and Optimizing IBM Informix Dynamic Server Databases

Course Description

For Informix Dynamic Server and Informix Dynamic Server database administrators and application developers. Gain experience creating, modifying, and removing databases, tables, and indexes. Learn how to control security, maintain data integrity, maintain concurrency control, and improve performance in the Informix Dynamic Server.2000 environment. Learn data migration and reorganization methods.

Your New Skills

• Select the Informix Dynamic Server.2000 data types appropriate for storing your data
• Create and maintain databases, tables, and indexes
• Implement referential and entity integrity
• Estimate the size and extent requirements for tables and indexes
• Create and maintain fragmented tables and fragmented indexes
• Improve decision support query performance through the use of PDQ (parallel database query)
• Improve query performance through the use of SET EXPLAIN
• Describe concurrency control
• Create an indexing strategy to improve performance
• Configure and use the High Performance Loader
• Plan for and configure triggers
• Create and use views
• Control data security
• Use Informix database management utilities

Who Should Attend: Application developers, database and system administrators, technical support personnel

Prerequisites

• FN-611 Relational Database Design or equivalent knowledge
• FN-613 Structured Query Language or equivalent knowledge

Length: 5 days

Format: Lecture and hands-on exercises

Course Number: FN-848

Recommended Next Course:

• FN-335 Using Stored Procedures and Triggers
• L1-846 System Administration: Informix Dynamic Server (UNIX)
• L1-763 System Administration: Informix Extended Parallel Server
• L2-849 Managing the Extensible Informix Dynamic Server Database
• L1-855 Data Warehouse Design