Member-only story
Data Science Interviews: SQL
A technical guide on SQL and 10 problems to check out
Overview
When you hear “data scientist” you think of modeling, insightful analysis, machine learning, and other cool buzzwords. So, let’s not beat around the bush: databases and SQL are not the most “fun” parts of being a data scientist. And it’s probably not what you’re the most worried about for an interview. But that said, because you’re going to be working with data a lot, that means you’ll be writing many queries to retrieve it and transform it to become meaningful.
This post will provide a technical guide to SQL within data science interviews. The problems discussed are from this data science interview newsletter which features questions from top tech companies and will be involved in an upcoming book.
General Workflow
The first step of analytics for most workflows involves quick slicing and dicing with data in SQL, and hence being able to write basic queries efficiently is a very important skill. Although many may think that SQL simply involves SELECTs and JOINs, there are many other operators and details involved for powerful SQL workflows. For example, utilizing subqueries is important and allows you to manipulate subsets of data by which later operations can be performed, while…










