Data Science Educational Resources
StrataScratch is a data science educational platform with over 1,000+ real interview questions from your favorite companies.
SQL Articles, Tutorials & Interview Questions
How to Use STRING_AGG to Solve SQL Questions in Data Science Interviews
STRING_AGG is a rather rarely used SQL aggregation function but it sometimes comes useful when solving data science interview tasks. An example of this is the recent and very tasty interview question from Amazon that deals with some cookbook titles.
Nathan Rosidi -
Assignment Solutions: Basic SQL 1
Take a look at the solutions and explanations to the Assignment: Basic SQL 1.Nathan Rosidi -
SQL Aggregate Functions - Interview Question by the City of San Francisco
Learn the crucial SQL aggregate function concepts by solving this interview question.Nathan Rosidi -
Lyft Data Scientist Interview Question Walkthrough
A three step solution to an SQL question asked during an interview at the ride-hailing company.
Irakli Tchigladze -
Airbnb Data Scientist Interview Questions
This article will teach you how to solve one of the hard Airbnb data scientist interview questions.Nathan Rosidi -
Google SQL Interview Questions
Learn how to better formulate your approach to all Google SQL interview questions.Irakli Tchigladze -
Find the Retention Rates – Salesforce SQL Interview Question
Retention rates are one of the key business metrics. We’ll show you how to calculate them by explaining in detail how to solve the Salesforce data science interview question.Nathan Rosidi -
String and Array Functions in SQL for Data Science
Commonly used string and array functions in SQL Data Science Interviews.
Vivek Sankaran -
Concepts and Questions to Prep for Your Data Analyst Job Interview
The demand for Data Analysts is on the rise – market analysis shows that up to 85% of companies have adopted data analysis technologies.Nathan Rosidi -
Spotify Data Science Interview Question Walkthrough
Earning the rank of number 10 in Fortune’s Future 50 in 2020, Spotify offers a diverse array of job options for the ambitious data scientist.Nathan Rosidi -
Google Data Scientist Interview Questions
A simple solution to a Google Data Scientist interview question requiring aggregation and window functions.Nathan Rosidi -
Apple Data Scientist Interview Questions
Practice data scientist interview questions to land your dream job at Apple.Nathan Rosidi -