LISUG Logo
  • Home

  • Event Showcase

  • Membership

  • Board Members

  • About Us

LISUG Logo

Navigation

  • Home
  • Featured Event
  • Membership
  • Board Members
  • About Us

About LISUG

  • Newsrooms
  • Volunteer
  • Support
  • Donate

Join our newsletter

Get the latest news and updates from LISUG straight to your inbox.

Follow us:


© 2025 LISUG. All Rights Reserved.

Advanced SQL: Multi-Dimensional Grouping & Data-Centric Logic

Smarter Grouping, Stronger Business Logic

Dive deep into SQL mastery with techniques that go beyond the basics. From advanced grouping strategies to moving your business logic into the database, this event will empower you to optimize performance, simplify processes, and work smarter. Don't miss your chance to level up your SQL skills and drive business success with cutting-edge strategies!

Event Date

March 18, 2025

Time

5:00 PM - 9:00 PM

Venue

Westbury Manor

1100 Jericho Turnpike

Westbury

NY - 11590

Event Completed!

0

DAYS

0

HOURS

0

MINUTES

0

SECONDS

Event Highlights

image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image
image

About Event

Join us for a powerful session where we explore advanced SQL techniques that enhance data processing, improve performance, and streamline business logic. Whether you're optimizing queries or embedding logic directly into your database, this event will equip you with the skills to make your SQL work smarter, not harder.

Pre-Session: Multi-Dimensional Grouping (Without HAVING)
Grouping data is a core SQL function, but what if you could achieve complex multi-dimensional grouping without relying on the HAVING clause? In this session, we’ll explore alternative techniques that offer greater flexibility, better performance, and a deeper understanding of how SQL handles aggregations.

Main Session: Data-Centric – Moving Business Logic into the Database
As datasets grow, managing business logic at the application level can become inefficient. This session will show you how to shift business rules into the database, reducing application complexity, ensuring data consistency, and unlocking the full power of SQL. Learn how stored procedures, triggers, and constraints can help you build smarter, more efficient databases.

Note: Unlike our usual schedule, this event will take place on Tuesday, so be sure to mark your calendar and join us for this insightful session!

Schedule

Pre-Session

Multi-Dimensional Grouping (Without HAVING)

5:00 PM

Networking & Cocktail Hour

Connect and enjoy our open bar.

6:00 PM

Dinner & Q&A

Interactive session over dinner.

7:00 PM

Main Session

Data-Centric – Moving Business Logic into the Database

8:00 PM

Session Ends

Wrapping up with gratitude

9:00 PM

What Will You Learn?

Advanced Multi-Dimensional Grouping

Discover techniques to group and analyze data across multiple dimensions without relying on the HAVING clause. Learn how to optimize queries for better performance and flexibility.

Embedding Business Logic in the Database

Understand how moving business rules into the database can reduce application complexity, improve consistency, and enhance overall system efficiency.

Optimizing SQL for Performance

Explore best practices for structuring queries, using indexing strategies, and leveraging stored procedures to make your SQL operations faster and more efficient.

Keynote Speaker

Birgitta Hauser Image

Birgitta Hauser

Database and Software Architect (IBM i) at Birgitta Hauser

Birgitta Hauser is a Database and Software Architect specializing in IBM i systems, with expertise in RPG programming, Db2 for i, and database modernization. As an independent consultant, she offers workshops, training, and consulting on IBM i. A frequent speaker at global IBM i conferences, Birgitta has authored IBM Redbooks and numerous articles on RPG and SQL. Recognized as an IBM Champion since 2021, she continues to contribute to the IBM i community through education and innovation.