Introduction to DB2 for z/OS and OS/390 and SQL Coding
 

This 3 day hands-on workshop trains:

the DB2 for z/OS and OS/390 Query user and application developer to code simple and complex SELECT and data modification statements. In addition, this course provides an informative overview of the DB2 for z/OS and OS/390 environment and basic SQL performance tuning techniques.

Topics Covered:

• DB2 Concepts and Facilities
• Basic Single Table SQL
• Working with Multiple Tables
• Summary Processing
• Data Modification
• Introduction to Performance

Objectives:

• To gain understanding about DB2 z/OS and OS/390
• To code simple SQL statements
• To learn about INSERT, DELETE and UPDATE

Duration: 3 days

Delivery: Class lecture and hands-on lab

Audience: 

Anyone who needs an introduction to DB2 for z/OS and OS/390 and will perform SQL queries, including end-users, programmers, application designers, database administrators, and system administrators who do not have a working knowledge of the SQL Data Manipulation Language (DML).

Prerequisites:

Working knowledge of TSO and/or an SQL Query tool.

Outline

I  DB2 Concepts

DB2 Environment
Data Structures
 Structured Query Language
Application Processes
Concurrency and Recovery
DB2 Interactive
Workshop

II. Basic Single Table SQL

Data Retrieval
Result tables
SELECT Statement Structure
Selecting Columns: SELECT
Selecting Rows using: WHERE
Using Functions and Expressions
Ordering the result table rows: ORDER BY
Merging intermediate results: UNION
Special Registers
Workshop

III. Working with Multiple Tables

Joining Data from multiple Tables
Inner join
Full Outer Join
Left Outer Join
Right Outer Join
Using multiple join types in a Query
Nested Table Expressions
Workshop

IV. Summary Processing

Summary results: GROUP BY
Limiting Groups: HAVING
Using Subqueries
How to code subqueries
Correlated subqueries
Non-correlated subqueries
Workshop

V. Data Modification

Inserting data into tables
Updating data
Deleting rows from tables
Workshop

VI. Introduction to Performance

What is the Optimizer?
Predicate Types
(Indexable, Stage 1 and Stage 2)
Access Paths and how they work
Explain - the Basics
Workshop