Skip to main content

 spacer
Professional certification
spacer
  >  
spacer
Certifications
spacer
  >  
spacer
Test information

Test 000-910: Managing and Optimizing Informix Dynamic Server Databases


Overview Objectives Test Preparation
Roadmap  |  Training Resources  |  Sample / Assessment Test 


Note: This test was renamed from 660-112 to 910. 
Courses and publications are offered to help you prepare for the certification tests. The courses are recommended, but not required, before taking a certification test. 


Classroom Course

Course title: IBM Informix Stored Procedures and Triggers
Course duration: 2.0 days
Course number: FN335
Abstract:

Learn how to use and incorporate triggers and stored procedures into your IBM Informix databases and create and execute stored procedures.

See Remarks for Special Note.

This is a basic course for application developers, database and system administrators, and technical support individuals.

Course title: IBM Informix Data Migration and Reorganization
Course duration: 2.0 days
Course number: FN910
Abstract:

Gain experience using Informix data movement utilities, including SQL LOAD and UNLOAD, dbload, dbexport, dbimport, onload, and the High Performance Loader (HPL).

See Remarks for Special Note.

This is a basic course for IBM Informix Dynamic Server and IBM Informix Dynamic Server.2000 database and system administrators, application developers, and technical support individuals.

Course title: Informix Structured Query Language
Course duration: 4 days
Course number: IX130
Abstract: In this course, you will learn to write queries using ANSI standard Structured Query Language (SQL) with IBM Informix extentions. You will start with simple queries to select rows from a single table, then advance to more complex queries that involve subqueries or multitable joins. Learn how to use functions and expressions in SQL statements and how to format the query results. In addition, learn how to perform insert, update, and delete operations, and how to select rows that contain large object and other non-standard data types. This course replaces course FN613 and FN757.

Course title: IBM Informix Dynamic Server Backup and Restore
Course duration: 3.0 days
Course number: L2748
Abstract:

Focus on backup and recovery planning through a variety of exercises that define what recovery means for your business, identify constraints affecting recovery, and begin to develop a strategy for backup and recovery planning.

See Remarks for Special Note.

Database and system administrators.


Retail Book
forward arrow Administering Informix Dynamic Server on Windows NT

This is the first systematic, hands-on guide to installing, configuring, tuning, and administering Informix-Dynamic Server on Windows NT. It delivers exactly what working DBAs need to simplify day-to-day administration and optimization. Coverage reflects the entire lifecycle of an Informix database, including up-front design, installation, and initialization; building a database environment; administering databases, tables, instances and threads; backups and restores; and much more.

Test registration

Authorized Prometric test centers (worldwide testing)