This hands-on course provides a thorough discussion of advanced SQL query coding for DB2 for OS/390 for UDB. Significant emphasis is placed on practical tips and techniques as well as performance considerations.
- Course Outline
This course is intended for anyone who needs to code complex SQL in interactive or programmed DB2 for OS/390 UDB environments. Students gain hands-on experience through several computer-based exercises.
ObjectiveKnow how to use the built-in DB2 scalar and column functions.Learn when and how to code simple and correlated subselects.Understand the writing of efficient implicit and explicit inner Joins between two or more tables.Know when and how to code left, right, and full outer joins.Learn how to correctly code meaningful Cartesian Products and how to avoid invalid ones.Understand how to code intersection and difference operations using the EXISTS predicate.Know when and how to efficiently code UNION statements.Learn to write complex SQL statements involving combined subselects, unions, inner joins, outer joins, and/or nested table expressions.Understand performance issues regarding complex SQL statements.
- Prerequisites & Certificates
A basic working knowledge of DB2 SQL is assumed. The student is expected to have a solid understanding of how to code basic SQL SELECT statements. Ideally, the student should have completed either Information Balance's "DB2 Application Programming Workshop" or "��oeIntroduction to QMF".
- Cancellation Policy
Up to the 11th business day prior to class, a registration may be cancelled or rescheduled without charge. Thereafter the full course fee will be invoiced whether it's a cancelled or rescheduled. In which case a reschedule credit, valid for 1 year, will be issued. Substitutions may be made at any time prior to the start of the course.
- Map & Reviews
[ View Provider's Profile ]
This course has not yet been rated by one of our members.
If you have taken a course through this vendor please log into your account and leave feedback for this vendor. You will be helping ensure our members get directed to the best training facilities.
This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.
This page has been viewed 242 times.