DB2 Universal Database (UDB) Introduction for UNIX and Windows Training

Course #:WA1350

DB2 Universal Database (UDB) Introduction for UNIX and Windows Training

This course is designed to provide information and practise that will allow users of DB2 for UNIX and WINDOWS, to create tables, use them and also access remote databases. Different environments will be reviewed for client server processing. DB2 components will be reviewed along with basic communication characteristics. The major components of DB2 will be discussed and basic/intermediate SQL for DB2 reviewed and practised.

Objectives:
  After completing this course the student should be able to:
  • The DB2 family of products
  • Client-Server components for DB2
  • Tools and utilities
  • Major components of DB2
  • Basic and intermediate SQL statements
  • Programming techniques for client-server processing and distributed data.
Target Audience:
  Anyone wishing to know more about DB2 UDB for UNIX and WINDOWS
Prerequisite:
  Anyone with basic computer processing knowledge.
Format:
  Classroom instruction, workshops and demonstrations of DB2 UDB.
Duration:
  Two days.

Outline of DB2 Universal Database (UDB) Introduction for UNIX and Windows Training

Day 1

  • The DB2 Family
  • Getting started
  • Creating Tables and Indexes
  • workshop
  • SQL INTRODUCTION
  • Combining Sets of Data (SQL)
  • workshop

Day 2

  • Creating Objects
  • Advanced SQL Review
  • DB2 Locking
  • DB2 Data Management
  • Programming with DB2
  • SQL Programming Basics
  • workshop
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.