Date and Time:
October 5, 2016
9a-12p
Location:
Branner Library Teaching Corner, Mitchell Earth Sciences Building 2nd floor
Admission:
Admission is free. Registration is required. Please see the link under "More Information" to register.
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).