Informix for Database Administrators Course

This course is for new or experienced database administrators, programmers, and technical support personnel who will be setting up and managing Informix 14, 12, or 11 databases. This is a four-day course covering the topics listed below.

• Understanding the Informix Server architecture
• Configuring and initializing Informix
• Configuring disk space for databases
• Configuring shared memory parameters
• Configuring virtual CPUs
• Configuring network and client/server connections to databases
• Changing Informix operating modes
• Configuring multiple database servers

Informix Server Operations

• Monitoring and operating Informix
• Backing up Informix databases
• Recovering Informix databases
• Managing concurrence control
• Managing transaction logs
• Managing fault tolerance systems
• Using the Informix utilities
• Using the System Monitoring Interface (sysmaster database)
• Using data load utilities

Informix Server Optimization

• Analyzing Informix performance and system activity
• Using the graphical monitoring tools
• Understanding the query optimizer
• Optimizing performance with indexes
• Optimizing disk and database space layout
• Managing memory and CPU resources

Database Development

• Creating tables, indexes, and databases
• Calculating table and database sizes
• Implementing referential integrity
• Controlling data security
• Using the Informix system tables

Prerequisites:

Requires a basic understanding of UNIX commands and SQL databases.

Cost: $2,000 per person

All training will be conducted as virtual online classe. Take any scheduled course online from your desk via a web browser and an SSH client (like PuTTY).