Introduction to DB2 SQL Training

This DB2 training class uses a hands-on approach to teach application programmers and designers the essential concepts of DB2 SQL.  Upon completion of this DB2 class, students will understand DB2 relational databases, be able to execute both simple and complex queries using DB2 SQL, and be able to create and manipulate table data.

1. DB2 Overview
   1. DB2 Concepts & Facilities
   2. Relational Concepts
   3. Introduction to SQL
   4. Basic SQL SELECT Statement
2. Using the Select Statement
   1. Full Syntax of SELECT Statement
   2. Result Tables
   3. ALL vs. DISTINCT
   4. Column Arithmetic
   5. WHERE Clause
   6. ORDER BY Clause
3. Case Expressions
   1. Using CASE Expressions
4. Scalar Functions
   1. DATE and TIME Formats
   2. Scalar Functions
   3. Special Registers
5. SQL Group Functions, and Group By
   1. Group Functions
   2. GROUP BY
   3. HAVING
6. Subqueries
   1. Simple Subqueries
   2. Subquery with IN, ANY/SOME, ALL, EXISTS
   3. Correlated Subqueries
7. Joins
   1. Join Concepts and Keys
   2. Joins vs Subqueries
   3. Planning a Query
8. Union
   1. Combining Result Tables
   2. UNION
   3. Outer Join using Subqueries
9. Creating Tables
   1. CREATE TABLE
   2. Primary / Foreign Keys
   3. DROP TABLE
   4. ALTER TABLE
10. SQL Data Manipulation
    1. INSERT Single Rows into a Table
    2. INSERT Multiple Rows into Tables with Queries
    3. UPDATE One or More Rows
    4. DELETE One or More Rows
    5. ROLLBACK / COMMIT