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 Series V11

DB2 Stored Procedures V11

Duration
3 hours

Overview

Description

The DB2 Stored Procedures course describes how stored procedures are used and the platforms on which they can be implemented. The benefits derived from using stored procedures are discussed as well as security implications associated with them.

Audience

Programmers and DBAs responsible for developing and managing DB2 stored procedures.

Prerequisites

Completion of the courses 'Manage Data Definitions with DB2', 'DB2 SQL Fundamentals', and 'Advanced DB2 SQL' and basic knowledge of DB2, relational databases, and system design.

Objectives

After completing this course, the student will be able to:

  • Identify the benefits of Using DB2 stored procedures
  • Describe how DB2 stored procedures are used in a z/OS environment
  • Create and invoke 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 DB2 Stored Procedures

Autonomous Procedures

Maintaining and Controlling DB2 Stored Procedures

DB2 Stored Procedure Mastery Test

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