Interskill Learning Mainframe Training

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

The Online Mainframe Training Specialists
Search   Course Catalogue   Live Chat!  
Return to Catalogue 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 Catalogue

Tables and Views Associated with the Db2 Catalogue
Using SQL to Display Db2 Catalogue Tables
Using IBM Data Studio to Display Db2 Catalogue 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