Description
At Sixe Engineering we have been providing official IBM training around the world for over 15 years. Get the best training from our specialists in Europe. We have important discounts and offers for two or more students.
Course details
| IBM course code: SIFMX223G | Category: Informix / Informix |
| Delivery: Online & on-site** | Course length in days: 4 |
Target Audience
This course is designed primarily for Informix Database Administrators. It is also highly relevant for Informix System Administrators and Informix Application Developers who are looking to deepen their expertise in managing and optimizing Informix environments.
Prerequisites
Participants in this course should meet the following prerequisites:
- IX101 – Introduction to Informix Terminology and Data Types (or equivalent knowledge/experience)
- Proficiency in Structured Query Language (SQL)
- Experience with basic Linux functionality
Instructors
The majority of our IBM courses are taught by our experienced engineers. This ensures the highest quality of instruction, backed by real-world experience. Our courses are supplemented with proprietary materials and hands-on labs developed from our extensive experience in deployments, migrations, and training sessions.
Added Value
Our courses are carefully tailored to the specific roles of the participants. For instance, the technical needs of development teams differ significantly from those responsible for infrastructure management. We recognize the importance of prior experience and adapt our approach accordingly. Rather than focusing solely on commands and tasks, we emphasize practical problem-solving skills that are applicable to the daily challenges faced by each team. Our course materials are continually updated to reflect the latest versions of Informix, ensuring that participants receive the most current and relevant training.
Agenda and Course Syllabus
Unit 1 – Creating Databases and Tables
- Overview of Databases and Tables
- Tools: DBSCHEMA, ONCHECK, and ONSTAT
- Understanding Sysmaster
Unit 2 – Altering and Deleting Databases and Tables
- Using ALTER Commands
- Data Space Reclamation
- Renaming and Dropping Databases and Tables
Unit 3 – Creating, Altering, and Dropping Indexes
- Index Fundamentals
- Utilizing Sysmaster for Index Management
- Understanding the Forest of Trees Concept
Unit 4 – Managing and Maintaining Indexes
- Benefits and Costs of Indexes
- Best Practices and Guidelines
- Calculating Index Size
Unit 5 – Table and Index Partitioning
- Fragmentation Techniques
- Distribution Schemes
- Leveraging Sysmaster for Partitioning
Unit 6 – Maintaining Table and Index Partitioning
- Using ALTER FRAGMENT for Maintenance
Unit 7 – Cost-Based Query Optimizer
- Access Plans and Join Methods
- Using EXPLAIN for Query Analysis
- Understanding Scans
Unit 8 – Updating Statistics and Data Distributions
- The UPDATE STATISTICS Command
- Managing Distribution Information
- Best Practices for Updating Statistics
Unit 9 – Managing the Optimizer
- Optimization Options and Directives
Unit 10 – Referential and Entity Integrity
- Implementing Integrity Constraints
Unit 11 – Managing Constraints
- Transaction Modes
- Dropping Constraints
Unit 12 – Modes and Violation Detection
- Object Modes and Disabling Objects
- Recording Violations with Sysmaster
Unit 13 – Concurrency Control
- Isolation Levels
- Lock Management
- Row Versioning
Unit 14 – Data Security
- Understanding Data Security Levels
- Managing Privileges and Roles
Unit 15 – Views
- Working with Views
- Implementing WITH CHECK OPTION
- Utilizing Sysmaster for View Management
Unit 16 – Introduction to Stored Procedures
- Overview of Stored Procedures
- Sysmaster Integration
Unit 17 – Triggers
- Implementing and Managing Triggers
- Integrating Triggers with Stored Procedures
- Working with Cursors and Triggers
- Trigger and Constraint Checking with Sysmaster
Appendices
- Appendix A – Terminology: Comprehensive glossary of terms used throughout the course.
- Appendix B – Data Types: Detailed review of data types in Informix.
- Appendix C – XML Publishing: Introduction to XML publishing capabilities.
- Appendix D – Basic Text Search DataBlade Module: Overview of BTS DataBlade Module.
- Appendix E – Node DataBlade Module: Introduction to the Node DataBlade Module.
- Appendix F – Using Global Language Support: Overview of GLS features and usage.
This updated course structure reflects the latest capabilities of Informix, providing participants with the skills needed to effectively manage and optimize their database environments in today’s dynamic technological landscape.
Do you need to adapt this syllabus to your needs? Are you interested in other courses? Ask us without obligation.
Locations for on-site delivery
- Austria: Vienna
- Belgium: Brussels, Ghent
- Denmark: Cophenhagen
- Estonia: Tallinn
- Finland: Helsinki
- France: Paris, Marseille, Lyon
- Germany: Berlin, Munich, Cologne, Hamburg
- Greece: Athens, Thessaloniki
- Italy: Rome
- Louxemburg: Louxembourg (city)
- Netherlands: Amsterdam
- Norway: Oslo
- Portugal: Lisbon, Braga, Porto, Coimbra
- Slovakia: Bratislava
- Slovenia: Bratislava
- Spain: Madrid, Sevilla, Valencia, Barcelona, Bilbao, Málaga
- Sweden: Stockholm
- Turkey: Ankara
- United Kingdom: London
