FA-0250Data & Analytics

Informix 14

Database Administration

Introduction

Why this course

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:

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

Training outline

5 modules

01Informix 14 Overview:2 topics

Introduction to Informix 14: Features and Capabilities
Understanding the Architecture of Informix

02Installation and Configuration:5 topics

Preparing for Installation
Installing Informix 14
Initial Configuration and Setup
HDR Setup - Configuration
ER Setup - Enterprise Replication

03Database Management:3 topics

Creating and Managing Databases and Tables
Data Types and Indexes
Importing and Exporting Data

04SQL in Informix:3 topics

Basic SQL Operations: Select, Insert, Update, Delete
Advanced SQL Features: Stored Procedures, Triggers, and Views
Creating Subtype > ROW Type

05Backup and Recovery:3 topics

Backup Strategies and Planning
Performing Backups and Restores
Disaster Recovery Scenarios

A programme built around your team.

Share your training goals and requirements.