Verhoef  Training

DB :: DB2-SQL Application Programming

"Going the extra mile with ICT"

PO Box 2466, Cape Town 8000, South Africa
tel: 0861-102017 • fax: +27 21 856-0042 • e-mail: training@verhoef.co.za

Related Courses
» SQL Fundamentals
» DB2 Fundamentals
» Advanced SQL Workshop

Curricula Info
» MVS - z/OS - z/VM
» DB2 - SQL
» CICS TS
» IBM MQ
» Programming
» UNIX - Linux
» Networking
» Web Technologies
» Business Skills

Resources
» IBM Support
» IBM Redbooks
» Mainframe Month
» Mainframes.com
» z/Journal
» CIO Magazine
» Search390.com
» Linux Links
» XML Writer

Links
» CICS Central
» Programmer's Heaven
» Develoment Guru
» COBOL Centre
» COBOL User Groups
» REXXLA Home
» XML.com

Verhoef Sites:
» Verhoef USA
» Verhoef UK

 

Curriculum Description | Curriculum Roadmap | Curriculum Schedule | Course Enrolment

4 days   *   Intermediate   *   Lecture and Labs

Course Summary:
This course will provide students with SQL skills needed to build simple or complex interactive queries against data which is stored in DB2 (or similar) databases. The course includes an introduction to the structure and function of the DB2 product, and a comprehensive examination of the SQL language, including a progressive series of hands-on workshops to provide the student with experience in using the language.

Target Audience:
All personnel who will be developing applications with DB2 and need to understand the usage of embedded SQL in a COBOL batch and COBOL/CICS host programming environment.

Recommended Prerequisites:
Must have attended a SQL Fundamentals course. The participant should have some knowledge of COBOL. TSO/ISPF experience is a mandatory requirement.

Course Objectives:
This course focuses on using the SQL language and DB2 for z/OS in the business applications environment. Through a combination of lectures and a progressive series of workshops, the audience will gain a solid grounding in SQL and how it is used interactively and embedded in host language programs.

Key Topics:

The Relational Data Model

DB2 Introduction

The SQL Language

Using QMF and SPUFI

Data Modification with SQL

SQL Built-in Functions

Embedded SQL (emphasis on COBOL)

Advanced Data Retrieval

Data Resource Locking

Last modified: 17-Sep-2015

Site Map

 Home
  |
  •-- About Us
  |----Our Mission
  |----BEE Strategy
  |----Complaints
  |----Careers
  |----PAIA manual
  •-- Courses
  •-- Schedules
  •-- Our Clients
  •-- News and Events
  •-- Contact Us
  •-- Your Privacy
  |
  •-- MVS - z/OS - z/VM
  |----Roadmaps
  |----Schedule
  |
  •-- DB2 - SQL
  |----Roadmaps
  |----Schedule
  |
  •-- CICS TS
  |----Roadmaps
  |----Schedule
  |
  •-- IBM MQ
  |----Roadmaps
  |----Schedule
  |
  •-- Programming
  |----Roadmaps
  |----Schedule
  |
  •-- UNIX - Linux
  |----Roadmaps
  |----Schedule
  |
  •-- Networking
  |----Roadmaps
  |----Schedule
  |
  •-- Web Technologies
  |----Roadmaps
  |----Schedule
  |
  •-- Business Skills
  |----Roadmaps
  |----Schedule
  •