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.

If you are enrolling in a Self Paced Virtual Classroom or Web Based Training course, before you enroll, please review the Self-Paced Virtual Classes and Web-Based Training Classes on our Terms and Conditions page, as well as the system requirements, to ensure that your system meets the minimum requirements for this course.

http://www.ibm.com/training/terms

• 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

This basic course is for Database Administrators and Applications Developers.

You should have:

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

• Unit 1: Introduction to stored procedures
• Unit 2: Creating and executing stored procedures
• Exercise 1
• Unit 3: Stored procedure language statements
• Exercise 2
• Unit 4: Exception processing for stored procedures
• Exercise 3
• Unit 5: Production environment for stored procedures
• Unit 6: Creating and using triggers
• Exercise 4