Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More DB2

Related Courses

SQL Coding Workshop

Recommended Duration:
3 Days
 
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.