DURACIÓN: 32 Hours
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.
The course is updated for version 11.50 of Informix, but is suitable for those still running previous versions of IDS. This course is the Self Paced Virtual version of classroom-delivered course Informix Dynamic Server 11 Performance Tuning (IX221) and Instructor Led OnLine course Informix Database Administration: Managing and Optimizing Data - SPVC (3X221).
If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.
This basic course is designed for Informix System Administrators, Database Administrators, and Applications Developers. It is appropriate for students using Informix Growth Edition, Informix Ultimate Edition, Informix Innovator-C Edition, or Informix Ultimate-C Edition.
You should have a working knowledge of Structured Query Language (SQL).
Introduction to IDS Terminology
IDS 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
Modes and Violation Detection
Introduction to Stored Procedures
03 jun. 2023
Self Paced Training