02 9482 8200 info@datasync.com.au

IX48: FastPath to Informix for Experienced Relational DBAs

Code: IX48
Duration: 4 days

Description

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

Outcomes

  • 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

Audience

This course is for Senior Database Administrators.

Prerequisites

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

Format

Classroom and hands on lab exercises.

This course is offered as web-based training. Please contact us for more information.

Course available by request – please contact us for further details.