The use of SQL takes iSeries application development to a new level of productivity. Also crucial is data integrity, and new Db2 features make it easier to build this into applications. Performance can be maintained if proper design techniques are followed. This course teaches the latest improvements in Db2 and SQL so companies can build optimal database applications. Students are taught proven design techniques that ensure high performance. At the end of the course, important on-line and batch issues are summarized.
Students should have at least three months’ Db2 development experience. For those needing the basics, an appendix can be taught at the beginning of the first day.
3 Days/Lecture & Lab
This course is designed for Application developers and programmers.
- Review of Common SQL Constructs
- Advanced SQL Constructs
- Object Management
- Stored Procedures and Triggers
- Index Design
- Processing Implications
- Evaluating SQL Performance
- Concurrency Control
- Online Design Considerations
- Batch Processing