WA1343 DB2 Fundamentals for zOS or UDB
This course is designed to provide information and practise that will allow users of DB2, to create tables, use them and also access remote databases. Different environments will be reviewed for client server processing. DB2 components will be reviewed. The major components of DB2 will be discussed and basic SQL for DB2 reviewed and practised.
Objectives:
After completing this course the student should have knowledge of:
  • The DB2 family of products
  • Components of DB2
  • Tools and utilities
  • Major components of DB2
  • Basic SQL statements
  • Programming techniques for DB2
  • Distributed data.
  • DB2 Administration
Target Audience:
Anyone wishing to know more about DB2
Prerequisite:
Anyone with basic computer processing knowledge.
Format:
Classroom instruction, workshops and demonstrations of DB2.
Duration:
Two days.
Schedule:
  • Day 1
    • The DB2 Family
    • Data Design
    • Creating Tables and Indexes
    • Accessing DB2
    • workshop
    • SQL INTRODUCTION
    • Combining Sets of Data (SQL)
    • workshop
  • Day 2
    • Programming with DB2
    • DB2 Administration
    • Distributed data
Schedule this course
Download this page as a word document