Hands-on Intro to SQL (Structured Query Language)
Date
Wed October 3rd 2018, 9:00am - 12:00pm
Event Sponsor
Data Management Services, Stanford Libraries, Stanford University Libraries
Location
Branner Earth Sciences Library Teaching Corner, Mitchell Earth Sciences Building 2nd floor
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.
Instructor: Dr. Amy Hodge, Stanford Libraries
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
- order of execution
- aggregating
- joining, and
- lots more helpful tips
You should bring a laptop to the workshop. Please install DB Browser for SQLite before you come.
Contact Email
amyhodge [at] stanford.edu
Contact Phone Number
Event Link