2X223G - Informix 12.10 Database Administration

Unit 1 - Creating databases and tables

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

Unit 2 - Altering and deleting databases and tables

• ALTER
• Data space reclamation
• Renaming
• Dropping

Unit 3 - Creating, altering, and dropping indexes

• Indexes
• Sysmaster
• Forest of trees

Unit 4 - Managing and maintaining indexes

• Benefits and costs
• Guidelines
• Calculating size

Unit 5 - Table and index partitioning

• Fragmentation
• Distribution schemes
• Sysmaster

Unit 6 - Maintaining table and index partitioning

• ALTER FRAGMENT

Unit 7 - Cost-based query optimizer

• Access plan
• Join methods
• EXPLAIN
• Scans

Unit 8 - Updating statistics and data distributions

• UPDATE STATISTICS
• Distribution information
• Process
• Updating statistics

Unit 9 - Managing the optimizer

• Optimization options
• Directives

Unit 10 - Referential and entity integrity

• Integrity
• Constraints

Unit 11 - Managing constraints

• Transaction modes
• Dropping a constraint

Unit 12 - Modes and violations detection

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

Unit 13 - Concurrency control

• Isolation
• Locks
• Row versioning

Unit 14 - Data security

• Levels of data security
• Privileges
• Roles

Unit 15 - Views

• Working with views
• WITH CHECK OPTION
• Sysmaster

Unit 16 - Introduction to stored procedures

• Stored procedures
• Sysmaster

Unit 17 - Triggers

• 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