IBM Informix 12.10 Database Administration

IBM Informix 12.10 Database Administration

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.

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

Outline

Module 1 – Creating databases and tables

• Databases
• Tables
• DBSCHEMA, ONCHECK, and ONSTAT
• Sysmaster

Module 2 – Altering and deleting databases and tables

• ALTER
• Data space reclamation
• Renaming
• Dropping

Module 3 – Creating, altering, and dropping indexes

• Indexes
• Sysmaster
• Forest of trees

Module 4 – Managing and maintaining indexes

• Benefits and costs
• Guidelines
• Calculating size

Module 5 – Table and index partitioning

• Fragmentation
• Distribution schemes
• Sysmaster

Module 6 – Maintaining table and index partitioning

• ALTER FRAGMENT

Module 7 – Cost-based query optimizer

• Access plan
• Join methods
• EXPLAIN
• Scans

Module 8 – Updating statistics and data distributions

• UPDATE STATISTICS
• Distribution information
• Process
• Updating statistics

Module 9 – Managing the optimizer

• Optimization options
• Directives

Module 10 – Referential and entity integrity

• Integrity
• Constraints

Module 11 – Managing constraints

• Transaction modes
• Dropping a constraint

Module 12 – Modes and violations detection

• Object modes
• Disabling an object
• Recording violations
• Sysmaster

Module 13 – Concurrency control

• Isolation
• Locks
• Row versioning

Module 14 – Data security

• Levels of data security
• Privileges
• Roles

Module 15 – Views

• Working with views
• WITH CHECK OPTION
• Sysmaster

Module 16 – Introduction to stored procedures

• Stored procedures
• Sysmaster

Module 17 – Triggers

• Working with triggers
• Triggers and stored procedures
• Dropping a trigger
• Cursors and triggers
• Triggers and constraint checking
• Sysmaster
• Managing triggers