Advanced SQL: Top Tips for Dealing with Real-World Data

Discover advanced SQL techniques for handling real-world data challenges in this 39-minute talk by Lydia Monnington, Head of Analytics at Stuart. Elevate your SQL skills to deliver results in complex scenarios, focusing on three key areas: joining messy data, leveraging window functions, and working with arrays. Learn how to avoid common pitfalls when joining inconsistent datasets, explore the power of window functions for creating sessions, and understand why data engineers use arrays and how to efficiently access data stored within them. Aimed at intermediate to advanced SQL practitioners familiar with joins and aggregation, this presentation offers practical insights to enhance your data manipulation capabilities. Originally presented at the 2023 Oktoberfest Data Science Festival in London, this talk is part of the Data Science Festival series, a community-driven platform for data professionals to exchange cutting-edge ideas and tackle real-world problems.