Introduction To MySQL With R

Key Info
Description - a brief synopsis, abstract or summary of what the learning resource is about: 

MySQL is a relational database used to store and query information. This lesson will use the R language to provide a tutorial and examples to:
-Set up and connect to a table in MySQL.
-Store records to the table.
-Query the table.
In this tutorial you will make a database of newspaper stories that contain words from a search of a newspaper archive. The program will store the title, date published and URL of each story in a database. They’ll use another program to query the database and look for historically significant patterns. Sample data will be provided from the Welsh Newspapers Online newspaper archive. They are working toward having a list of stories they can query for information. At the end of the lesson, they will run a query to generate a graph of the number of newspaper stories in the database to see if there is a pattern that is significant.

To do this lesson you will need a computer where you have permission to install software such as R and RStudio, if you are not running that already. In addition to programming in R, they will be installing some components of a database system called MySQL which works on Windows, Mac and Linux.

Some knowledge of installing software as well as organizing data into fields is helpful for this lesson which is of medium difficulty.

Authoring Person(s) Name: 
Jeff Blackadar
Authoring Organization(s) Name: 
The Programming Historian
License - link to legal statement specifying the copyright status of the learning resource: 
Creative Commons Attribution 4.0 International - CC BY 4.0
Access Cost: 
No fee
Citation - format of the preferred citation for the learning resource: 
Jeff Blackadar, "Introduction to MySQL with R," The Programming Historian 7 (2018),
Primary language(s) in which the learning resource was originally published or made available: 
More info about
Keywords - short phrases describing what the learning resource is about: 
Data archiving
Data skills education
Data storage
Data usage
Database design
Database management
Database models
Digital humanities
Humanities data
R software
Subject Discipline - subject domain(s) toward which the learning resource is targeted: 
Arts and Humanities
Arts and Humanities: Digital Humanities
Arts and Humanities: History
Arts and Humanities: History of Art, Architecture, and Archaeology
Arts and Humanities: Other Languages, Societies, and Cultures
Published / Broadcast: 
Thursday, May 3, 2018
ID - identifier that provides the means to locate the learning resource or its citation: 
Type - namespace prefix for the citable locator, if any: 
Publisher - organization credited with publishing or broadcasting the learning resource: 
The Programming Historian
Media Type - designation of the form in which the content of the learning resource is represented, e.g., moving image: 
Interactive Resource - requires a user to take action or make a request in order for the content to be understood, executed or experienced.
Educational Info
Purpose - primary educational reason for which the learning resource was created: 
Instruction - detailed information about aspects or processes related to data management or data skills.
Learning Resource Type - category of the learning resource from the point of view of a professional educator: 
Learning Activity - guided or unguided activity engaged in by a learner to acquire skills, concepts, or knowledge that may or may not be defined by a lesson. Examples: data exercises, data recipes.
Target Audience - intended audience for which the learning resource was created: 
Data manager
Data policymaker
Data professional
Early-career research scientist
Graduate student
Mid-career research scientist
Repository manager
Research faculty
Research scientist
Software engineer
Technology expert group
Intended time to complete - approximate amount of time the average student will take to complete the learning resource: 
More than 1 hour (but less than 1 day)