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
The DB2 Catalog
DB2 System Components
The Sample Application

Relational Operations on Tables: Select, Project, Join

DB2 Tables
    Data Types
    Table Ownership
    Referential Integrity
Normalization
Exercise: Normalizing a Set of Data

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

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
    Computer Exercise: Walk-through in Application Development

Course information: G-502 / 2 Days   These Materials © Copyright 2007 by Hunter Cobb    V3.x

Course Objectives
Course description
Home page

this page last updated: 29 January, 2007
this page copyright © 2007 by The Trainer's Friend, Inc.