Duration
4 days
Overview
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.
Audience
The main audience for this course is Informix Database Administrators. It is also appropriate for Informix System Administrators and Informix Application Developers.
Prerequisites
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
Databases
Tables
DBSCHEMA, ONCHECK, and ONSTAT
Sysmaster
ALTER
Data space reclamation
Renaming
Dropping
Indexes
Sysmaster
Forest of trees
Benefits and costs
Guidelines
Calculating size
Fragmentation
Distribution schemes
Sysmaster
ALTER FRAGMENT
Access plan
Join methods
EXPLAIN
Scans
UPDATE STATISTICS
Distribution information
Process
Updating statistics
Optimization options
Directives
Integrity
Constraints
Transaction modes
Dropping a constraint
Object modes
Disabling an object
Recording violations
Sysmaster
Isolation
Locks
Row versioning
Levels of data security
Privileges
Roles
Working with views
WITH CHECK OPTION
Sysmaster
Stored procedures
Sysmaster
Working with triggers
Triggers and stored procedures
Dropping a trigger
Cursors and triggers
Triggers and constraint checking
Sysmaster
Managing triggers
Appendix A - Terminology
Terminology
Appendix B - Data types
Data types
Appendix C - XML publishing
XML publishing
Appendix D - Basic Text Search DataBlade Module
BTS DataBlade Module
Appendix E - Node DataBlade Module
Node DataBlade Module
Appendix F - Using Global Language Support
Using GLS
Programme scope, delivery arrangements and suitability are confirmed during enquiry.