QMF / 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. In addition the course shows how QMF (Query Management Facility) can be used to create queries, reports, forms and procedures. It is aimed at those who have little or no previous QMF and 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 QMF. It also covers QMF report production features in detail. 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
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
use QMF to create a QUERY, FORM, PROCEDURE and REPORT
use QMF to EXPORT and IMPORT data
Course Environment
Development will be performed using:

QMF running on an 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
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’
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
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
Subqueries
Subqueries Using in
Exists
The ’All’ Subquery
The ’Any’ Or ’Some’ Subquery
QMF
QMF Home Panel
The Retrieve Command
QMF Storage Areas
Saving an Object
Retrieving an Object
Export and Import
Printing reports
WRITING QUERIES
Introduction
Entering Queries
The DRAW Command
The EDIT Command
QBE Commands
Enlarge/Reduce
Using Elements in QBE
QBe Conditions Box
Joining Tables in QBE
Using Variables in SQL Or QBE
The QMF Table Editor
FORMATTING REPORTS
The FORM.MAIN Panel
The FORM.COLUMNS Panel
The FORM.PAGE Panel
The FORM.DETAIL Panel
The FORM.FINAL Panel
The FORM.BREAKn Panel
The FORM.OPTIONS Panel
The FORM.CONDITIONS Panel
The FORM.CALC Panel
The SHOW Command
PROCEDURES
Introduction to Procedures
Creating a Procedure
Variables in Procedures
...''

Phone:01275 859666

School Address:

+ 44 (0) 1275 859666

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

IMS/DB Introduction for Programmers
WSAD Java Primer
Java Programming
Java Server Side Programming
Java Servlet Programming
Java Swing Programming
JavaServer Faces Programming (JSF)
Java ServerPage Programming
Programming with PL/1
Programming with VSAM Files
Rational Application Developer
Struts Programming
TSO/ISPF and JCL
UNIX
Visual Basic for Applications (VBA)
WebSphere MQ
Application Programming with WebSphere MQ
XHTML for Web Developers
XML / Java Programming Workshop

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: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.