COMMON Fall Conference & Expo | October 15-17 | Pittsburgh, PA | www.common.org/fall
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 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 a Business Architect for IBM i, responsible for development strategy for systems management and external interfaces. He is also chief architect of the DB2 SQL Query Engine for DB2 i. Rob is also a member of the DB2 for i Center of Excellence team in lab services and... Read More →

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