Target Audience

This course provides the delegate with an overview of the DB2 development process. It is aimed at those who need to understand the concepts and capabilities of DB2 at a high level.

Pre-requisites

Knowledge of the z/OS host environment is advantageous but not essential.

Course Objectives

The aim of this course is to provide the delegate, unfamiliar with DB2, with an overview of its main features. On completion of this course the student will be able to:

•     describe the DB2 environment
•     describe the process of table / data creation
•     understand the role of Data Definition statements
•     understand simple SQL Data Manipulation statements
•     understand the program development, preparation and bind processes

Course Environment

Course Details

DB2 OBJECT DESIGN AND DEFINITION OVERVIEW

The Relational Model / Data Modelling

Data Representation

Design Issues

The DB2 Environment

Data Definition Language

The DB2 Table

Table Characteristics

Column Types

INTEGER

SMALLINT

CHAR

VARCHAR

DATE

DATE formats

TIME

TIMESTAMP

Null Values

Default Values

Indexes

Index Columns

Tablespace scan vs. Index access

DATA MANIPULTAION LANGUAGE OVERVIEW

SQL - Structured Query Language

SQL Features

SQL Query Results

DB2 Environments

The Select Statement

The SELECT Clause -

The WHERE Clause

Statements Using NULL values

DISTINCT Clause

GROUP BY Clause

HAVING Clause

ORDER BY Clause

The UPDATE Statement

The DELETE Statement

The INSERT Statement

Joins

Inner Joins

Outer Joins

APPLICATION PROGRAMMING OVERVIEW

DB2 Environments

Development Cycle With DB2

SQL Statement Format

Cursor Operations

SQL Statements Used in Application Programs

SQL Error Codes

Batch Execution

Plans & Packages

Course Format

DB2 can be used if available to demonstrate some of the topics discussed such as Data Manipulation using SELECT, INSERT, UPDATE and DELETE statements. On completion of this course students will be able to describe the main features of DB2 but will not have the required hands-on experience required to develop full DB2 application programs. The comprehensive Student Guide supplied is fully indexed serving as a useful reference tool long after the course has finished. Delegates will also be able to access a free help-line with technical questions relating to topics covered on the course.