IDUG DB2 Tech Conference EMEA 2011
Clarion Congress Hotel, Prague, Czech Republic
14 - 18 November, 2011

View Printable Version

DB2 Intermediate and Advanced SQL

Session Number: 1982
Track: Full Day Seminars
Session Type: Podium Presentation
Primary Presenter: Daniel Luksetich [DanL Database Consulting]

Kepler => Fri, Nov 18, 2011 (09:00 AM - 05:00 PM)

Speaker Bio: Dan Luksetich is a senior DB2 DBA. He works as a DBA, application architect, presenter, author, and teacher. Dan has been in the information technology business for over 22 years, and has worked with DB2 for over 18 years. He has been a COBOL and BAL programmer, DB2 system programmer, DB2 DBA, and DB2 application architect. His experience includes major implementations on z/OS, AIX, and Linux environments. Dan's experience includes: * Application design and architecture * Database administration * Complex SQL * SQL tuning * DB2 performance audits * Replication * Disaster recovery * Stored procedures, UDFs, and triggers Dan works 8-16 hours a day, everyday, on some of the largest and most complex DB2 implementations in the world. He is a certified DB2 DBA and application developer, and the author of several DB2 related articles as well as co-author of the DB2 9 for z/OS Certification Guide.
Audience experience level: Select a Value
Presentation Category: Application Design
Presentation Platform: Cross Platform
Audiences this presentation will apply to: Application Developers, Database Administrators, Systems Programmers, New Users
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), Database Performance (DB2 for z/OS), SQL and XML Features, SQL and XML Performance, User Experiences
Objective 1: Teach people advanced and new DB2 SQL functionality
Objective 2: Learn how to use SQL as a programming language
Objective 3: Learn how to code the same statement multiple different ways
Objective 4: learn how to code statements properly for performance
Objective 5: Learn how and when to take advantage of advanced SQL features

Abstract:  Everyone can code complex SQL statements using an effective methodology. The first thing this class does is to teach the students how to build SQL queries a step at a time. Taught from a programmers perspective, each step of the construction process is addressed as if it were a program itself. Techniques for unit testing, and assembling the components of a complex statement are addressed. DB2 brings focus to the fact that SQL syntax is easy but writing good SQL is not, even with query rewrite. Examples are shown of how SQL can solve very difficult business problems, and why this type of SQL never gets written. Examples of complex SQL in different formulations are shown to demonstrate those that they perform efficiently versus those that perform in the worst possible manner. DB2 brought a whole new world to relational with advancements in SQL processing and object relational support. Presented here are the more advanced examples of joins, table expressions, CASE expressions, UDFs, active data triggers, auditing, table functions, SQL recursive processing, and many other features of the DB2 family. There are many examples taken from real systems, where the SQL coding requires pages of code. Most of these features are available across the family. Where there are differences, both solutions will be presented.

For questions or concerns about your event registration, please contact