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.
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.
Must have attended a SQL Fundamentals course. The participant should have some knowledge of COBOL. TSO/ISPF experience is a mandatory requirement.
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
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