DB2 Advanced Topics in Programming-Custom for Highmark Delaware

PT9329
Summary
Class will be hands-on, lab oriented with students performing various tasks to exercise material covered. Experience with SPUFI, the SQL programming environment at the site and a compiled language such as COBOL is assumed. Performance labs using EXPLAIN are performed by the student to provide practical experience in assessing and resolving performance issues.
Prerequisites
Experience with SPUFI, the SQL programming environment at the site and a compiled language such as COBOL is assumed.
Duration
4 Days/Lecture & Lab
Audience
This course is designed for programmers and other technical personnel experienced in using SQL from a compiled language such as COBOL who require additional training and knowledge using DB2 in the zOS mainframe environment.This should not be the first DB2 / SQL programming experience for the student.
Topics
Review Fundamentals of Embedding SQL in Programs::Additional DB2 Programming Features::DB2 Utilities for the Application Programmer::Overview of DB2 Performance Issues and Tools::General SQL Query Coding for Performance::Using EXPLAIN to Assess and improve SQL Performance

Related Scheduled Courses