Db2 SQL Stored Procedure Language

Catalog Home Databases, Business Intelligence & Data Science Db2 for LUW
Your Training Location:  

This course introduces the student to how to code, debug, and call Db2 SQL Stored Procedures.

Before taking this course, students should have an understanding of Db2 SQL.

3 Days/Lecture & Lab

This course is targeted at programmers and power users, analysts, team leaders and project managers who need to understand how to code, debug, and call Db2 SQL PL Stored Procedures.

  • Introduction
  • Basic SQL Procedure Structure
  • SQL PL Language Elements
  • Using Flow of Control Statements
  • Understanding and Using Cursors and Result Sets
  • Condition Handling
  • Working with Dynamic SQL
  • Nested SQL Procedures
  • User-Defined Functions (UDFs) and Triggers
  • Leveraging Db2 Application Development Features
  • Deploying SQL Procedures, Functions, and Triggers
  • Performance Tuning
  • Best Practices

< >

Copyright © 2021 ProTech Professional Technical Services, Inc. All Rights Reserved.

Sign In Create Account


Social Media