DB2 UDB SQL Coding

Course Number:  706-JK
Recommended Duration:  3 days

Intended Audience
Persons who need to work with DB2 UDB Databases.

Objectives
Students who complete this course will be able to code SQL statements to access DB2 UDB using both the Command-Line Processor (CLP) and Control Center graphical interface programs.

Course is suitable for shops still running DB2 UDB version 7; some exercises will not apply.

Prerequisites

The student should have familiarity with the environment used in the classroom (Windows, Unix, or Linux).

Topics

• Relational database concepts

• DB2 UDB concepts

• Command-Line Processor (CLP)

• Interactive tools and control center

• SELECT

• UPDATE/DELETE/INSERT

• COMMIT/ROLLBACK

• Joined and nested queries

• SQL functions and analytics

• Creating DB2 tables and Views

• DB2 UDB objects

• Catalog tables/dictionary

• Locking mechanism

• Security and authorization