02 9482 8200 info@datasync.com.au

IX71: IBM Informix Stored Procedures and Triggers

Code: IX71
Duration: 2 days

Description

In this course, you 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.

Outcomes

  • 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

Audience

Database Administrators and Application Developers.

Prerequisites

In order to attend this course it is recommended that you have the following skills or completed the specified courses:

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

Format

Classroom and hands on lab exercises.

This course is offered as web-based training. Please contact us for more information.

Course available by request – please contact us for further details.