Length– 32 hours
Overview
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.
Prerequisites
Students in this course should satisfy the following prerequisites:
• IX101 – Introduction to Informix terminology and data types (or equivalent experience or knowledge)
• Knowledge of Structured Query Language (SQL)
• Experience using basic Linux functionality
Audience
The main audience for this course is Informix Database Administrators. It is also appropriate for Informix System Administrators and Informix Application Developers.
Course Outline
Creating databases and tables.
Altering and deleting databases and tables.
Creating, altering, and dropping 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 violations detection.
Concurrency control.
Data security.
Views.
Introduction to stored procedures.
Triggers.