Advanced SQL Techniques for Data Science

Dive into advanced SQL concepts in this 1-hour 12-minute conference talk by Slawomir Tulski, Data Engineering Manager at Facebook, presented at the Data Science Festival Summer School 2021. Build upon basic SQL knowledge to explore complex WHERE conditions, single row functions, group functions, and joins. Gain insights into core Data Engineering concepts such as metrics and dimensions. Follow along with live coding examples that demonstrate practical applications of advanced SQL techniques, including string manipulation, salary range queries, CASE statements, and working with multiple tables. Learn how to effectively use grouping, counting, and aliasing in your queries. This session assumes familiarity with basic SQL concepts and is ideal for those looking to enhance their data manipulation and analysis skills.

Introduction
Live Code
String
Last Name
Full Name
Multiple Arguments
How many people earn salary within certain ranges
Between is inclusive
Case
Grouping
Count
Dimensions Metrics
Multiple Tables
Group by
Run
Error
Alias