Introduction to DB2

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 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 Environment This Course applies to DB2 running on a z/OS platform.

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.