I/S Resource Group: DB2 Concepts and Facilities, Training, DB2, Relational, database, SELECT, SQL, INSERT, UPDATE, DELETE, join, outer, query, table, view

DB2 Concepts & Facilities

Abstract
(3 Days)

This course provides a comprehensive introduction to the DB2 database product. Although it does not include DB2 access through programming, it does show how DB2 can be manipulated through the on-line SPUFI and QMF facilities. It provides a basic knowledge of SQL, DB2's data manipulation language, as well as an introduction to the basic objects in the DB2 environment. Upon completion of this course, students should be able to run queries against DB2 databases, and proceed to more advanced involvement with DB2.

Audience

Anyone with a basic knowledge of the MVS operating system and TSO. It is a natural starting point for programmers, analysts and DBA's.

Topics

Basic relational database concepts - tables, rows, columns
Basic querying using SQL SELECT
Table updates - INSERT, DELETE, UPDATE
Using SPUFI to issue SQL statements
Using QMF to issue SQL statements and produce reports
DB2 objects - TABLESPACEs, INDEXSPACEs, STOGROUPs
INDEXes and VIEWs
Analyzing performance with EXPLAIN
Keys and referential integrity
The DB2 Catalog
Creating an application through BINDing
Security and concurrency considerations

Supervised Exercises

As an overview, much of this class is offered as lecture. Simple SQL queries will be assigned to the students.