| WA1297 SQL WORKSHOP for DB2 |
|
This comprehensive 2 day workshop provides the hands on experience to effectively apply Structured Query Language (SQL) to many business problems. |
|
| Objectives: |
|
After completing this course the student should be able to:
- understand the concepts of a relational database system.
- understand the concepts of entity and referential Integrity.
- write comprehensive SQL queries to access data on DB2 .
- code SQL queries to insert, update or delete rows on DB2.
- code basic SQL to create views, tables or indexes.
|
|
| Target Audience: |
|
Programmers, Analysts, Project leaders, managers and end users, who need to access data on a DB2 type, relational database. |
|
| Prerequisites |
|
Previous experience with a computer system.
|
|
| Duration |
|
Two days. |
|
| Format: |
|
Classroom instruction and hands on workshops. |
|
| Schedule: |
|
- Day 1: Basic Theory
- SQL Introduction
- SPUFI or command center (CLP)
- Lab 1
- SQL Basics
- Lab 2
- SQL Basics (continued)
- Lab 3
- Day 2: SQL Table Joins
- Lab 4
- SQL Subselect
- Lab 5
- DML and Objects
- Lab 6
|
|
