COMMON Fall Conference & Expo | October 15-17 | Pittsburgh, PA | www.common.org/fall
Back To Schedule
Tuesday, October 16 • 2:45pm - 5:00pm
26AD POWER PICK: Advanced SQL Data Manipulation Language (Double Session)

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Part 1 SQL is a very powerful language for accessing and manipulating data. This session will explore some of the more advanced SQL concepts. The session begins with a discussion about thinking “set at a time” vs. row at a time, then continues with Set operations, Sub queries, Common Table Expressions, Derived Tables and more. Part 2 This session will focus on more of the Set at a time concepts of SQL DML. Topics covered include: Grouping Sets, Cube, Rollup, Recursive Common Table Expressions, and OLAP Extensions provided by Db2 i 7.3

Learning Objectives:
1. Improved understanding of SQL language elements related to manipulation of data.
2. Change the thought process of manipulating data from processing rows, to processing sets..

This is Session ID:180112

avatar for Rob Bestgen

Rob Bestgen

Rob Bestgen is an IBM DB2 for i architect and consultant. In his 29 year temporary assignment at IBM, Rob has held a variety of roles including: database developer, database architect, Business Architect, and chief architect of the DB2 for i SQL Query Engine (SQE), to name a few... Read More →

Tuesday October 16, 2018 2:45pm - 5:00pm EDT
Grand Ballroom 5