DB2 SQL Techniques for Performance with COBOL Course

Course Code: RT 56
Course Abstract:

This course provides the knowledge of using DB2 UDB SQL interactively, and via programming languages such as COBOL, Assembler, PL/1, or C++ to manipulate DB2 data from a mainframe or a Client Server environment.

NOTES:

1) The standard workshops are DB2 UDB mainframe based, please be sure to specify the environment utilized when requesting class. (I.e. OS/390, Unix, Linux, Windows NT/2000/XP, etc.)
2) This course is intense and moves quickly into advanced topics.

Audience: This course is designed for programmers, analysts and designers.
Duration: 5 days
Learning Outcomes:

Upon completion of this course, the participant will be able to use DB2/SQL through:
> Using DB2/SQL Technology in SQL
> Recognizing Referential Integrity Rules
> Designing and Coding DB2/SQL Applications for Performance with Index and Locking Considerations
> Using Basic and Advanced SQL Coding Syntax
> Embedding SQL Statements in Programs

Course Topics:

DB2 Views, Nulls and Security Considerations
DB2 Data Manipulation Language Constructs
Structured Query Language Coding Syntax and Techniques
Where DB2 Fits and SQL Hints for Effective Queries
DB2 Usage in a HOST Language

Prerequisites: Prior programming experience is required.
Note: All fields are required
At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.


We Value Your Privacy!

Ready to get started or in need of more information? Contact us today.

Go To Blog Virtual Learning