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

Share with others

Can't Read? Click to Generate New Code

Enter the verification code shown above into the text box below