Informix 12.10 Database Administration IX223G

4 days


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.


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

Course Outline

  • 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
  • Appendix A - Terminology
  • Appendix B - Data types
  • Appendix C - XML publishing
  • Appendix D - Basic Text Search DataBlade Module
  • Appendix E - Node DataBlade Module
  • Appendix F - Using Global Language Support

Related Courses


Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

ITILv3, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O, MoP, MoV courses on this page are offered by QA Affiliate of AXELOS Limited. ITIL, RESILIA, PRINCE2, PRINCE2 Agile, AgileSHIFT, MSP, M_o_R, P3M3, P3O,MoP, MoV are registered trademarks of AXELOS Limited. All rights reserved.