DB2 Concepts and Facilities

Course Number:  599-TF
Recommended Duration:  2 days

Intended Audience
Application developers who need to develop or maintain applications in a DB2 environment, or who need a general understanding of DB2 capabilities and use.

Course Overview
This is an introductory course for people who just need an overview.

Objectives
Students who complete this course will learn the terminology associated with relational data bases, and be introduced to the facilities of DB2 that are most important to application developers.  They will be exposed to basic SQL statements and the DB2 application development environment.  They will also develop skills in normalizing tables.

Prerequisites
The student entering this course should have experience in designing and coding application programs in COBOL or PL/I, in the application environment (CICS, IMS/DB/DC, TSO, or batch) in which DB2 will be used.

Topics

• DB2 features

• Relational data base concepts

• DB2 objects

• The DB2 catalog

• Relational operations: SELECT, PROJECT, and JOIN

• DB2 data types

• Referential integrity and normalization

• SQL data manipulation introduction: SELECT, UPDATE, DELETE, INSERT commands

• SQL data definition introduction: CREATE, DROP, ALTER commands

• SQL data control introduction: GRANT, REVOKE

• DB2 application development: pre-compile, compile, bind, link, execute

• DCLGEN

• Host variables

• COMMIT