Description
In this DB2 SQL Training training class, students will learn the DB2 SQL starting at the most basic level and going to the most advanced level. This course includes many examples.
Delegates will learn how to
- Gain a deeper knowledge and understanding of the DB2 SQL and how to write it.
Outline
The Basics of SQL
The WHERE Clause
Aggregation
Join Functions
Using Nexus for DB2
Date Functions
OLAP Functions
Temporary Tables
Sub-query Functions
Strings
Interrogating the Data
View Functions
Set Operators Functions
Table Create and Data Types
Data Manipulation Language (DML)
Statistical Aggregate Functions
Prerequisites
There are no prerequisites for this course.