Course# 2: Application Development for IBM DB2 for z/OS

Major topic covered:

Part I: Programming APIs for DB2 for z/OS

        Chapter 1: Overview of DB2 application

        Chapter 2: Embedded SQL in host languages

        Chapter 3: Programming API for C - ODBC and CLI

        Chapter 4: Programming API for Java - JDBC and SQLJ

        Chapter 5: pureQuery

        Chapter 6: Preparation of DB2 applications

        Chapter 7: Execution of DB2 applications

        Chapter 8: Triggers, User-Defined Functions, and Stored Procedures

        Chapter 9: SOA and DB2 Web Services

        Chapter 10: Data Web Services Programming

        Chapter 11: Appendix: Hands-On Lab (Development Environment)

Part II: Exploitation of SQL Functions

        Chapter 12: Physical database design

        Chapter 13: Security and authorization

        Chapter 14: Advanced query design

        Chapter 15: Application Performance Monitoring

        Chapter 16: Application Performance Tuning

        Chapter 17: Spatial database

        Chapter 18: XML database

Outcome: Upon Completion of this course, you will be able to:

• Describe the key features in DB2 for z/OS to support Application Development.
• Understand application environments in which DB2 for z/OS is specifically suitable.
• Design, develop and migrate application programs that access DB2 for z/OS.
• Prepare applications for execution on DB2 for z/OS.
• Understand the physical design of a database in DB2 for z/OS.
• Understand and troubleshoot some application performance issues.
• Leverage traditional and new application development technologies: C, C++, Java, XML, SOA, Web Services, WebSphere.
• Create database applications designed with security and authorization throughout.
• Incorporate advanced query capabilities provided in DB2 for z/OS.