DB2 UDB Concepts and Facilities

Course Number: 703-JK
Recommended Duration: 3 days

Intended Audience
Applications developers who need to develop or maintain applications in a DB2 UDB environment, or who need a general understanding of DB2 UDB.

Course Overview
Students learn relational database terminology, and are introduced to DB2 UDB facilities most important to application developers. Students learn basic SQL, are exposed to the DB2 UDB application development environment, and develop skills normalizing data.

DB2 Version 7. Class is suitable for those using DB2 version 5 or 6 also.

Prerequisites
Students should have the desire to learn about SQL and DB2 UDB. Students should also have recent experience using the available text editor.

Topics

DB2 UDB features
DB2 UDB Objects
Graphical user interface tools and control center
Command Line Processor (CLP)
The DB2 UDB catalog
Relational operations: SELECT, PROJECT, and JOIN
DB2 UDB 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 UDB application development: compilation and execution
Host variables
COMMIT / ROLLBACK

DB2 UDB Concepts and Facilities

DB2 UDB features

DB2 UDB Objects

Graphical user interface tools and control center

Command Line Processor (CLP)

The DB2 UDB catalog

Relational operations: SELECT, PROJECT, and JOIN

DB2 UDB 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 UDB application development: compilation and execution

Host variables

COMMIT / ROLLBACK