Db2 for z/OS SQL & Application Programming

PT27075
Training Summary
Db2 SQL and Application Programming is a 5 day course targeting the needs of programmers and developers writing applications that access data stored in the Db2 environment. The presentation is an integrated mixture of lecture and workshop activities that introduce and reinforce the basic techniques and approaches to relational database technology as implemented in Db2. Topics covered include structure and manipulation of Db2 data, operational considerations in both on-line and batch environments; integrity; embedded programming techniques and preparation; and an introduction to performance analysis. The workshop activities follow the classroom material and are designed for both topic reinforcement and practice. Programming topics are supported by workshops in both the on-line and batch environment, this includes precompiling, compiling, linking, and the various options of the Db2 BIND. This course is a combination of Db2 SQL for Everyone and Db2 for z/OS Embedded SQL Programming
Prerequisites
Basic programming skills in the COBOL environment and familiarity with the z/OS environment and TSO/ISPF.
Duration
5 Days/Lecture & Lab
Audience
Programmers, application developers and computer analysts who are exposed to, or are required to perform the activities associated with application development and implementation in a Db2 environment.
Course Topics
  • Relational Database Concepts
  • Basic Data Manipulation
  • Intermediate Data Manipulation
  • Built-in Functions
  • Aggregation
  • Joins
  • Data Modification
  • Complex Joins
  • SQL Subqueries
  • Set Operations
  • Db2 on the z/OS Platform
  • Introduction to Embedded SQL
  • Program Preparation
  • Cursors
  • Performance

Related Scheduled Courses