Sessions from June 2012 SQL for i Spotlight
With a theme of SQL and Data-Centric Programming, the SQL for i Spotlight conference featured sessions that taught you how to make your database work harder for you. Attendees learned how to transfer responsibility for data processing into DB2 for i by applying the concepts of modular programming and by leveraging the relational capabilities of DB2 for i. They also learned the latest tips for optimizing performance, improving query techniques, and delivering modern reports and business intelligence to their internal and external customers.
SQL for i Spotlight addressed all four "must-know" areas of DB2 for i:
- DB2 for i Capabilities
- SQL Programming
- Performance Monitoring & Management
- Query & Reporting
View a list of specific sessions presented at the June 2012 SQL for i Spotlight below. You may also view the June 2012 Session Grid, view June 2012 sessions by speaker or have a look at the June 2012 Session Roadmap.
Previous Hands-On Workshops
You can view all abstracts for the Hands-On Workshops, or view them individually below.
Previous Conference Sessions
You can view all abstracts for the Conference Sessions, or view them individually below.
Embedded SQL in RPG - Beyond the Basics Paul Tuohy
Embedded SQL in RPG Programs - The Basics Paul Tuohy
DB2 for i Update - 6.1 Kent Milligan
Beyond Query/400: The "New" DB2 Web Query Robert Bestgen
DW and BI Architecture, Design and Implementation Robert Bestgen
SQL Performance Basics Kent Milligan
Indexing Strategy and Advice Robert Bestgen
SQL Monitoring, Analysis and Tuning Tools Robert Bestgen
Introduction to SQL Query Optimization Robert Bestgen
DB Modernization Strategies and Methods — Objects Kent Milligan
Exploring the IBM OmniFind Text Search Server Robert Bestgen
SQL Procedures, Functions and Triggers Paul Tuohy
Database Modeling Concepts and Best Practices Robert Bestgen
DB2 for i XML Integration Kent Milligan
Take Your SQL to the Next Level Kent Milligan
DB2 for i Update - 7.1 Kent Milligan
I Didn't Know You Could Do That Using SQL Skip Marchesani