• Home
• Catalog
• Courses
• Database Curriculum
• DB2 Stored Procedures

DB2 Stored Procedures

Duration

2 to 3 hours

Overview

Audience

Programmers and DBAs requiring training in developing and managing DB2 stored procedures

Prerequisites

Basic knowledge of DB2, relational databases, and SQL

Objectives

After completing this course, the student will be able to:
• Identify DB2 stored procedures: what they are, different types, why they are used.
• Recognize how to create and maintain DB2 stored procedures.

Course Content

Introducing Stored Procedures

DB2 Stored Procedure Fundamentals
DB2 Stored Procedure Features
Creating and Running DB2 Stored Procedures

DB2 Stored Procedures on z/OS

Introducing DB2 Stored Procedures on z/OS
Creating Stored Procedures
Maintaining and Controlling Stored Procedures

DB2 Stored Procedures Mastery Test