Hands-on Intro to SQL (Structured Query Language)
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
- building complex queries
- order of execution
- 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).