Sitemap
TDS Archive

An archive of data science, data analytics, data engineering, machine learning, and artificial intelligence writing from the former Towards Data Science Medium publication.

Member-only story

Data Science Interviews: SQL

A technical guide on SQL and 10 problems to check out

--

Press enter or click to view image in full size
Image by Alexandra Acea on Unsplash

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…

--

--

Kevin Huo
Kevin Huo

Written by Kevin Huo

Data scientist — finance and tech, previously @ FB

TDS Archive
TDS Archive

Published in TDS Archive

An archive of data science, data analytics, data engineering, machine learning, and artificial intelligence writing from the former Towards Data Science Medium publication.