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