Interskill Learning Mainframe Training

American English British English Brazilian Portuguese French German Italian Russian Spanish (European) Spanish (Latin American)
+44 (0) 1625 441120

The Online Mainframe Training Specialists
Search   Course Catalog   Live Chat!  
Return to Catalog Home     Return to Curriculum Listing

Manage Data Definitions with DB2 v11

Duration

6 hours

Overview

The Manage Data Definitions with DB2 course describes how SQL is used to define a DB2 database and its associated objects. It looks at SQL statement syntax and the methods used to invoke SQL statements.

Audience

Programmers and DBAs requiring training in defining and building DB2 databases

Prerequisites

Completion of the 'Introduction to RDBMSs and DB2' course, or equivalent knowledge.

Objectives

After completing this course, the student will be able to:

  • Use SQL code to create databases, table spaces and tables
  • Identify DB2 table and index attributes
  • Identify database definitions

Course Content

Defining Database Objects

DB2 Objects
SQL 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

Primary, Unique and Foreign Keys
Referential Integrity
Check Constraints

Using SPUFI and DB2 Data Studio to Access DB2

Running SQL Statements on the Mainframe Using SPUFI
IBM Data Studio and DB2

Viewing Database Objects - The Catalog

Tables and Views Associated with the DB2 Catalog
Using SQL to Display DB2 Catalog Tables
Using IBM Data Studio to Display DB2 Catalog Information

Manage Data Definitions with DB2 Mastery Test

Looking for more information about Interskill Learning Products?
Contact our Learning Consultants or call us at +44 (0) 1625 441120