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...")
 
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
Importing and processing data with MySQL
+
Importing and processing data with SQL
*[[2015 UK General Election using mysql]]: Import data on into mysql from CSV
+
 
 +
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 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: