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

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

Course Objectives
Course description
Home page

this page last updated: 15 February, 2010
this page copyright © 2010 by The Trainer's Friend, Inc.