OpenHatch wiki

Community Data Science Workshops (Fall 2014)/Day 2 SQL project: Difference between revisions

Page Discussion

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

Revision as of 21:52, 14 November 2014

134 bytes removed ,  9 years ago
rmv stackexchange stuff, since it's in MSSQL :(
imported>Jtmorgan
(notes)
imported>Jtmorgan
(rmv stackexchange stuff, since it's in MSSQL :()
Line 5:
== Building a Dataset using MySQL ==
 
In this project, we will explore a few ways to gather data from Wikimedia and StackExchange projects using [https://en.wikipedia.org/wiki/MySQL MySQL] and the [http://quarry.wmflabs.org/ Quarry] and [http://data.stackexchange.com/ Data Explorer]web applicationsapplication. Once we've done that, we will download the results of our queries in [https://en.wikipedia.org/wiki/Comma-separated_values 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 [https://en.wikipedia.org/wiki/SQL Structured Query Language]) to build datasets.
* Get set up to run MySQL queries to gather data from Wikimedia and StackExchange projects.
* Practice running MySQL queries on your own to get data about who is editing particular Wikipedia articles and answering questions on StackOverflow.
* Create a few collections of Wikipedia data that you can do research with in the final section.
 
Anonymous user
Retrieved from "https://wiki.openhatch.org/wiki/Special:MobileDiff/15343"