Datatrain
Partners
Login
  Username
  Password
  Partner Login
 
Forgot Password?
Register Now!
Partners
Interskill Mainframe Training Newsletter - April ´17
Interskill Mainframe Training Newsletter - August ´16
Interskill Mainframe Training Newsletter - June ´15
Past Issues

Partners
Mainframe Links
Mainframe Facts - Did you know?



DidYouKnow


More facts...

Course Catalog » Database Curriculum » DB2 - Database Management System Series V10

Manage Data Definitions with DB2 V10

Duration
5 hours

Overview

Description

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.

Audience

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

Prerequisites

Basic knowledge of DB2, 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 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 » DB2 - Database Management System Series V10
 
 
 
  © All rights reserved. Interskill Learning Pty Ltd.
website designed & developed by blueapple
  HomeAbout UsProductsDemonstrationCourse CatalogDistributorsSite Map
    AOL Logo Interskill IBM