View Printable Version

EDS6 - Advanced SQL Coding and Performance

Session Number: 2442
Track: Ed. Sem
Session Type: Educational Seminar
Primary Presenter: Daniel Luksetich [DB2 Consultant - DanL Database Consulting]

Conestoga => Wed, May 06, 2015 (08:00 AM - 04:30 PM)

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, Data Management, Data Warehousing and Business Intelligence, Managing Performance
Presentation Platform: Cross Platform
Audiences this presentation will apply to: Application Developers, Database Administrators
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
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