G502 DB2 Concepts and Facilities

DB2 Concepts and Facilities - Topical Outline

Introduction to DB2

DB2 Features

Associated Products

Relational Concepts

DB2 Objects: Storage Group, Data Base, Table Space, Table, Index,

View, Synonym, Alias, Sequence

The DB2 Catalog and Directory

DB2 System Components

Computer Exercise: Course Set up

The Sample Application

Relational Operations on Tables: Select, Project, Join

DB2 Tables

Data Types

Table Ownership

Referential Integrity

Normalization

Computer Exercise: Designing and Normalizing a Data Base

SQL Overview

Data Retrieval - 1

Simple Selects

Computer Exercise: Basic Data Retrieval

Data Retrieval - 2

Joins

Subqueries

Computer Exercise: More Complicated Data Retrieval

Data Modification

UPDATE

DELETE

INSERT

MERGE

Data Definition

CREATE

DROP

ALTER

Data Control

GRANT

REVOKE

Computer Exercise: Data Modification

Application Development

Control Flow

DCLGEN

Host Variables

Cursors

Compile Process

BIND Process

Execution Process

Batch

On-line

COMMIT

(Optional) Computer Exercise: Walk-through in Application Development

G502 / 2 Days

Materials version: V3.x

Course Objectives
Course Description
Home page