Hands-on Intro to SQL (Structured Query Language)
Date and Time
October 24, 2018
9:00am to 12:00pm
Location
Branner Earth Sciences Library Teaching Corner, Mitchell Earth Sciences Building 2nd floor
Audience
Faculty/Staff
Students
Event Sponsor
Data Management Services, Stanford Libraries, Stanford University 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.
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.