Db2 for LUW

SQL / PL Workshop

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!