Difference between revisions of "DDL General Election"

From SQLZOO
Jump to: navigation, search
(Created page with "Importing and processing data with MySQL *2015 UK General Election using mysql: Import data on into mysql from CSV *2015 UK General Election Normalising Data: Create n...")
 
Line 1: Line 1:
 
Importing and processing data with MySQL
 
Importing and processing data with MySQL
 +
 +
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
 
*[[2015 UK General Election using mysql]]: Import data on into mysql from CSV
 
*[[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]]

Revision as of 19:33, 19 October 2016

Importing and processing data with MySQL

In this tutorial you will be: