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 Series V11

Manage Data Definitions with DB2 V11

Duration
6 hours

Overview

Description

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 responsible for defining and maintaining 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

Creating a Table

Creating an Index

Dropping a Table

Altering 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

Course Catalog » Database Curriculum » DB2 - Database Management Series V11
 
 
 
  © All rights reserved. Interskill Learning Pty Ltd.
website designed & developed by blueapple
  HomeAbout UsProductsDemonstrationCourse CatalogDistributorsSite Map
    AOL Logo Interskill IBM