Loading…
Attending this event?
THE BEST IBM i & POWER SYSTEMS EDUCATION.When you come to POWERUp, you’ll be able to customize your experience. Choose from 300 sessions, covering over 20 areas of IT, when you plan your schedule. Visit the largest Expo of its kind and meet the experts behind the solutions. Attend social events to meet renowned speakers and peers alike. This conference is structured to give you the pure education and professional connections needed to best enhance your career. Are you ready to POWERUp?

Exhibitor Hall: https://www.expocad.com/host/fx/common/s24/exfx.html
Back To Schedule
Wednesday, May 22 • 1:30pm - 2:30pm
310: Elevate your SQL Capabilities with Lateral Joins, Pivots, and Window Functions

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

Tweet Share
EVALUATION
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.

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
avatar for Mike Zaringhalam

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 →

Wednesday May 22, 2024 1:30pm - 2:30pm CDT
Meeting Room 203A 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Advanced
  • Audience Anyone looking to further their SQL skillset would benefit from this

Attendees (33)