Informix for Database Administrators Course

This course is for new or experienced database administrators, programmers, and technical support personnel who will be setting up and managing Informix 14, 12, or 11 databases. This is a four-day course covering the topics listed below.

Next Course Dates:

  • May 18-21, 2020
  • October 5-8, 2020

Informix Server Configuration

  • Understanding the Informix Server architecture
  • Configuring and initializing Informix
  • Configuring disk space for databases
  • Configuring shared memory parameters
  • Configuring virtual CPUs
  • Configuring network and client/server connections to databases
  • Changing Informix operating modes
  • Configuring multiple database servers

Informix Server Operations

  • Monitoring and operating Informix
  • Backing up Informix databases
  • Recovering Informix databases
  • Managing concurrence control
  • Managing transaction logs
  • Managing fault tolerance systems
  • Using the Informix utilities
  • Using the System Monitoring Interface (sysmaster database)
  • Using data load utilities

Informix Server Optimization

  • Analyzing Informix performance and system activity
  • Using the graphical monitoring tools
  • Understanding the query optimizer
  • Optimizing performance with indexes
  • Optimizing disk and database space layout
  • Managing memory and CPU resources

Database Development

  • Creating tables, indexes, and databases
  • Calculating table and database sizes
  • Implementing referential integrity
  • Controlling data security
  • Using the Informix system tables

Prerequisites:

Requires a basic understanding of UNIX commands and SQL databases.

Cost: $2,000 per person

All training will be conducted as virtual online classe. Take any scheduled course online from your desk via a web browser and an SSH client (like PuTTY).

Register now!

Complete and submit your registration.

More Info

Online Course Setup

What you'll need to take the course from your desk.

More Info

"This was a great class... we will be upgrading from version 10.00 to 11.70... Lester and Art are great instructors, made the class fun and their depth of experience with Informix and IT in general is very impressive. The upgrade that we will be performing in the coming months was made much easier and it's because of this class."

~Bill Chick

Advanced Informix Performance Tuning Course participant