Db2 for z/OS: Application Developer Boot Camp [DBAP]

This comprehensive ten-day 'Boot Camp' course provides attendees with an accelerated learning approach to developing applications in a Db2 for z/OS environment. The course is ideal for those coming new to the Db2 for z/OS environment. The regular, hands-on lab exercises give students the opportunity to try out their newly-gained skills immediately. Throughout the course reference will be made to best practices to ensure that the SQL and application programs will run efficiently and effectively. On successfully completing this boot camp, attendees will have reached the skill level needed to enable them to write, maintain and amend programs for a Db2 for z/OS environment 

10 Days

Hands-On

Private-Only

Email at Info@zcubedtech.com  to find out more

Day 1: 

• DBMS Overview
• Relational Theory & Concepts
• Db2 System & Operations
• Db2 Interactive (DB2I)

Day 2: 

• Db2 Data Objects
• Db2 Table Design
• Db2 Index Design & Usage 

Day 3: 

• Db2 Physical Database Design & DDL
• Basic SELECT Statements
• SQL Built-in Functions

Day 4: 

• Joins & Nested Table Expressions
• Unions, Intersections, Exceptions & Case Expressions
• Subqueries

Day 5: 

• Table Modification Commands
• Basic Application Programming

Day 6: 

• Cursor Processing
• Program Preparation

Day 7: 

• Db2 Locking & Concurrency
• Using Views & Temporary Tables
• Materialized Query, Clone & Temporal Tables

Day 8: 

• Distinct Data Types & User Defined Functions
• Triggers 
• Advanced DML options

Day 9: 

• The Db2 Optimizer
• Db2 EXPLAIN
• Db2 Performance Overview

Day 10: 

• Db2 Traces
• Monitoring Application Performance
• Performance Analysis

•  Describe the relational concepts and theory, and the advantages of a RDBMS
• List the components of the Db2 system and their functions, and describe how they are controlled
• Utilize all the functions available with Db2 Interactive (DB2I)
• Describe the internal structure and components of Db2 UDB for z/OS databases
• Use SPUFI to code SQL statements
• Design and assess a logical database model
• Design and implement efficient physical databases from the logical model using relevant options to create and amend storage groups, databases, table spaces, tables, indexes, aliases, synonyms, etc.
• Code SQL SELECT statements including those using techniques such as joins, nested table expressions, subqueries, unions and case expressions
• Code SQL INSERT, UPDATE, DELETE & MERGE statements to modify data
• Embed SQL statements into an application programming language such as COBOL, PL/I or Assembler
• Understand the differences between views, nested table expressions, common table expressions, and temporary tables and select the best option for a specific task
• Understand the use of materialized query tables, clone tables and temporal tables and the additional SQL statements associated with them
• Describe the use of distinct data types, user-defined functions, and OLAP functions within Db2 for z/OS
• Understand how and when triggers may be used
• Understand and control the locking strategy used by Db2 to maintain data integrity
• Understand the Db2 optimizer and the use of EXPLAIN in determining access path, statement efficiency and choosing optimal code
• Plan for application monitoring and tuning
• Use Db2 traces to identify problem areas and identify tuning opportunities 

Experience in using COBOL, PL/I or Assembler in a mainframe application programming role, an ability to use TSO/ISPF and a working knowledge of z/OS JCL 

Email at Info@zcubedtech.com  to find out more