Arrow Electronics, Inc.

IBM Informix Stored Procedures and Triggers

CÓDIGO: 1X711G

DURACIÓN: 16 Hours

Precio: €300,00

Descripción

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

Objetivos

  • 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

Público

This basic course is for Database Administrators and Applications Developers.

Requisitos Previos

You should have:

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

Programa

  • 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

Fechas Programadas
Fecha
Localización
Zona horaria
Idioma
Modalidad de impartición
Impartición garantizada
Precio

01 dic. 2023

Spanish

Web based Training

€ 260,00