G502 DB2 Concepts and Facilities

Course Code: G-502
Recommended Duration: 2 Days

Benefits

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.

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.

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.

Related IBM Materials

None

Major Topics Include

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

Exercises

There are four hands-on exercises, one pencil and paper exercise, and one optional machine exercise

Course Description

DB2 Concepts and Facilities