Db2 for LUW
Event:
Title:
Db2 für LUW – SQL / PL Workshop
Course code:
LT#SQLPL
Date:
On request
Duration:
1 Day
Cost per person:
590,00€ exkl. VAT
Organizer:
LIS.TEC GmbH
Location:
Ludwigsburg or
on site (plus travel costs)
Services:
Small study groups
Food & drinks
Seminar documents and training in german
If you register for several participants, we offer interesting graduated discounts.
You can register by sending an e-mail to schulung@listec.de
Contact: Herr Joachim Klassen
Telephone: +49 (0) 7141 93 93-0
Description
The Db2 SQL Procedure Language (SQL / PL) platform-independent Stored Procedures (SP) and User-Defined Functions (UDF) can be developed, which significantly extend the “normal” SQL functionality.
This topic is not only interesting for developers, but also database administrators can simplify and automate tasks by using self-developed procedures and functions.
The documents for the workshop are in German and on the most up-to-date Db2 stand – by means of exercises the theory is practically implemented.
Participants
- Software developers and database administrators
The topics at a glance
- SQL PL overview
- IBM Data Studio overview
- SQL PL development and debugging with IBM Data Studio
- SQL PL Data Types
- SQL PL statements
- SQL PL Cursors and Result Sets
- SQL PL Condition Handling
- SQL PL Nested SQL Procedures
- SQL PL Dynamic SQL
- SQL PL User Defined Functions
- SQL PL DBMS modules
- miscellaneous
Objective
In this workshop the participants will learn about and understand the concepts of SQL Procedure Language SQL / PL. It shows how the IBM Data Studio can be used for the development, debugging and distribution of SQL / PL procedures and functions.
The use of the tools and commands is practiced in the numerous practical blocks.
The participants are then able to independently develop and extend SQL / PL procedures and functions.
Requirements
- Basic knowledge of relational databases and SQL knowledge.
LIS.TEC GmbH
Contact us!