DB2 UDB FOR WINDOWS ADVANCED TOPICS FOR PROGRAMMERS Course

Course Code: RT 320
Course Abstract: Basic UDB administration functions will be reviewed and some DB2 utilities will be used in this course.  This hands-on workshop presents several advanced topics for application developers. SQL statements will be used to create objects for application design and development.  Design issues of referential Integrity, table check constraints, user defined data types, functions, triggers and large objects will be reviewed.  Advanced techniques for using SQL in programs and stored procedures will be applied in workshops.  Finally, program design issues will be considered which effect concurrency, integrity and performance.
Audience: This course is designed for Application programmers and designers.
Duration: 3 days
Learning Outcomes: Upon completion of this course, the participant will be able to:
• Create relational objects for application development
• Use advanced SQL queries to access and manipulate data on DB2 tables
• Review and use different methods of improving performance
• Discuss how DB2 locking strategy improvie concurrency and maintain integrity
• Discuss and code Stored Procedures
• Use IMPORT, EXPORT and LOAD utilities to manipulate data
• Recognize the basic security features of DB2
Course Topics:

Day 1
Course Introduction

Workshop
SQL queries
Workshop 1
Advanced SQL
Workshop 2

Day 2
Performance for SQL and Applications

Data Access and EXPLAIN
Workshop 3
Creating Objects
Workshop 4
TRIGGERS, UDT and UDF
Workshop 5

Day 3
DB2 Stored Procedures

DB2 Program preparation
Workshop 6
DB2 Utilities
IMPORT/EXPORT/LOAD utilities
Workshop 7

Prerequisites: Six months of relevant Operating Systems experience.
Six months of experience with relational database systems and SQL.
Six months experience programming with DB2 UDB.
Note: All fields are required
At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.


We Value Your Privacy!

Ready to get started or in need of more information? Contact us today.

Go To Blog Virtual Learning