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

Share with others

Can't Read? Click to Generate New Code

Enter the verification code shown above into the text box below