Schedule today!

Call Peggy at
  (800) 252-0652


Contact Us

More DB2

Related Courses

DB2 Concepts and Facilities

Recommended Duration:
2 Days
Version
Suitable for shops running earlier versions.
Benefits
Students learn relational database terminology, and are introduced to DB2 facilities most important to application developers. Students learn basic SQL, are exposed to the DB2 application development environment, and develop skills normalizing data.
Audience
Applications developers who need to develop or maintain applications in a DB2 environment, or who need a general understanding of DB2.
Prerequisites
Students should have 6 months experience designing and coding COBOL, PL/I, or C application programs in an environment (CICS, IMS, TSO, or batch) where DB2 will be used. Students should also have recent experience using the ISPF text editor and the ability to code JCL to run simple batch jobs, or have completed the "Structured COBOL Workshop" course within the last 12 months.
Major Topics
  • DB2 features 
  • DB2 Objects
  • The DB2 catalog 
  • Relational operations: SELECT, PROJECT, and JOIN 
  • DB2 data types 
  • Referential integrity and normalization 
  • SQL data manipulation introduction: SELECT, UPDATE, DELETE, INSERT commands 
  • SQL data definition introduction: CREATE, DROP, ALTER commands
  • SQL data control introduction: GRANT, REVOKE 
  • DB2 application development: pre-compile, compile, bind, link, execute
  • DCLGEN 
  • Host variables 
  • COMMIT
Exercises
There are three standard machine exercises, one pencil and paper exercise, and one optional machine exercise.