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