Training offering

Informix Dynamic Server 11 Database Administration: Managing and Optimizing Data

Description

This course will teach the student the basic concepts of data management within IDS. It discusses how to determine correct data types; how to create, manage and maintain tables and indexes; how the IDS optimizer works; how to manage data; and how to utilize the SET EXPLAIN feature to determine query effectiveness.

Objectives

•    Select the IBM IDS 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 through the use of 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

Participants

This course is designed for IDS Administrators, Database Administrators, and Applications Developers.

Prerequisite(s)

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

Options

•    Introduction to IBM Informix Dynamic Server Terminology
•    IBM Informix Dynamic Server Data Types
•    Creating Databases and Tables
•    Altering and Deleting Databases and Tables
•    Create, Alter, and Drop Indexes
•    Managing and Maintaining Indexes
•    Table and Index Partitioning
•    Maintaining Table and Index Partitioning
•    Cost-Based Query Optimizer
•    Updating Statistics and Data Distributions
•    Managing the Optimizer
•    Referential and Entity Integrity
•    Managing Constraints
•    Modes and Violation Detection
•    Concurrency Control
•    Data Security
•    Views
•    Introduction to Stored Procedures
•    Triggers