Difference between revisions of "DDL General Election"
Line 7: | Line 7: | ||
*deleting the flat table | *deleting the flat table | ||
*running queries against the new data structure | *running queries against the new data structure | ||
− | *[[2015 UK General Election using mysql]]: Import data on into mysql from CSV [[2015 UK General Election using mssql]] | + | *[[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 Normalising Data]]: Create normalised tables | ||
*[[2015 UK General Election Running Queries]] | *[[2015 UK General Election Running Queries]] |
Latest revision as of 11:22, 16 June 2017
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