Omni Banner

I Didn't Know You Could Do That Using SQL
Paul Tuohy

*Thursday* September 29th 2016

Paul Tuohy

Casey's Restaurant and Bar
415 E. North Avenue (IL-64), East of I-355
Lombard IL

5:00 Registration
5:30 Dinner
6:00 Presentation

meals | register | cancel | directions

You have started to master SQL but you have a sneaky suspicion that there might be more to it.

In this session you will learn valuable and time saving techniques with SQL that let you avoid writing code. You will learn how to use SQL Subquery or Subselect in an SQL SELECT, INSERT, UPDATE, DELETE or CREATE TABLE statement to reference multiple tables without having to do a join of the tables involved. You will see how to use CASE and UNION statements, Common Table Expressions (CTEs) and where to use Full Outer Join and Hidden Time Stamp columns.

This session requires a basic understanding of relational database concepts and SQL.

Paul Tuohy

Paul Tuohy, author of Re-engineering RPG Legacy Applications and The Programmer's Guide to iSeries Navigator, is one of the most prominent consultants and trainer/educators for application modernization and development technologies on the IBM Midrange. He currently holds positions as CEO of ComCon, a consultancy firm based in Dublin, Ireland, and founding partner of System i Developer, the consortium of top educators who produce the acclaimed RPG & DB2 Summit conference. Previously, he worked as IT Manager for Kodak Ireland Ltd. and Technical Director of Precision Software Ltd.

In addition to hosting and speaking at the RPG & DB2 Summit, Paul is an award-winning speaker at COMMON, COMMON Europe Congress and other conferences throughout the world. His articles frequently appear in System i NEWS, iSeries Experts Journal, The Four Hundred Guru, RPG Developer and other leading publications.

Dinner Options
Food and Drink are ala carte from

September Dinner Meeting Registration
Please make your reservations by Wednesday September 28th 2016.

To register, please do this ...
1) Please submit your information using the form below to express your preferences.
There is no need to pay for this meeting!
Thanks in advance!

First name:
Last name:
Address 1:
cc billing address
Address 2:

Registration Options:

Please choose options and click Submit Information. There is no need to pay for this meeting.
Dinner Meeting Registration

User Group Affiliation:
Southwest Michigan
Gateway/400 Group

To register, please do this ...
1) Please submit your information by clicking the "Submit Information" button below.
There is no need to pay for this meeting.
Thanks in advance!

Please click the button below to submit your information...

There is no need to pay for this meeting.

Please invite your friends and associates to join you at the Omni Dinner Meeting. Send them a message to tell them you'll be attending for education, networking, and so much more. For some, it might be a great reason to reconnect with a phone call. Omni appreciates everything you do to spread the word about your best value in IBM i on Power Systems education!
Dinner Meeting Cancellation Policy
Full credit will be issued for cancellations made before 9:00 am Wednesday September 28th 2016.
After 9:00 am Wednesday September 28th 2016, cancellation credit depends on meeting attendance.
All cancellations must be made by using the web cancellation feature below (the preferred method) or, if you must, by calling (630) 953-6312 and leaving the name(s) of those unable to attend.


Dinner Meeting Directions

The event will be held at Casey's Restaurant and Bar at 415 E. North Avenue (IL-64), East of I-355 in Lombard, IL

Click here for a map!

For more information
email questions to Jerome Hughes or leave a message on the OMNI line at (630) 953-6312

events | membership | by-laws | board | links | downloads | home

2021 Midwest Road, Suite 200 Oak Brook IL 60523

opinions craved!
email webmaster

© 2002-2016 The Omni User