| WA1350 DB2 Universal Database (UDB) Introduction for UNIX and Windows |
|
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. |
|
| Schedule: |
|
- 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
|
|
