Objectives: Upon successful completion of this course you will be able to:
- Code advanced SQL (Structured Query Language) queries, including complex inner and outer joins, subqueries, unions, and use the new Version 7 SQL enhancements.
- Use application coding techniques such as new Version 7 CURSOR management and concurrency management.
- Use techniques to code efficient SQL, including EXPLAINs.
- Describe advanced DB2 capabilities including triggers, stored procedures, user-defined functions, additional built-in functions, etc.
- Use Version 7 enhancements for SQL and DB2 application programming.