View Printable Version

E02 - Having fun with complex SQL

Session Number: 59
Track: DB2 for Developers
Session Type: Podium Presentation
Primary Presenter: Suresh Sane [DBA Manager - Advance Auto Parts]

Bonaire 1&2 => Tue, Apr 30, 2013 (02:00 PM - 03:00 PM)

Speaker Bio: Suresh Sane is an IDUG Hall of Fame speaker with three Best User Speaker awards and numerous top 10 finishes. He has lectured worldwide and co-authored 4 IBM Redbooks (Dynamic SQL, Stored Procedures, Data Integrity and DB2 Packages). He was recognized as an IBM Information Champion in 2009 - 2012.

He served on the NA Conference Planning Committee 2004-2008  (Conference Chair for IDUG NA 2008) and on the IDUG Board of Directors  2009-2011.
Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Application Design
Presentation Platform: Cross Platform
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, New Users
Technical areas this presentation will apply to: SQL and XML Features, SQL and XML Performance
Objective 1: Master relational division
Objective 2: Harness the power of recursive SQL
Objective 3: Understand some quirks with triggers
Objective 4: Understand multiple ways to achieve same result
Objective 5: Make application development more productive

Abstract:  There is a certain amount of aura surrounding complex SQL. This presentation will de-mystify some of it and allow you to master some complex and innovative SQL techniques. You will leave the session with a deeper understanding of SQL features such as relational division, recursive SQL, triggers and nulls. You will also learn techniques to make your application development more productive. The session is cross-platform in nature, but the solutions presented were developed on DB2 for z/OS.

For questions or concerns about your event registration, please contact