Db2 for z/OS Application Programming and Design

PT8882
Training Summary
This course focuses on best practices used to design, create and process a Relational Database structure. Learning basic and advanced SQL provides the basis for writing application programs with embedded SQL to access Db2 databases. There are many labs throughout the course where the student will be able to practice the skills they have learned in this extensive 5-day course.
Prerequisites
Students should have experience coding in one the programming languages listed (COBOL, C, PL/1), experience with TSO/ISPF and experience with file structures such as VSAM, IMS, or QSAM.
Duration
5 Days/Lecture & Lab
Audience
This course is designed for application programmers and programmer/analysts who will write SQL statements in a high-level programming language (such as COBOL, C, PL/1) to manipulate Db2 tables in a mainframe CICS, TSO or IMS/TM environment. This course would also be beneficial to analysts and database administrators who support application teams.
Course Topics
  • Db2 Concepts, Terminology and Storage Concepts
  • Entity Relationship Modeling Techniques
  • Logical and Physical Database Design
  • Referential Integrity Rules
  • Basic SQL - Using SELECT, INSERT, UPDATE, DELETE, TRUNCATE and MERGE
Advanced SQL – Using JOIN, Subquery, UNION, EXCEPT, INTERSECT and Nested Table Expression
  • Basic Data Definition Language (DDL) - Used to ::Create and Modify Db2 Objects, such as Tables, Views, Indexes and Synonyms
  • Application Coding Considerations, including use of Host Variables, Standard Cursors, Scrollable Cursors and Non-Cursor Processing
  • Program Preparation, Bind and Locking Strategies
  • SQL Performance Considerations
  • Benefits of EXPLAIN
  • Implementing Security by using GRANT and REVOKE to control Object Privileges

Related Scheduled Courses