November 10th SIRDUG Educational Seminar Featuring Dan Luksetich
SIRDUG Meeting November 10th, 2011
SIRDUG is very pleased to announce that Dan Luksetich will be the instructor for
an Advanced SQL Educational Seminar on November 10th. Dan is an exceptional speaker
and trainer. Those that got to see him when he last presented at a SIRDUG meeting
were very complimentary of his session.
WHEN? Thursday, November 10, 2011
WHERE? IBM Office (10330 David Taylor Drive, Charlotte, NC)
See directions below
COST? $225 cash or check, in advance or at the door.
We do not accept credit cards. We are working on a way to accept
Paypal and credit cards, so stay tuned for upcoming announcements.
Featured Speaker - Dan Luksetich
8:00 - 9:00 - Registration - Coffee, Danish, and Networking
9:00 - 9:10 - Announcements
9:10 - 10:20 - Dan Luksetich - Advanced SQL
10:20 - 10:40 - Break
10:40 - 11:50 - Dan Luksetich - Advanced SQL
11:50 - 12:50 - Lunch
1:00 - 2:10 - Dan Luksetich - Advanced SQL
2:10 - 2:40 - Break
2:40 - 3:50 - Dan Luksetich - Advanced SQL
3:30 - 3:45 - SIRDUG business , Adjourn
We are still working on the exact agenda, so what you see may change
To pre-register please use our online registration form at:
meeting registration form
email email@example.com and give us your name and company. If
you are not already on our distribution list and wish to be, include
your email address and phone number.
If you do not wish to continue receiving these occasional notices, please indicate that in
your registration email.
Pre-registration must be completed by Midnight, Friday, November 4th. We need to provide
a list of attendees to IBM security, so we need everyone to pre-register.
Please feel free to invite others from your company (just make sure
they pre-register as well). If you know others in your company who
are interested in attending future SIRDUG events, please encourage
them to become members of our distribution list (we just need their
names, email addresses and phone numbers).
SIRDUG will be calling or emailing a confirmation for each person who
pre-registers by the deadline. If you have pre-registered and have not
received a confirmation by the day after the deadline, please notify
us as your registration may not have been received.
If you have not pre-registered by the deadline, you may pre-register
after the deadline or register at the door, but the availability of
presentation handouts and lunch can not be guaranteed and
confirmations will not be sent.
The meeting is in the IBM facility Near the Macaroni Grill off WT Harris Blvd
North bound on I-77 (from the Rock Hill direction): Turn right onto I-85
North and follow next directions.
On I-85 (coming from either direction): Take exit 45B onto Harris Blvd.
West. Turn Right at 2nd stop light onto David Taylor Drive. Go to 10330 David Taylor Drive.
South bound on I-77 (from the Statesville direction) Turn left onto
Harris Blvd. East (exit 18) Go approximately 6.3 miles to the 10th
stop light (counting the one at top of I-77 ramp) Turn Left onto David Taylor Drive. Go to 10330 David Taylor Drive.
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
SQL has evolved into a complex programming language that is extremely feature rich. Many developments
have created quite a number of choices for adding complexity into an application via SQL. Classic
applications, service-oriented applications, web applications, data warehouses, messaging systems,
and high volume transaction based systems can all benefit from new features built into recent
releases of DB2. This presentation will address many of the more complex aspects of SQL coding.
Examples of complex SQL in different formulations are shown to demonstrate those that they perform
efficiently versus those that perform in a less efficient manner. Presented here are the more
advanced examples of subqueries, joins, table expressions, CASE expressions, UDFs, table functions,
SQL recursive processing, relational division, OLAP specification, SQL/XML, and many other features
of the DB2 family. There are many examples taken from real systems, and an emphasis is made on the
proper use of each technique for performance.
Here is a sample of the topics that will be presented during Dan's session.
In addition, comparisons of coding techniques will be made in an effort to help the student understand which technique is appropriate in various circumstances when performance is the main concern. Insight will be given into the functionality of the DB2 optimizer and query transformation.
- Sub Queries: Non-Correlated, Correlated, Row Expressions
- Table expressions: Non-Correlated, Correlated, Common Table Expressions
- GROUP BY & HAVING
- Joins: Inner Joins, Outer Joins, Scalar Fullselect, Joins and Table Expressions
- Relational Division
- UNION everywhere
- Advanced use of CASE Expressions, Multiple Levels of Summary with CASE
- EXCEPT, INTERSECT
- OLAP Functionality: Grouping Sets, Cube, and Rollup
- User-Defined Functions: Scalar and Table, Internal and External
- XLM/SQL: Moving XML documents into and out of DB2
- Multi-Row functionality
SIRDUG Home Page
Last Update: October 14, 2011
Copyright © 2011 SIRDUG Inc. All rights reserved.