Anonymous user
Community Data Science Workshops (Fall 2014)/Day 2 SQL project: Difference between revisions
Community Data Science Workshops (Fall 2014)/Day 2 SQL project (view source)
Revision as of 22:05, 15 March 2015
, 9 years agono edit summary
imported>Jtmorgan (swap logo) |
imported>Mako No edit summary |
||
(6 intermediate revisions by one other user not shown) | |||
Line 1:
{{CDSW Moved}}
[[File:Database-mysql.png|right|260px]]
__NOTOC__
== Building a Dataset using
In this project, we will explore a few ways to gather data from Wikimedia
=== Goals ===
* Learn how to use
* Get set up to run
* Practice running
* 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 a Wikimedia account already, <font size="+1">[https://en.wikipedia.org/wiki/Special:UserLogin >>click here to create an account <<]</font>.
If for some reason you are unable to create your account via the link above, try creating it via one of the links below. No matter which link you use, your account will allow you to log in to Quarry as well as any of the 100s of [https://meta.wikimedia.org/wiki/Wikimedia_projects Wikimedia project].
;Alternate account creation links
* [https://meta.wikimedia.org/wiki/Special:UserLogin meta.wikimedia.org]
* [https://commons.wikimedia.org/wiki/Special:UserLogin commons.wikimedia.org]
* [https://www.mediawiki.org/wiki/Special:UserLogin mediawiki.org]
* [https://en.wikisource.org/wiki/Special:UserLogin en.wikisource.org]
* [https://en.wiktionary.org/wiki/Special:UserLogin wiktionary.org]
* [https://en.wikivoyage.org/wiki/Special:UserLogin wikivoyage.org]
=== Practice ===
If you would like to practice SQL on your own, you can do so in the tutorial section of [http://sqlzoo.net/wiki/Main_Page SQLZoo].
=== Notes ===
* For this session, you will not need to use Python or type commands on the command line.
==== Queries and other notes ====
* https://etherpad.wikimedia.org/p/CDSW_fall_2014_SQL_session_1
|