IBM Informix 11.7 Database Administration Training

IBM Informix 11.7 Database Administration Training

  • Course Overview
In IBM Informix 11.7 Database Administration  course, you will learn the basic concepts of data management within Informix. You will learn how to determine correct data types; how to create, manage, and maintain tables and indexes; how the Informix optimizer works; how to manage data; and how to use the SET EXPLAIN feature to determine query effectiveness.

  • Course Objectives

  • Select the Informix data types appropriate for storing your data
  • Create and maintain databases, tables, and indexes
  • Estimate size and extent requirements for tables and indexes
  • Create index strategies to improve performance
  • Create and maintain table and index partitioning (fragmentation)
  • Implement referential and entity integrity
  • Manage database and table modes
  • Manage violations logging
  • Describe how the optimizer builds an optimal query plan
  • Use the SET EXPLAIN feature to capture optimizer query plans
  • Use directives and environment variables to influence the optimizer
  • Optimize the query plan using UPDATE STATISTICS
  • Manage end-user concurrency
  • Use permissions and roles to manage data security
  • Create and use views
  • Manage smart large objects
  • Create and manage triggers

  • Audience
This intermediate course is for Informix Administrators, Database Administrators, and Application Developers.

  • Prerequisites
 You should have:
a working knowledge of Structured Query Language (SQL)

Key features

  • 40 hours of instructor-led training
  • 40 hours of high-quality eLearning content
  • 5 simulation exams (250 questions each)
  • 8 domain-specific test papers (10 questions each)
  • 30 CPEs offered
  • 98.6% pass rate

IBM Informix 11.7 Database Administration Training                 Duration :- 4 Days

  • Introduction to Informix Terminology

  • Informix Data Types

  • Creating Databases and Tables

  • Altering and Deleting Databases and Tables

  • Create, Alter, and Drop Indexes

  • Managing and Maintaining Indexes

  • Table and Index Partitioning

  • Maintaining Table and Index Partitioning

  • Cost-based Query Optimizer

  • Updating Statistics and Data Distributions

  • Managing the Optimizer

  • Referential and Entity Integrity

  • Managing Constraints

  • Modes and Violation Detection

  • Concurrency Control

  • Data Security

  • Views

  • Introduction to Stored Procedures

  • Triggers

You can enroll for this classroom training online. Payments can be made using any of the following options and receipt of the same will be issued to the candidate automatically via email.

1. Online ,By deposit the mildain bank account

2. Pay by cash team training center location

Highly qualified and certified instructors with 20+ years of experience deliver more than 200+ classroom training.
Venue is finalized few weeks before the training and you will be informed via email. You can get in touch with our 24/7 support team for more details. Contact us Mob no:- 8447121833, Mail id:  [email protected] . If you are looking for an instant support, you can chat with us too.
We provide transportation or refreshments along with the training.
Contact us using the form on the right of any page on the mildain website, or select the Live Chat link. Our customer service representatives will be able to give you more details.

Find This Training in Other Cities:-

Kolkata,Bangalore,Mumbai,Hyderabad,Pune ,Delhi,Chennai,

Mildain Solutions/Corp Office Delhi(NCR)

HeadQuarter Office:
Plot No 17, C Block Market, Sec 36,
Noida (U.P.)-201301(India)
Bangalore office:
Mildain Solutions,
No 7 & 8,Krishna Reddy Layout,
Domlur(Bangalore) 560071(India)
Hyderabad office:
Mildain Solutions

Mumbai office:

Mildain Solutions
5th Floor, Block B, Godrej IT Park,
Pirojshanagar, LBS Marg, Vikhroli West,
Mumbai, Maharashtra
 (+91) 1204326873
(+91) 8447121833
Contact Us

Your Name (required)

Your Email (required)

Contact Number




Drop Us A Query

Your Name (required)

Your Email (required)

Contact Number





good session..!!
will be useful to improve my technical Knowledge..
The concepts of the Instructor was mind-blowing…Lots of Industry examples…Very well organized…
Ajay Nunna
Nice session…!! enjoyed learning new things
Really good training. It helped me to clear a lot of doubts which were present in my mind for a long time.
“ The course content is very good and satisfactory. The trainer is also good with his teaching abilities.”
Apply the knowledge in understanding the new 11b framework setup in our system.
Apply the skill in day to day operational maintenance of our IT infrastrututre.