Test 000-918: System Administration for IBM Informix Dynamic Server V11

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: Informix Dynamic Server 11 Database Administration: Managing and Optimizing Data
Course duration: 4.0 Days
Course number: IX221
Abstract:

This course will teach you the basic concepts of data management within IDS. It discusses how to determine correct data types; how to create, manage and maintain tables and indexes; how the IDS optimizer works; how to manage data; and how to utilize the SET EXPLAIN feature to determine query effectiveness. This course is the classroom delivered version of Instructor Led OnLine course 3X221.

This course is designed for IDS administrators, Database administrators, and Application developers.

Course title: Informix Dynamic Server 11 New Features
Course duration: 3.0 Days
Course number: IX301
Abstract:

This course discusses the new features available in IBM Informix Dynamic Server V11, including new features added for V11.5. There will be several labs accompanying this course which will allow the student to get hands-on experience with some of these new features. This course is the classroom delivered version of Instructor Led OnLine course 3X301.

This course is designed for IDS Administrators, Database Administrators, and Applications Developers.

Course title: Informix Dynamic Server 11 Performance Tuning
Course duration: 4 days
Course number: IX401
Abstract: In this course, students will learn the fundamentals of tuning an Informix Dynamic Server instance for optimal performance. The course covers topics related to hardware issues and tuning for optimizing data loads, index builds, UPDATE STATISTICS processes, and OLTP and DSS queries. A multiprocessor UNIX machine with multiple disk drives will be provided so that students can perform benchmarking exercises to test the tuning skills they have learned.

Course title: Informix Dynamic Server 11 Replication
Course duration: 4 days
Course number: IX421
Abstract: Learn the process of generating multiple copies of data at one or more sites through the planning, implementing, and administering of IBM Informix Dynamic Server Enterprise Replication. Learn how to configure remote server that can be used for hot-site backup using High Availability Data Replication (HDR) and by configuring Remote Standalone Secondary and Shared Disk Secondary servers. This course replaces Informix Dynamic Server Replication (IX420).

Course title: Informix Dynamic Server 11 System Administration
Course duration: 4.0 Days
Course number: IX811
Abstract:

In this course, you will develop the skills necessary to successfully administer one or more database servers. You will learn how to configure and initialize a database server instance, configure and test client connectivity, configure and manage memory and disk usage, plan and implement system maintenance tasks, and configure the server for optimal Online Transaction Processing (OLTP) or decision support.

The course is updated for version 11.50 of Informix Dynamic Server. This course is the classroom delivered version of Instructor Led OnLine course 3X811.

This is an intermediate course designed for IDS administrators, Database administrators, and Applications developers.

Course title: Informix Dynamic Server 11 Internal Architecture
Course duration: 4 days
Course number: IX911
Abstract: This course is intended for experienced Informix Dynamic Server system administrators interested in advancing their troubleshooting and monitoring skills. In this course, students will learn advanced skills for monitoring and analyzing various structures within an Informix Dynamic Server environment. Students will be presented with detailed information about the architecture of dbspaces, blobspaces, sbspaces, and their various components down to the page level. Students will also learn more about virtual processors and how to monitor thread activity. They will learn more about shared memory components and how memory pools are designed and used. Finally, students will learn more in-depth details about various Informix Dynamic Server processes, including checkpoints, physical and logical logging, and fast recovery. This course replaces IX910.

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.

Course title: IBM Informix Dynamic Server 11 System Administration Certification Preparation Tutorial Series
Course duration: 10-16 hours
Course number:
Abstract: This series of eight tutorials has been developed to help you prepare for the IBM Informix Dynamic Server 11 System Administration Certification Exam (918). These tutorials provide a solid base for each section of the exam. However, you should not rely on these tutorials as your only preparation for the exam. After a quick registration, you can begin a tutorial. Currently parts 1 and 2 are available in this series of eight. Each tutorial should take less than two hours to complete. You can take the tutorials online, or download a PDF.