Basic UDB administration functions will be reviewed and some DB2 utilities will be used.
This hands-on workshop presents several advanced topics for application developers. SQL statements will be used to create objects for application design and development.
Design issues of referential Integrity, table check constraints, user defined data types, functions, triggers and large objects will be reviewed.
Advanced techniques for using SQL in programs and stored procedures will be applied in workshops.
Program design issues will be considered which effect concurrency, integrity and performance.
LEARNING OBJECTIVES
Upon successful completion of this course the student will be able to:
- Create relational objects for application development.
- Use advanced SQL queries to access and manipulate data on DB2 tables.
- Review and use different methods of improving performance.
- Discuss how DB2 locking strategy improvie concurrency and maintain integrity
- Discuss and code Stored Procedures
- Use IMPORT, EXPORT and LOAD utilities to manipulate data.
- Understand the basic security features of DB2.
Audience
Application programmers and designers.
Prerequisites
Six months of relevant Operating Systems experience.
Six months of experience with relational database systems and SQL.
Six months experience programming with DB2 UDB.
Course duration
3 days
Course outline
|
DAY 1
|
| |
- Course Introduction
- SQL queries
- Advanced SQL
|
|
DAY 2 |
| |
- Performance for SQL and Applications
- Data Access and EXPLAIN
- Creating Objects
- TRIGGERS, UDT and UDF
|
|
DAY 3 |
| |
- DB2 Stored Procedures
- DB2 Program preparation
- DB2 Utilities
- IMPORT/EXPORT/LOAD utilities
|
