Community Data Science Workshops (Fall 2014)/Day 2 SQL project

From CommunityData
< Community Data Science Workshops (Fall 2014)
Revision as of 22:52, 14 November 2014 by Jtmorgan (talk | contribs) (rmv stackexchange stuff, since it's in MSSQL :()
Database-mysql.png


Building a Dataset using MySQL

In this project, we will explore a few ways to gather data from Wikimedia using MySQL and the Quarry web application. Once we've done that, we will download the results of our queries in CSV format which can be used to ask and answer questions and visualize data in the final session.

Goals

  • Learn how to use MySQL (a Structured Query Language) to build datasets.
  • Get set up to run MySQL queries to gather data from Wikimedia projects.
  • Practice running MySQL queries on your own to get data about who is editing particular Wikipedia articles.
  • Create a few collections of Wikipedia data that you can do research with in the final section.

Prerequisite

To participate in the afternoon session, you must have an a Wikimedia account. If you do not have an account already, you can create one by following these steps.

Practice

If you would like to practice SQL on your own, you can do so in the tutorial section of SQLZoo.

Notes

For this session, you will not need to use Python or type commands on the command line.