Company Profile Newsletter IT Training Business Training Coaching Consulting Schedule Accreditations Contact Us
Popular Topics:
SharePoint Training Crystal Reports Training Photoshop Training Oracle Training Microsoft Excel Training
Project Management Training Finance Training Effective Management Training
Oracle Database 11g: SQL Fundamentals I 
Print PageDB2 SQL Application Programming
Description:
This course enables you to acquire the skills necessary to produce application
programs to manipulate DB2 databases using the SQL language. Students will
learn how to embed Structured Query Language (SQL) statements and prepare
programs for execution. The course uses a combination of lecture and handson
workshop activities to enable students to gain confidence in using the SQL
language and writing application programs using embedded SQL.
- Cost: Price on application
- Duration: 4 days
- This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
Prior to attending this course, you should have some experience with COBOL.
TSO/ISPF knowledge would also be an advantage.
TSO/ISPF knowledge would also be an advantage.
The Relational Model:
Data storage and retrieval,
Origin and history of relational RDBMS products,
Basic relational concepts and terminology,
Tables,
Referential Integrity,
Inherent advantages of relational model.
Origin and history of relational RDBMS products,
Basic relational concepts and terminology,
Tables,
Referential Integrity,
Inherent advantages of relational model.
Introduction to DB2 for z/OS:
DB2 Address Spaces,
DB2 Attachments,
Logical and physical DB2 objects,
The DB2 Catalog.
DB2 Attachments,
Logical and physical DB2 objects,
The DB2 Catalog.
The SQL Language:
SQL data types,
NULL values.
NULL values.
Data Retrieval:
Using features of the SELECT verb,
Using Boolean operators,
Wildcards, LIKE, Case Expression, Distinct, range comparisons,
ORDER BY.
Using Boolean operators,
Wildcards, LIKE, Case Expression, Distinct, range comparisons,
ORDER BY.
Built-In Functions:
Aggregate/Column functions: GROUP BY – grouping results, HAVING,
Scalar functions.
Scalar functions.
Joining tables, Sub-Queries:
Inner and Outer Joins,
Sub Queries,
Nested table Expressions,
UNION.
Sub Queries,
Nested table Expressions,
UNION.
Data Modification:
INSERT, UPDATE, and DELETE,
COMMIT and ROLLBACK,
CICS Considerations,
2 phase Commit.
COMMIT and ROLLBACK,
CICS Considerations,
2 phase Commit.
Embedded SQL:
DCLGEN and host structures,
Embedded SELECT, SQLCA,
Error-handling,
Declaring and working with Cursors,
Commit and Rollback strategies,
Handling NULLS.
Embedded SELECT, SQLCA,
Error-handling,
Declaring and working with Cursors,
Commit and Rollback strategies,
Handling NULLS.
Program Preparation:
DB2 Precompiler,
Compile and Link,
Bind Package,
Bind Plan.
Compile and Link,
Bind Package,
Bind Plan.
Stored Procedures:
An introduction to creating Stored Procedures,
SYSROUTINES,
Administration,
Calling Stored Procedures,
Passing Parameters,
Triggers.
SYSROUTINES,
Administration,
Calling Stored Procedures,
Passing Parameters,
Triggers.
Performance Considerations:
Data structure design issues,
Normalisation,
DB2 Optimiser and Access Paths,
Indexes, Stage1 and Stage 2 predicates,
DB2 Lock Management,
Interpreting EXPLAIN data.
Normalisation,
DB2 Optimiser and Access Paths,
Indexes, Stage1 and Stage 2 predicates,
DB2 Lock Management,
Interpreting EXPLAIN data.
Some Additional Topics:
Scrollable Cursors,
Security,
DB2 Catalog
Security,
DB2 Catalog
Hands-On Workshop Exercises: