Datatrain
Partners
Login
  Username
  Password
  Partner Login
 
Forgot Password?
Register Now!
Partners
Interskill Mainframe Training Newsletter - April ´17
Interskill Mainframe Training Newsletter - August ´16
Interskill Mainframe Training Newsletter - June ´15
Past Issues

Partners
Mainframe Links
Mainframe Facts - Did you know?



DidYouKnow


More facts...

Course Catalog » Database Curriculum » DB2 - Database Management System Series V10

DB2 Stored Procedures V10

Duration
3 hours

Overview

Description

The DB2 Stored Procedures course provides the learner with an overview of DB2 and SQL, and expands this knowledge to describe operational tasks associated with the DB2 subsystem. The course also looks at building application programs and DB2 stored procedures used to access DB2 data, and the DB2 tools to optimize SQL and programs.

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

Introducing DB2 Stored Procedures on z/OS

Introducing DB2 Stored Procedures on z/OS

Creating Stored Procedures

Maintaining and Controlling Stored Procedures

DB2 Stored Procedure Mastery Test

Course Catalog » Database Curriculum » DB2 - Database Management System Series V10
 
 
 
  © All rights reserved. Interskill Learning Pty Ltd.
website designed & developed by blueapple
  HomeAbout UsProductsDemonstrationCourse CatalogDistributorsSite Map
    AOL Logo Interskill IBM