DB2 SQL Training Course

Overview

The 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, participants 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.

Objectives

At the end of DB2 SQL Training course, participants will:

• Understand the basic concepts and facilities of DB2
• Be able to create and execute simple SQL statements
• Be able to create the desired results table using an SQL select statement
• Be able to restrict rows using WHERE clause
• Sort output data into desired sequence
• Learn basic CASE Expressions
• Learn the Data and Time formats
• Learn to format data using Scalar functions
• Be able to obtain aggregate data using GROUP Functions
• Learn the limitations and capabilities of SQL Group Functions
• Know how to use subqueries
• Create both simple and complex subqueries
• Be able to identify and use likely join column relationships
• Be able to show ownership of table columns
• Know how to use the WHERE clause conditions to limit the impact of
• Be able to combine the results from multiple queries using UNION
• Know how to execute a true Outer Join
• Be able to create a table and its columns
• Use both methods to Insert data
• Know the importance of the WHERE clause in Updates, and Deletes
• Be able to Insert, Update, and Delete rows
• Be able to use ROLLBACK / COMMIT when needed

Suggested Audience

• Application Programmers
• Database Designers
• DB2/SQL IT Personnel

Duration - 3 Days

Prerequisites - Basic understanding of computers and databases.

Syllabus

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