In this course, you will learn the basic concepts of data management within Informix. You 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.

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

* 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 optimizer
* Optimize 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

You should have:
- a working knowledge of Structured Query Language (SQL)