SQL Coding Workshop
- Recommended Duration:
- 3 Days
- Version
- DB2 Version 7. Course is suitable for earlier DB2 Versions.
- Benefits
- Students who complete this course will be able to code SQL statements to access and update DB2 objects using DB2I /SPUFI.
- Audience
- Technical personnel who need to work with DB2 data bases using DB2I.
- Prerequisites
- Recent experience using TSO/ISPF.
- Major Topics
-
- Relational data base concepts
- DB2 concepts
- DB2I, SQL, and SPUFI
- SELECT, UPDATE, DELETE, INSERT
- COMMIT, ROLLBACK
- Joined and nested queries
- UNION
- Creating DB2 tables
- DB2 objects
- Views
- DB2 system catalog tables
- Security considerations
- EXPLAIN and efficiency considerations
- Exercises
- There are seven machine exercises.