4levels teams with the top technology providers to enhance your operations   |   Domains & Hosting   |  Get Support   | My 4levels
GET IN TOUCH
+27 (0)11 848 6229

IBM

4levels-IT-Default-Header

Fast Path to Informix for Experienced Relational Database Administrators


Course Description


Overview

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.  

Audience

This intermediate course is for database and system administrators.

Prerequisites

You should have:
  • Experience with administration of other relational database management systems.
  • Experience with UNIX/Linux operating systems

Key topics

Please refer to Course Overview for description information.

Objectives

  • 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 Duration

4 days
  • Brands we have partnered with to add value to your business


    We are committed to helping our clients reach their business goals

    4levels’ preferred access to the latest technologies, premier technical support and advanced training helps provide you with specialist and customized solutions that help you achieve your business goals.

4levels Solutions sign up form


Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur excepteur sint occaecat cupidatat non

4levels Solutionslogin form