Why take this course?
After completing this course, you will be able to
Use Data Studio to complete development tasks such as- create and modify stored procedures using SQL-PL
- debug stored procedures using the integrated debugging facility
- deploy and run stored procedures
- create triggers which use SQL-PL and/or invoke procedures
- create, modify and deploy user defined functions
- create and deploy various types of user defined types
DB1913 Duration - 1 Day : Fee - $ 697.00 (CAD)
Audience
Current and future DB2 application programmers who want to gain the productivity advantage provided by Data Studio for advanced development. DB2 DBA and others who need to provide the server side enhancements from stored procedures, user defined functions and database triggers.Prerequisites
The student should possess a good understanding of SQL DML as well as have a basic understanding of procedural programming techniques.Major topics covered
Data Studio Overview
- General concepts and layout
- Navigation
- Perspectives and views
- Workspaces and setting
- The Web Console
- The Task Launcher
SQL Stored Procedures
- Stored Procedures Overview
- Stored Procedure development workflow
- SQL PL Basics
- Creating a new procedure
- Deploying a stored procedure
- Running a stored procedure
- Using the integrated debugger
Database Trigger Fundamentals
- Trigger overview
- Creating a new trigger
- Editing an existing trigger
- Deploying trigger changes
User Defined Functions
- User defined functions overview
- Creating a new UDF
- Deploying an UDF
- Running and test configurations for UDFs
- Editing existing UDFs
User Defined Types
- User Defined Types Overview
- Distinct User-defined Types
- Structured User-defined Types
- Array Data Types
- Row Data Types
- Creating, editing and deploying user defined types