DB2 Advanced SQL Workshop

Course Code: DBIASQ
Duration: 2 days
Audience: Application Developers, Application Programmers, System Administrators and Capacity Planners.
Prerequisites: Completion of our course DB2 SQL Essentials or equivalent knowledge.
Summary: This presentation focuses on advanced SQL, data access primitives and index options with a view to reducing SQL query elapsed times.
Objectives: Upon completion of this presentation, the delegate should understand how to use good SQL coding practices in the context of query alternatives such as:
  • Joins vs. subqueries
  • Unions vs. case expressions
  • Nested table expressions vs. views
  • Index options
  • And the like
View full outline in PDF formatDetailed Outline

Course Schedule

Request a date for this course

Book Course

Course Outlines

Detailed course outlines are available in PDF format. Download Adobe's Acrobat Reader free from: www.adobe.com
Get Acrobat Reader

Training Topics

GENERAL

print  |  top of page