Providing Technology Training and Mentoring For Modern Technology Adoption
This course is designed to review concepts of using DB2 UDB (Universal Database). UDB object components will be presented along with communication and security aspects. Basic and advanced SQL techniques will be used. CLP commands and 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 and functions, triggers and large objects will be reviewed. Techniques for using EMBEDDED STATIC and DYNAMIC SQL in either COBOL or ‘C’ programs, will be applied in workshops. Program design issues will be considered which effect concurrency and integrity (ie. locking) and performance. Basic UDB administration functions will be reviewed and some DB2 utilities will be used.