View Printable Version

EDS6 - Advanced and Complex SQL

Session Number: 3348
Track: Educational Seminar - II
Session Type: Educational Seminar
Primary Presenter: Sheryl Larsen [BMC Software]
Room(s)/
Time(s):

Frio - Ed. Sems. => Wed, May 25, 2016 (08:00 AM - 10:15 AM)

Speaker Bio: Sheryl M. Larsen is an internationally recognized researcher, consultant, lecturer, specializing in DB2, and now works for BMC as a Sr. DB2 Product Specialist. Previously she worked for IBM, Sheryl M. Larsen, Inc., and Platinum Technology. She is known for her extensive expertise in SQL and has performed detailed DB2 Performance Health Checks for many fortune 500 clients. Sheryl has over 25 years’ experience in DB2, has published many articles, white papers and co-authored a book, DB2 Answers, Osborne-McGraw-Hill, 1999. Currently she is the President of the Midwest DB2 User Group - www.mwdug.org, and a member of the Northern Illinois University Computer Science Alumni Council.
Audience experience level: Beginner, Intermediate, Advanced
Presentation Category: Application Design, Data Warehousing and Business Intelligence, Implementing New DB2 Releases and Features
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, Systems Programmers, New Users, IT Managers
Technical areas this presentation will apply to: New Release (DB2 for z/OS), SQL and XML Performance
If Tools and Utilities was selected which products: Understand where the DB2 for z/OS SQL portfolio fits with other RDBMS portfolios.
Objective 1: Learn valuable SQL coding techniques

Objective 2: Learn when to use what SQL and when not use what SQL
Objective 3: Special emphasis will be on new features added since DB2 9.
Objective 4: Gaze into future features if available to discuss

Abstract:  The class half day seminar is all about increasing the SQL coding skills; specifically in knowing when to use which SQL feature. Special emphasis will be on complex subqueries, table expressions, temporary tables, recursion , moving SUM/AVG, and any new mentionable features.

For questions or concerns about your event registration, please contact support@idug.org