View Printable Version

Advanced SQL Coding and Performance

Session Number: 1133
Track: Educational Seminars
Session Type: Podium Presentation
Primary Presenter: Daniel Luksetich [DB2 Consultant - DanL Database Consulting]
Room(s)/
Time(s):

Camelback => Mon, May 12, 2014 (08:30 AM - 05:00 PM)

Session Code: 1277
Speaker Bio: Dan Luksetich is a data scientist and senior DB2 DBA consultant. He works as a DBA, application architect, presenter, author, and teacher. Dan has been in the information technology business for over 28 years, and has worked with DB2 for over 23 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, i Series, Windows, and Linux environments.
Audience experience level: Intermediate, Advanced
Presentation Category: Application Design
Presentation Platform: Cross Platform
Audiences this presentation will apply to: Application Developers, Database Administrators, Systems Programmers
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), Database Performance (DB2 for z/OS), New Release (DB2 for LUW), New Release (DB2 for z/OS), SQL and XML Features, SQL and XML Performance, User Experiences
Objective 1: To understand newer and more advanced SQL features
Objective 2: To understand the implications of using various SQL features from a performance perspective
Objective 3: To get an introduction of predictive performance analysis and EXPLAIN
Objective 4: To get an introduction to performance monitoring on all DB2 platforms
Objective 5: Using advanced SQL coding techniques to solve complex application problems and reduce the quentity of SQL statements issued by a transaction

Abstract:  This seminar address advanced SQL syntax and coding techniques with query performance in focus. 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 subqueries, joins, anti-joins, table expressions, CASE expressions, UDFs, table functions, SQL recursive processing, relational division, OLAP expressions, PureXML, and many other features of the DB2 family. There are many examples taken from real systems. An emphasis is made on the proper use of each technique for performance.

For questions or concerns about your event registration, please contact support@idug.org