DB2 SQL Workshop

Case Training
Bristol, Edinburgh, Leeds, London, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This training course teaches the delegate all SQL statements required to read, manipulate and join DB2 tables. It is aimed at those who have little or no previous SQL experience.

Pre-requisites
A working knowledge of the z/OS ISPF host environment is advantageous but not essential.

Course Objectives
The aim of this course is to provide the delegate with the necessary skills to perform simple and complex queries using DB2I / SPUFI. On completion of this course the student will be able to:

understand how tables are defined
describe the data types available when defining DB2 columns
describe the importance of an Index for certain queries
use DB2I and SPUFI
write SELECT, UPDATE, DELETE and INSERT SQL statements
join tables together
use inner joins and outer joins
write non-correlated and correlated subqueries
use DB2 functions and the CASE statement
Course Environment
Development will be performed using:

IBM Mainframe
Course Details
INTRODUCTION TO DB2
The Relational Model
Data Representation
The DB2 Environment
Data Definition Language
The DB2 Table
Column Types
INTEGER
SMALLINT
CHAR
VARCHAR
DATE
DATE formats
TIME
TIMESTAMP
Null Values
Default Values
Indexes
Index Columns
Tablespace scan vs. Index access
DB2 INTERACTIVE (DB2I)
DB2I Options
SPUFI - SQL Processor Using File Input
Running Queries
SPUFI Defaults
SPUFI - Setting AUTOCOMMIT to NO
DB2 Commands
DB2 Utilities
The DB2I Defaults Panel
DATA MANIPULATION LANGUAGE
SQL - Structured Query Language
DB2 Environments
SQL Features
SQL Query Results
The SELECT Statement
The ’As’ Clause
Column concatenation
Expressions
Functions
Special Registers
The WHERE Clause
Special Operators
NOT Operand
IN Operand
LIKE Operand
BETWEEN Operand
Statements Using Nulls
Column Functions
Using ’Distinct’
Multiple Column IN Predicate
Multiple Column Subselect
Multiple Column Basic Predicate
The GROUP BY Clause
The HAVING Clause
The ORDER BY Clause
Fetch First ’n’ Rows Only Clause
Special Registers
Current Date
Current Time
Current Timestamp
User Keyword
The UPDATE Statement
Update with Subselect
The DELETE Statement
Self-Referencing UPDATE / DELETE
The INSERT Statement
The Mass Insert Statement
Functions
Scalar Functions
Function Examples
Date, Time and Timestamp Functions
The Case Statement
JOINS
Cartesian Joins
Inner Joins
Outer Joins
Nested Table Expression
The UNION Statement
Fullselects and Subselects
Union Example in a View
Union Example in a Table Specification
Union Example within a Where Clause
Union Example within an Insert or Update
Subqueries
Subqueries Using in
Exists
The ’All’ Subquery
The ’Any’ Or ’Some’ Subquery
Fetch First ’n’ Rows Only Clause
Fetch First vs Optimize For
Using Fetch First for Singleton Selects
SQL VERSION 8 ENHANCEMENTS
Select from Insert
Select from Insert Example
Result Table Rows from the Insert Statement
Select From Insert in a Cursor
Select From Insert - New Order By Option
Select From Insert - Error Processing
Select From Insert - Using Cursors With Hold
Select From Insert - Using Savepoints
Updates and Deletes against Result Table Rows
Select From Insert - Considerations
Expressions / Functions in Group By
Qualified Column names in Insert and Update
Is Not Distinct From
Multiple Distinct
Scalar Fullselect
Scalar Fullselect Examples
Scalar Fullselect Restrictions
Common Table Expressions
Writing a Common Table Expression
Common Table Expression Example
Common Table Expression Considerations
Recursive SQL
Recursive SQL Example
Recursive SQL - Controlling Depth of Recursion
Read Only Using Update Locks
Session Variables
New Special Registrers
...''

Phone:01275 859666

School Address:

+ 44 (0) 1275 859666

Jobs & Resumes: Bristol, Edinburgh, Leeds, London
Houses & Roommates: Bristol, Edinburgh, Leeds, London

CA-Easytrieve Reporting and File Manipulation
CA-TELON Advanced Programming
CICS Introduction for Programmers
CICS for Applications Programmers (using VSAM)
COBOL
DB2 Advanced Programming
DB2 Application Data Recovery
DB2 Application Performance and Tuning
DB2 Development for Applications Programmers
DB2 UDB Development for Applications Programmers
DB2 UDB Development for Database Administrators
E-Commerce
Enterprise JavaBeans Workshop
File-AID for DB2
File-AID for z/OS
HPS / AppBuilder Applications Development
HPS / AppBuilder Protocycling
HTML and JavaScript

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.