Course Description

Course name

Advanced DB2UDB

Course code

DB2UDBADV

Audience

Developers who are using DB2UDB SQL and need to utilizes some of the more advanced features.

Prerequisites

Programmers who have attended the introduction to DB2UDB class or have comparable experience.

Objectives

Upon successful completion, the participant will be able to:
  • review using the basic SQL structure of:

Select, From, Group by, Having and Order by

  • Create Group By queries using:

Rollup, Cube and Grouping

  • code using the following Online Analytical Processing or OLAP functions:

Rank, Dense_Rank , Row_Number, Partition By, and Aggregation Functions

  • code using the following SQL techniques:

Simple or Inner Joins, Outer Joins, Sub-Selects, Correlated Sub- Selects, Unions, Intersect and Except

  • code Action queries:

Delete, Insert and Update

  • Create queries using some the following temporary table techniques:

Nested Table Expressions, Temp tables and Declare Global

Duration

3 days

Delivery method

Classroom Interactive/workshop