Name: Elevate your SQL Capabilities with Lateral Joins, Pivots, and Window Functions
Start: 2026-04-28T09:15:00-0500
End: 2026-04-28T10:15:00-0500

Unlock the Power of IBM i at POWERUp 2026!

Join us in New Orleans, Louisiana for POWERUp 2026, the premier conference for IBM i professionals. Whether you’re an experienced expert or just starting your IBM i journey, this event offers unparalleled education, hands-on workshops, and valuable networking opportunities. Stay ahead of the curve with insights from industry leaders, explore the latest innovations, and connect with a thriving community that shares your passion for IBM i. Don’t miss this opportunity to expand your knowledge, grow your skills, and power up your career!

Elevate your SQL Capabilities with Lateral Joins, Pivots, and Window Functions

Tuesday April 28, 2026 9:15am - 10:15am CDT

Studio 3-4

Evaluation Survey

Take your SQL skills to the next level with this session on Lateral joins, Window functions, and Pivoting. Discover how LATERAL joins simplify complex queries, learn new insights with Window Functions, and master the art of pivoting data for dynamic reporting. Whether you're an SQL pro or beginner, join us to unlock the full potential of these powerful tools and techniques (and get free code).

Learning Objectives:

1. Learn how and when to use the Lateral keyword (along with correlation and cross joins). 2. Learn all the available Window Functions and how/when to use them. 3. Learn what pivoting is and how to setup an SQL procedure to do it dynamically.

Speakers

Mike Zaringhalam

Developer, PC Richard & Son

Have you ever wanted to meet someone who started Hawaiian Shirt Fridays at their work place?
If the answer is 'Yes!', then feel free to reach out with any questions you have regarding Hawaiian shirts... Or IBM i related topics.
My main focuses are RDi, DB2, Modernization, and D... Read More →

Tuesday April 28, 2026 9:15am - 10:15am CDT
Studio 3-4

Database, Programmer Tools

COMMON POWERUp 2026

Mike Zaringhalam

Attendees (70)

Get help with the event

COMMON POWERUp 2026

Mike Zaringhalam

Attendees (70)

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

Get help with the event