Главная
Study mode:
on
1
Introduction
2
Live Code
3
String
4
Last Name
5
Full Name
6
Multiple Arguments
7
How many people earn salary within certain ranges
8
Between is inclusive
9
Case
10
Grouping
11
Count
12
Dimensions Metrics
13
Multiple Tables
14
Group by
15
Run
16
Error
17
Alias
Description:
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only! Grab it 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.

Advanced SQL Techniques for Data Science

Data Science Festival
Add to list