Loading…
Back To Schedule
Tuesday, June 9 • 11:00 - 12:15
SID Lecture 2.2 I Didn't Know You Could Do That Using SQL

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

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. Some of the topics covered include:
 - Functions of Note
 - Grouping
     - Grouping-Sets
     - Super-Groups - ROLLUP and CUBE
 - CASE
     - Using CASE
     - Pivot
 - Subselect
     - Scalar
     - Quantified
     - Correlated
     - With INSERT, UPDATE and CREATE TABLE
     - With a Derived Table
 - Common Table Expressions
 - Union
 - Identity Columns
 - Row Change Timestamp
- A Word About Views

This session is based on the SQL functions available in the latest release of the OS and assumes you have a basic understanding of relational database concepts and SQL.

Speakers
avatar for Paul Tuohy

Paul Tuohy

System i Developer
Paul Tuohy, IBM Champion and author of Re-engineering RPG Legacy Applications and The Programmer's Guide to iSeries Navigator, is a prominent consultant/trainer/educators for application modernisation and development technologies on the IBM Midrange. He currently holds positions as... Read More →


Tuesday June 9, 2020 11:00 - 12:15 BST
Room 6