Informix 14

Informix 14

Database Administration

2-day training

This course is designed to equip you with the essential skills and knowledge needed to effectively manage and maintain Informix databases. Our journey will take us through a variety of topics, from the basics of database administration to more advanced features of Informix 14. We aim to provide a supportive and interactive learning environment, where your questions and participation are highly encouraged. Let's dive into the world of Informix together and unlock the potential of efficient database management!

Learning Outcomes:

By the end of this course, you will be able to:

• Understand the architecture and components of Informix 14.
• Install and configure Informix 14.
• Perform basic database administration tasks such as creating and managing databases and tables.
• Implement security measures and manage user access.
• Understand and apply backup and recovery techniques.
• Troubleshoot common issues in Informix 14.
• Leverage new features unique to Informix 14.

Prerequisites:

Participants are expected to have:

1. Basic knowledge of database concepts.
2. Familiarity with SQL.
3. Some experience with any database management system (not mandatory but beneficial).
4. A laptop/computer with Informix 14 installed (installation guidance provided before the course).

Course Outline:

1. Informix 14 Overview:
   1. Introduction to Informix 14: Features and Capabilities
   2. Understanding the Architecture of Informix
2. Installation and Configuration:
   1. Preparing for Installation
   2. Installing Informix 14
   3. Initial Configuration and Setup
   4. HDR Setup - Configuration
   5. ER Setup - Enterprise Replication
3. Database Management:
   1. Creating and Managing Databases and Tables
   2. Data Types and Indexes
   3. Importing and Exporting Data
4. SQL in Informix:
   1. Basic SQL Operations: Select, Insert, Update, Delete
   2. Advanced SQL Features: Stored Procedures, Triggers, and Views
   3. Creating Subtype > ROW Type
5. Backup and Recovery:
   1. Backup Strategies and Planning
   2. Performing Backups and Restores
   3. Disaster Recovery Scenarios