Providing Technology Training and Mentoring For Modern Technology Adoption
This course is designed to present some application design topics that can improve performance, using DB2 for UNIX and WINDOWS. SQL statements will be used to create objects for application design and development. Design issues of referential Integrity, table check constraints, generated columns, user defined data types, functions, stored procedures and triggers will be reviewed. Advanced techniques for using SQL will be applied in workshops. Design issues will be considered which effect concurrency, integrity and performance. Basic UDB administration functions will be reviewed and some DB2 utilities will be used.