Interskill Mainframe Training Newsletter - April ´17
Interskill Mainframe Training Newsletter - August ´16
Interskill Mainframe Training Newsletter - June ´15
Past Issues

Mainframe Links
Mainframe Facts - Did you know?


More facts...

Course Catalog » Database Curriculum

Manage Data Definitions with DB2 V10

5 hours



The Manage Data Definitions with DB2 course explains how the SQL Data Definition Language (DDL) is used to define DB2 databases and database objects. The course also provides details describing how SQL statements are run and the methods used to view database objects.


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


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


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


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 DB2 Data Studio to Access DB2

Using SPUFI on the Mainframe to Run SQL Statements

Using DB2 Data Studio 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 DB2 Data Studio to Display the Catalog Graphically

Manage Data Definitions with DB2 Mastery Test

Course Catalog » Database Curriculum
  © All rights reserved. Interskill Learning Pty Ltd.
  HomeAbout UsProductsDemonstrationCourse CatalogContact UsSite Map
      Interskill IBM