IX223G | Informix 12.10 Database Administration



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.


Learning Journeys that reference this course:

  • Informix



The main audience for this course is Informix Database Administrators.  It is also appropriate for Informix System Administrators and Informix Application Developers.



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


Key topics

Unit 1 - Creating databases and tables

Unit 2 - Altering and deleting databases and tables

Unit 3 - Creating, altering, and dropping indexes

Unit 4 - Managing and maintaining indexes

Unit 5 - Table and index partitioning

Unit 6 - Maintaining table and index partitioning

Unit 7 - Cost-based query optimizer

Unit 8 - Updating statistics and data distributions

Unit 9 - Managing the optimizer

Unit 10 - Referential and entity integrity

Unit 11 - Managing constraints

Unit 12 - Modes and violations detection

Unit 13 - Concurrency control

Unit 14 - Data security

Unit 15 - Views

Unit 16 - Introduction to stored procedures

Unit 17 - Triggers

IX223G | Informix 12.10 Database Administration

Suscríbase a nuestro newsletter

Copyright 2020 Netec. Todos los derechos reservados.