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.





Meeting Details

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.


Tentative Meeting Agenda

Meeting Agenda 

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 
a bit.

Registration

To pre-register please use our online registration form at:
meeting registration form
or
email registration@sirdug.org 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).

Registration Note
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.


Directions to IBM facility:


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 Biography

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.

Title: Advanced SQL

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.


SIRDUG Home Page

Last Update: October 14, 2011

Copyright 2011 SIRDUG Inc. All rights reserved.