IBM Informix 11.7 Database Administration

Course details

In this course, students will learn the basic concepts of data management within Informix. They will learn how to determine correct data types; how to create, manage, and maintain tables and indexes; how the Informix optimizer works; how to manage data; and how to use the SET EXPLAIN feature to determine query effectiveness.

Target Audience:

This course is designed for Informix Administrators, Database Administrators, and Application Developers.

Objectives:

• Select the Informix data types appropriate for storing your data
• Create and maintain databases, tables, and indexes
• Estimate size and extent requirements for tables and indexes
• Create index strategies to improve performance
• Create and maintain table and index partitioning (fragmentation)
• Implement referential and entity integrity
• Manage database and table modes
• Manage violations logging
• Describe how the optimizer builds an optimal query plan
• Use the SET EXPLAIN feature to capture optimizer query plans
• Use directives and environment variables to influence the
• optimizerOptimize the query plan using UPDATE STATISTICS
• Manage end-user concurrency
• Use permissions and roles to manage data security
• Create and use views
• Manage smart large objects
• Create and manage triggers

Prerequisites:

The student should have a working knowledge of Structured Query Language (SQL).