Uddannelsestilbud

IBM Informix Stored Procedures and Triggers

Information

Pris kr 2.000  Ekskl. moms
Varighed: 2 Dage
Ref: 1X711G
Delivery Type Web based training

Sessionsdatoer

På anmodning. Kontakt os venligst

Purchase

    BUY Now
    kr 2.000  Ekskl. moms

    Ekskl. moms

Disse oplysninger findes også beregnet for intra-virksomhedsuddannelsen. Tøv ikke med at kontakte os for at få flere oplysninger

Beskrivelse

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

Formål


  • 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

Målgruppe

This basic course is for Database Administrators and Applications Developers.

Forudsætninger

You should have:




  • Skills on Relational Database Design, or have equivalent knowledge

  • Skills on Structured Query Language, or have equivalent knowledge

  • Some programming experience

Program


  • 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

© 2018 VALit Aps - Arrow ECS. All rights reserved.