Duration

2 days

Overview

In this course, students will learn to write procedures, functions, and triggers using the Informix stored procedure language. These stored procedures can then be stored within the database server and accessed by database server users.

Audience

This basic course is for Database Administrators and Applications Developers.

Prerequisites

You should have

Relational Database Design, or equivalent knowledge
Structured Query Language, or equivalent knowledge
Some programming experience

Key Topics

Exercise 1
Exercise 2
Exercise 3
Exercise 4

Objectives

Explain the advantages of using stored procedures
Use stored procedure language (SPL) statements
Create and execute stored procedures
Pass and return values from a stored procedure
Identify uses for triggers in a database system
Create triggers
Use triggers to call stored procedures

Programme scope, delivery arrangements and suitability are confirmed during enquiry.