In this course, you will learn the basic concepts of data management within Informix. You will learn how to determine correct data types; how to create, manage, and maintain tables and indexes; how the Informix optimizer works; how to manage data; and how to use the SET EXPLAIN feature to determine query effectiveness.
- 1. Introduction to Informix Terminology
- 1. Introduction to Informix Terminology
- 2. Informix Data Types
- 3. Creating Databases and Tables
- 4. Altering and Deleting Databases and Tables
- 5. Create, Alter, and Drop Indexes
- 6. Managing and Maintaining Indexes
- 7. Table and Index Partitioning
- 8. Maintaining Table and Index Partitioning
- 9. Cost-based Query Optimizer
- 10. Updating Statistics and Data Distributions
- 11. Managing the Optimizer
- 12. Referential and Entity Integrity
- 13. Managing Constraints
- 14. Modes and Violation Detection
- 15. Concurrency Control
- 16. Data Security
- 17. Views
- 18. Introduction to Stored Procedures
You should have a working knowledge of Structured Query Language (SQL).