DDL General Election
Importing and processing data with SQL
In this tutorial you will be:
- loading csv data into a flat table in SQL.
- creating tables more suitable for holding the data
- copying the data from the flat table into the normalised structure
- deleting the flat table
- running queries against the new data structure
- 2015 UK General Election using mysql: Import data on into mysql from CSV. Also: 2015 UK General Election using mssql
- 2015 UK General Election Normalising Data: Create normalised tables
- 2015 UK General Election Running Queries