SQL Query Building in DB2 - Objectives

On successful completion of this course, the student, with the aid of the appropriate reference materials, should be able to:

1. Define the basic constructs and concepts of relational databases
   
2. Describe the fundamental components of DB2
   
3. Code SQL statements to access DB2 tables
   
4. Execute SQL statements using QMF
   
5. Create and use View definitions
   
6. Understand and use outer joins in SQL data retrieval operations.

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

Topical outline
Course description
Home page

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