Advanced Data Tools Logo
Consulting Training Tech Info Successes User Groups Our Company spacer

Learn how to create and optimize Informix databases.

Designing, Developing, & Optimizing IBM Informix Databases
(with Advanced SQL, Triggers & Stored Procedures)

This course is for database administrators and application developers who will be responsible for designing and developing Informix databases. The participants will lean how to create and optimize Informix databases. The course includes sections on advanced SQL topics and how to use triggers and stored procedures. This is a five-day course and includes the following topics:

Database Schema Design

  • Informix OnLine data types
  • Calculating table & database sizes
  • Using the Informix system tables
  • Using data, referential, & entity integrity
  • Using referential constraints
  • Managing isolation levels & locking levels
  • Constraint transaction modes


  • Using update statistics & distribution schemas
  • Table fragmentation across multiple disk drives
  • Optimizing disk & database space layout
  • Optimizing performance with indexes
  • Optimizing client/server transactions
  • Using Parallel Database Query (PDQ)
  • Reading the query plan
  • Using Set Explain to optimize queries

Advanced Informix SQL

  • The SQL select statement
  • Filters & conditional expressions
  • Relationships (joins, outer joins, and unions)
  • Aggregates & other advanced features & functions
  • Data Manipulation, concurrency, & definition commands

Embedded Informix SQL

  • Using SQL statements in programs
  • Using the SQLCA structure
  • Retrieving multiple rows with cursors
  • Developing programs with dynamic SQL
  • Executing SQL statements
  • Using record locking & concurrency

Stored Procedures

  • Creating stored procedures
    • Variables
    • Flow control
    • Error handling
  • Running stored procedures
  • Debugging stored procedures
  • Privileges and stored procedures


  • Creating triggers
  • Specifying trigger events
  • Creating trigger actions
  • Using stored procedures in triggers


Requires a basic understanding of Informix, UNIX and vi commands, SQL databases, and prior experience with Informix SQL.

Course Schedule and Registration