Utilise SQL to retrieve data from datasets

Project description

Utilise SQL to retrieve data from census, crime, and school demographic datasets for the city of Chicago. Use advanced SQL statements to query data from multiple tables, to obscure sensitive data from users, and to control how information is updated in tables.

Datasets

1. Socioeconomic indicators in Chicago

This dataset contains a selection of six socioeconomic indicators of public health significance and a “hardship index,” for each Chicago community area, for the years 2008 – 2012.

2. Chicago public schools

This dataset shows all school level performance data used to create CPS School Report Cards for the 2011-2012 school year.

3. Chicago crime data

This dataset reflects reported incidents of crime (with the exception of murders where data exists for each victim) that occurred in the City of Chicago from 2001 to present, minus the most recent seven days.