Course Description

SQL Coding Workshop

This course: course objectives; course outline;
DB2 curriculum; Topic list; Course list; Home page

Benefits

Students who complete this course will be able to code SQL statements to access and update DB2 objects. S/he will also learn the SQL for object definition, object maintenance, and object deletion.

Audience

Technical personnel who need to work with DB2 data bases from a DB2I perspective.

Prerequisites

Experience using ISPF/PDF.

IBM Materials Required

This course is drawn from this IBM manual; access to it in the classroom is desirable but not required:

DB2 SQL Reference

• Relational data base concepts
• DB2 concepts
• DB2I, SQL, and SPUFI
• SELECT, UPDATE, DELETE, INSERT
• COMMIT, ROLLBACK
• Joined and nested queries
• Creating DB2 tables
• DB2 objects
• DB2 system catalog tables
• Security considerations
• EXPLAIN and efficiency considerations

Exercises

There are nine standard machine exercises and one optional machine exercise.