SQL Query Building in DB2
Course Title: SQL Query Building in DB2
Course#: DB03T
Duration: 2 days
Overview:
Students who complete this course will be able to code SQL statements to access DB2 objects using QMF.
Topics:
Exercises:
There are six machine exercises.
Audience:
Technical personnel who need to retrieve data from DB2 data bases.
Prerequisites:
Experience using ISPF/PDF
Course#: DB03T
Duration: 2 days
Overview:
Students who complete this course will be able to code SQL statements to access DB2 objects using QMF.
Topics:
- DB2 overview
- Relational data base concepts
- SELECT
- QMF Usage
- DB2 sample data bases
- Built-in functions
- Joined queries
- UNION
- Creating DB2 tables
- Views
- DB2 system catalog tables
- Common problems
Exercises:
There are six machine exercises.
Audience:
Technical personnel who need to retrieve data from DB2 data bases.
Prerequisites:
Experience using ISPF/PDF
Clients
