Location | Delivered By | Language | Date | Price | Action |
---|---|---|---|---|---|
No schedule date's available now. |
* Prices Inclusive of taxes
Location | Delivered By | Language | Date | Price | Action |
---|---|---|---|---|---|
No schedule date's available now. |
* Prices Inclusive of taxes
Tell us a little about yourself:
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.
Please refer to course overview.
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 Informix 12.10 Database Administration course should satisfy the following prerequisites:
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