Complex Datasets with SQL (Data Scientist Mock Interview)
Ace your SQL interviews with our complete course: https://bit.ly/3PnLhzg
An Adobe data scientist pulls customer and transaction data at an e-commerce company, covering window functions, aggregations, and indexing.
0:00 - Intro
0:42 - Query reports users, transactions, order amounts
3:31 - Monthbymonth reporting with distinct counts
4:40 - Monthly reporting query pulling roles, transactions, order amount
5:00 - Date part function SQL for 2020 year summary
5:37 - Output Monthly name, customers, orders, order amount
5:57 - Perfect query improvement tips
8:18 - Query output for users orders
9:10 - Logic for capturing users orders
11:08 - Window functions offer more scalability, flexibility
12…
An Adobe data scientist pulls customer and transaction data at an e-commerce company, covering window functions, aggregations, and indexing.
0:00 - Intro
0:42 - Query reports users, transactions, order amounts
3:31 - Monthbymonth reporting with distinct counts
4:40 - Monthly reporting query pulling roles, transactions, order amount
5:00 - Date part function SQL for 2020 year summary
5:37 - Output Monthly name, customers, orders, order amount
5:57 - Perfect query improvement tips
8:18 - Query output for users orders
9:10 - Logic for capturing users orders
11:08 - Window functions offer more scalability, flexibility
12…
Prêt pour la prochaine étape?
Mettez ces conseils en pratique — des milliers de nouveaux emplois sont ajoutés chaque jour.
Parcourir les emplois Recevoir des alertes emploiEn savoir plus sur ce sujet
Cette vidéo est présentée avec le lecteur de YouTube et appartient à son créateur, Aced (formerly Exponent).