Arrow Electronics, Inc.

IBM Informix Stored Procedures and Triggers - SPVC

CÓDIGO: 2X711G

DURACIÓN: 2 días

Precio: €750,00

Descripción

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.

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

  • Relational Database Design, or equivalent knowledge
  • Structured Query Language, or 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

26 jun. 2022

Spanish

Self Paced Training

€ 680,00