Manage Data Definitions with DB2 UDB

Duration

2 to 3 hours

Overview

Audience

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

Prerequisites

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

Objectives

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

Course Content

DDL – Defining Database Objects

DB2 Objects
DDL Statements
Authorities
Creating a Basic Database

DDL – Defining a Table

Table Structure
DB2 Data Types
Create a Table
Create an Index
Drop a Table
Alter a Table

Referential Integrity

Code Referential Integrity
Code Check Constraints

Using SPUFI and Command Center to Access DB2

Using SPUFI on the Mainframe to Run SQL Statements
Using UDB Control Center to Run SQL Statements

Viewing Database Objects - The Catalog

Some of the Tables That Make Up the System Catalog
Using SQL to Display System Catalog Tables
Using UDB Control Center to Display the Catalog Graphically

Manage Data Definitions with DB2 UDB Mastery Test