Hands-on Intro to SQL (Structured Query Language)

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

This workshop will teach the basics of working with and querying structured data in a database environment. This workshop uses the SQLite plugin for Firefox.  The data used is a time-series for a small mammal community in southern Arizona in the southern United States. This is part of a project studying the effects of rodents and ants on the plant community that has been running for almost 40 years. The rodents are sampled on a series of 24 plots, with different experimental manipulations controlling which rodents are allowed to access which plots.

Authoring Person(s) Name: 
Amy Hodge
Authoring Organization(s) Name: 
Stanford University Libraries
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
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 access methods
Data communication
Data handling
Data management
Data stewardship
Subject Discipline - subject domain(s) toward which the learning resource is targeted: 
Physical Sciences and Mathematics: Environmental Sciences
Published / Broadcast: 
Monday, October 9, 2017
Publisher - organization credited with publishing or broadcasting the learning resource: 
Stanford University
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.
Contact Person(s): 
Amy Hodge
Contact Organization(s): 
Stanford University Libraries
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: 
Course - series of units and lessons used to teach the skills and knowledge required by its curriculum.
Target Audience - intended audience for which the learning resource was created: 
Mid-career research scientist
Early-career research scientist
Research faculty
Graduate student
Undergraduate student
Data manager
Repository manager
Data professional
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)