Skip to main Content

IBM Fast Path to Informix for Experienced Relational Database Administrators

  • Course Code IX480G
  • Duration 4 days

Additional Payment Options

  • GTC 28

    GTC, Global Knowledge Training Credit, please contact Global Knowledge for more details

Public Classroom

Public Classroom Price

eur2,595.00

Request Group Training Add to Cart

Course Delivery

This course is available in the following formats:

  • Company Event

    Event at company

  • Public Classroom

    Traditional Classroom Learning

  • Virtual Learning

    Learning that is virtual

Request this course in a different delivery format.

Course Overview

Top

In this course, you will use your experience with other relational database management systems as a basis for learning how to administer the Informix database server. You will learn the terminologies used to describe Informix database server objects and processes. You will learn how to configure and start an Informix database server instance, and perform tasks related to the monitoring and maintenance of the instance. You will also learn the terminology and tasks required to design and maintain Informix databases and queries.

Course Schedule

Top

Target Audience

Top

This intermediate course is designed for database and system administrators.

Course Objectives

Top
  • Configure and initialize an Informix database instance
  • Add and remove spaces and chunks
  • Manage the operating mode of the database server
  • Monitor server activity
  • Create and alter database objects
  • Explain locking granularity
  • Explain Informix isolation levels
  • Use SET EXPLAIN to obtain a query plan
  • Use UPDATE STATISTICS to better define data distribution
  • Create simple stored procedures and triggers

Course Content

Top

Please refer to Course Overview for description information.

Course Prerequisites

Top

You should have:

  • Experience with administration of other relational database management systems.
  • Experience with UNIX/Linux operating systems