JOIN "My Session" ON Modern = 'SQL'

SQL is often regarded as "old" or "boring," yet modern relational databases offer a rich set of features that make queries more expressive, readable, and powerful than ever. In this session, we’ll explore what modern SQL looks like and how to use it effectively to solve real-world problems elegantly.

We’ll start with Common Table Expressions (CTEs) and LATERAL joins for clean, maintainable query structure, then dive into advanced window functions for analytics - moving averages, percentiles, and sophisticated framing options. Next, we’ll cover multi-dimensional aggregation with ROLLUP, CUBE, and GROUPING SETS, as well as string aggregation using LISTAGG. Additionally, we'll look at using temporal tables and JSON, which allow for semi-structured queries and historical "time travel" queries. Finally, we’ll look at emerging features like vector operations for similarity searches, showcasing the direction SQL is headed in the era of intelligent data processing.

Attendees will leave with practical techniques, ready-to-use patterns, and a fresh perspective on SQL as a modern, expressive, and indispensable tool for data-driven applications.