Informix 11.7 Database Administration  (IX222)

Compétences acquises

• 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

Qui peut en profiter

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

Préalables

You should have:

• a working knowledge of Structured Query Language (SQL)

Abstract

IBM Education Advantage Program Eligibility:

• Yes - Education Pack - online account