Manage Data Definitions with DB2 UDB

Duration

2 – 3 hours

Overview

Audience

Programmers and DBAs requiring training in defining and building DB2 databases.

Prerequisites

Basic understanding of DB2 UDB, relational databases, and system design.

Objectives

After completing this course, the student should be able to:
  • Define DB2 databases and objects using SQL Data Definition Language (DDL)
  • View and understand database definitions

Course Content

Unit 1 DDL – DEFINING DATABASE OBJECTS

  • Identify DB2 objects
  • Identify DDL statements
  • Understand authorities
  • Create a basic database

Unit 2 DDL – DEFINING A TABLE

  • Understand table structure
  • List DB2 data types
  • Create a table
  • Create an index
  • Drop a table
  • Alter a table

Unit 3 REFERENTIAL INTEGRITY

  • Define and code referential integrity
  • Define and code check constraints

Unit 4 USING SPUFI AND COMMAND CENTER TO ACCESS DB

  • Use SPUFI on the mainframe to run SQL statements
  • Use UDB control center to run SQL statements

Unit 5 VIEWING DATABASE OBJECTS – THE CATALOG

  • Identify some of the tables that make up the system catalog
  • Use SQL to display system catalog tables
  • Use UDB control center to display the catalog graphically
 
© Copyright 2007. All rights reserved. Interskill Learning, Inc.