The Data Incubator

Businesses are drowning in data
but starving for insights
Forrester

SQL

Summary

Most data is stored in databases, and they have to be accessed through interfaces. The most common one is SQL, a declarative language that lets us tell the database which data we want and how to present it. We cover the basics of the language itself and some of the Python tools related to it.


Associated project work

Students will assemble a SQL database of 4 years worth of NYC restaurant inspection data. They will write and execute queries against this database to understand the variations in scores and violations across the city and between different types of restaurants.


This module is currently part of our Data Science Fellowship.

Prerequisites
Basic Python
Basic SQL