IX22: Informix 12.10 Database Administration

Code: IX22
Duration: 4 days

Description

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

Outcomes

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

Audience

The main audience for this course is Informix Database Administrators. It is also appropriate for Informix System Administrators and Informix Application Developers.