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