Analyzing "Chicago Public Schools - Progress Report Cards" data set with SQL and Python
Goals:
- Understand the dataset for Chicago Public School level performance
- Retrieve metadata about tables and columns and query data from mixed case columns
- Solve example problems to practice your SQL skills including using built-in database functions
The city of Chicago released a dataset showing all school level performance data used to create School Report Cards for the 2011-2012 school year. The dataset is available from the Chicago Data Portal: https://data.cityofchicago.org/Education/Chicago-Public-Schools-Progress-Report-Cards-2011-/9xs2-f89t
@author: Mariana R. Barros