Relational Concepts and DB2
 

This 2 day course is:

an introduction to DB2 SQL coding for end-users, programmers, designers, and data base administrators.

Duration: 2 days

Delivery: Class Lecture

Audience: 

End-users, programmers, designers and data base administrators

Outline:

1. Relational Concepts

 Relational Introduction
 Design Concepts
 Modeling Fundamentals
 Basic Logical Modeling
 Lab

2. DB2 Concepts

 DB2 Fundamentals
 Data Types
 Object Hierarchy
 SQL Language Structure
 Processing Data with SQL
 Data Models and Use in DB2
 Interactive Tools
 Lab

3. Introductory SQL

 Data Manipulation Language in DB2
 SQLCODE handling/techniques
 SELECT: Syntax and Structure
 Basic Predicate Types and Uses
 WHERE: the search conditions
 ORDER BY clause
 BETWEEN clause
 UNION, UNION ALL clause
 Basic Scalar Functions
 Lab

4. More SQL Syntax

 GROUP BY
 HAVING clause
 Subquery Types
 Subselects : One row results
 Subselects : Multiple row results
 More Predicate Types
 Correlated Subselects
 Registers use in SELECT's
 INSERT syntax
 UPDATE syntax
 DELETE  syntax
 Lab

5. Advanced SQL

 Basic Joining of Tables in SQL
 Joining Techniques in SQL
 Join Expression Coding
 Coding Multiple Joins
 Join Types in a Query
 Lab

6. SQL Performance Basics

 DB2 Optimizer Functions
 Understanding Predicate Types
 Locking Types and Conditions
 Access Paths Definitions
 Principles of Tuning: "Explain"
 Lab