Difference between revisions of "Submissions:2016/Tutorial on basic SQL (Quarry) for Wikimedians"

From WikiConference North America
Jump to: navigation, search
(Interested attendees: +me)
(Fixed the link to Quarry)
 
(2 intermediate revisions by 2 users not shown)
Line 25: Line 25:
  
 
;Abstract:  
 
;Abstract:  
:Have you ever wished to know something about the articles in Wikipedia, but there was no "Special" page that gave you quite the right information? Quarry ( https://tools.wmflabs.org/quarry/ ) is a powerful tool that allows anyone to get interesting information from the wiki. However, it requires knowing SQL in order to use. This session is meant to be a basic tutorial on SQL, and in particular SQL in the context of the MediaWiki database schema. No previous programming or database knowledge will be assumed. By the end of the tutorial participants should be able to understand the types of information they can obtain from the Quarry tool, and be able make basic ad-hoc queries to obtain information they want.
+
:Have you ever wished to know something about the articles in Wikipedia, but there was no "Special" page that gave you quite the right information? Quarry ( https://quarry.wmflabs.org/ ) is a powerful tool that allows anyone to get interesting information from the wiki. However, it requires knowing SQL in order to use. This session is meant to be a basic tutorial on SQL, and in particular SQL in the context of the MediaWiki database schema. No previous programming or database knowledge will be assumed. By the end of the tutorial participants should be able to understand the types of information they can obtain from the Quarry tool, and be able make basic ad-hoc queries to obtain information they want.
  
 
The tutorial is primarily aimed at Wikimedians, but maintainers of non-Wikimedia wikis who want to query data. Participants are encouraged (but certainly not required) to bring their laptop if possible so they can follow along.
 
The tutorial is primarily aimed at Wikimedians, but maintainers of non-Wikimedia wikis who want to query data. Participants are encouraged (but certainly not required) to bring their laptop if possible so they can follow along.
Line 31: Line 31:
  
 
;Length of presentation:
 
;Length of presentation:
:~60 minutes (I can adapt length shorter or longer to whatever slot is given to me)
+
:<s>~60 minutes (I can adapt length shorter or longer to whatever slot is given to me)</s> 20 minutes
  
 
;Special schedule requests:
 
;Special schedule requests:
Line 48: Line 48:
  
 
# Interested in learning about the opportunities SQL queries present with Wikipedia (as well as learning some SQL itself). '''~''[[User:SuperHamster|<span style="color:#07517C">Super</span>]]''[[User:SuperHamster|<span style="color:#6FA23B">Hamster</span>]]''' <small>[[User talk:SuperHamster|Talk]] [[Special:Contribs/SuperHamster|Contribs]]</small> 09:31, 31 August 2016 (EDT)
 
# Interested in learning about the opportunities SQL queries present with Wikipedia (as well as learning some SQL itself). '''~''[[User:SuperHamster|<span style="color:#07517C">Super</span>]]''[[User:SuperHamster|<span style="color:#6FA23B">Hamster</span>]]''' <small>[[User talk:SuperHamster|Talk]] [[Special:Contribs/SuperHamster|Contribs]]</small> 09:31, 31 August 2016 (EDT)
 +
# This is a great topic.  [[User:Sj|Sj]] ([[User talk:Sj|talk]]) 20:19, 6 October 2016 (EDT)
  
 
[[Category:Submissions/2016]] [[Category:Submissions in 2016, technology]]
 
[[Category:Submissions/2016]] [[Category:Submissions in 2016, technology]]

Latest revision as of 21:02, 8 October 2016

Title
Tutorial on basic SQL ("Quarry") for Wiki[mp]edians
Theme
Tech
Academic Peer Review option
no
Type of submission
Workshop (Specifically meant as a tutorial)
Author
Brian Wolff
E-mail address
bawolff __AT__ gmail __DOT__ com
Username
Bawolff
Affiliation
MediaWiki Developer
Abstract
Have you ever wished to know something about the articles in Wikipedia, but there was no "Special" page that gave you quite the right information? Quarry ( https://quarry.wmflabs.org/ ) is a powerful tool that allows anyone to get interesting information from the wiki. However, it requires knowing SQL in order to use. This session is meant to be a basic tutorial on SQL, and in particular SQL in the context of the MediaWiki database schema. No previous programming or database knowledge will be assumed. By the end of the tutorial participants should be able to understand the types of information they can obtain from the Quarry tool, and be able make basic ad-hoc queries to obtain information they want.

The tutorial is primarily aimed at Wikimedians, but maintainers of non-Wikimedia wikis who want to query data. Participants are encouraged (but certainly not required) to bring their laptop if possible so they can follow along.

Length of presentation
~60 minutes (I can adapt length shorter or longer to whatever slot is given to me) 20 minutes
Special schedule requests
n/a
Preferred room size
Not sure. Lets say 30.
Will you attend WikiConference North America if your submission is not accepted?
yes

Interested attendees

If you are interested in attending this session, please sign with your username below. This will help reviewers to decide which sessions are of high interest. Sign with four tildes. (~~~~).

  1. Interested in learning about the opportunities SQL queries present with Wikipedia (as well as learning some SQL itself). ~SuperHamster Talk Contribs 09:31, 31 August 2016 (EDT)
  2. This is a great topic. Sj (talk) 20:19, 6 October 2016 (EDT)