Print this Page

SQL Application Programming

Abstract
(5 Days)

This course provides a thorough treatment of program development to access DB2 databases.  It includes a thorough treatment of SQL as a data manipulation and a data definition language.  It covers both the internals of the program code as well as the program development process.  In addition, it demonstrates the use of a TP monitor system such as CICS or IMS in conjunction with DB2.  Upon completion of this course, students should be able create, modify and develop programs to access DB2 databases.

Audience

Anyone with a familiarity with database management systems and the programming language in which the course is being given.  That programming language is usually COBOL, but it could be any language in use in the students' environment.

Topics

• Relational database structure review

• Basic DB2 subsystems and components

• Data selection using SQL SELECT - including joins, subselects and unions

• Data selection restrictions using WHERE, GROUP BY and HAVING

• Data update using INSERT, DELETE and UPDATE

• DCLGEN, precompiling, DBRMs, BINDing, complilation and execution

• Embedded SQL - singleton SELECTs, CURSORs, embedded SQL statements

• Dynamic SQL

• Transaction processing, concurrency and locking

• Security and authorization

• The DB2 catalog

• DB2 utilities and performance considerations

Supervised Exercises

Students will be expected to code and develop several programs to reinforce the classroom material.