02 9482 8200 info@datasync.com.au

IX22: Informix 11.7 Database Administration

Code: IX22
Duration: 4 days

Description

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.

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

Informix Administrators, Database Administrators, and Application Developers.

Prerequisites

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

Format

Classroom and hands on lab exercises.

This course is offered as web-based training. Please contact us for more information.

Course available by request – please contact us for further details.