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!
Multi-Dimensional Grouping (Without HAVING)
Connect and enjoy our open bar.
Interactive session over dinner.
Data-Centric – Moving Business Logic into the Database
Wrapping up with gratitude
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.
Understand how moving business rules into the database can reduce application complexity, improve consistency, and enhance overall system efficiency.
Explore best practices for structuring queries, using indexing strategies, and leveraging stored procedures to make your SQL operations faster and more efficient.
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.