IBM Informix Stored Procedures and Triggers
Course
In London
Description
-
Type
Course
-
Location
London
-
Duration
2 Days
-
Start date
Different dates available
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.
Facilities
Location
Start date
Start date
About this course
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
Reviews
Subjects
- Server
- Database
- Database training
- Web
Course programme
- 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
IBM Informix Stored Procedures and Triggers
