Course Description

Course name

DB2 Structured Query Language For BSA's

Course code

DB2SQL

Audience

BSA's who need to use SQL to create simple queries from a DB2 database.

Prerequisites

Familiarity with TSO is helpful.

Objectives

Upon successful completion, the participant will be able to:
  • code simple SQL to solve business problems using:

Column and Scalar Functions

Where

Group By

Having

Order By

  • code using the following SQL techniques:

Joins

Sub-Selects

Views

Duration

3 Days