DB2 SQL Application Programming
Duration: 5 Days
Suitable for the BCS Mainframe Technology professional Exams for level 2 Senior Developer.
Topics Covered In This Course
Introduction to DB2 and the Relational Model
The SQL Language
Introduction to SPUFI and/or QMF for z/OS or Control Center and/or Command Editor and/or Command Prompt for LUW
Locking and contention issues
Overview of DB2 internals
EXPLAIN/ VISUAL EXPLAIN
What You Can Expect
This course focuses on using efficient SQL on all platforms and using appropriate host languages in the business applications environment. Through a combination of lectures and a progressive series of workshops, the audience will gain a solid grounding in SQL and how it is used interactively and embedded in host language programs. Many other DB2 issues are also covered, including how to address performance concerns, exploring the system catalog, batch and interactive issues, and DB2 product enhancements in versions 8 and 9.
Who Should Take This Course
Application programmers and designers seeking more in-depth knowledge about IBM's DB2 database (versions 8 and 9) under z/OS and LUW platforms.
The participant should have some knowledge of the relevant application language (eg. COBOL, Java, C++ etc...). Please inform Verhoef of the language and platform in use when booking the course.
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]