Menu
Log in
Wisconsin Db2 Users Group
Log in

October 2019 WDUG Special Training Session

  • 10/08/2019
  • 8:00 AM - 4:30 PM
  • Aurora Medical Center, 36500 Aurora Dr, Summit, WI 53066
  • 63

Registration


Registration is closed

WDUG and Themis Present:

A special Db2 training session

Db2 Update for Developers

The Wisconsin Db2 Users group has teamed up with Themis to provide a day-long discounted training session for Developers and DBAs alike.  

Our presenter will be David Simpson, a veteran WDUG speaker and Themis educator.  The topics to be covered for the day will include:

I. SQL Update for Db2 11 and 12

  • Piecewise DELETE
  • SQL Pagination
  • Temporary Table Enhancements
II. SQL Procedure Language Update
  • “Native” Stored Procedures
  • User Defined Functions
  • Triggers (Db2 12)
III. SQL Optimization
  • Explain
  • Explain in IBM Data Studio
  • SQL Coding tips

David Simpson is currently a Senior Technical Advisor at Themis Inc. He teaches courses on SQL, Application Programming, Database Administration as well as optimization, performance and tuning. He also installs and maintains the database systems used for training at Themis. Since 1993 David has worked as a developer and DBA in support of very large transactional and business intelligence systems. David is a certified DB2 DBA on both z/OS and LUW. David was voted Best User Speaker and Best Overall Speaker at IDUG North America 2006. He was also voted Best User Speaker at IDUG Europe 2006 and is a member of the IDUG Speakers Hall of Fame.  David is an IBM Gold Consultant and an IBM Champion.

Powered by Wild Apricot Membership Software