Hands-on Intro to SQL (Structured Query Language)
Date and Time
October 5, 2016
9:00am to 12:00pm
Location
Branner Library Teaching Corner, Mitchell Earth Sciences Building 2nd floor
Audience
Faculty/Staff
Students
Event Sponsor
Stanford University Libraries, Data Management Services, Stanford Libraries
Contact
amyhodge@stanford.edu
650-556-5194
Do you need to ask complicated questions of your data? Do you need something sophisticated and a spreadsheet just won't do? Then a relational database may be for you.
Join us for a hands-on, interactive introduction to SQL, the language for querying structured data.
This workshop will include the following topics:
- importing content into a SQLite database (DB)
- info on relational DBs, DB management systems, and DB design
- basic queries, including unique values and calculations
- filtering
- building complex queries
- sorting
- nulls
- order of execution
- aggregating
- joining, and
- set operators.
Computers with all the necessary software will be supplied for you.
This workshop is only for individuals affiliated with Stanford University (SUNet ID required).