Hands-on Intro to SQL (Structured Query Language)
Admission is free.
Registration is required. Please see the link under "More Information" to register.
This workshop is only for individuals affiliated with Stanford University (SUNet ID required).
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
- building complex queries
- order of execution
- joining, and
- lots more helpful tips
Computers with the necessary software will be supplied for you, or you can bring your own. If you wish to use your own machine, please install DB Browser for SQLite before you come to the workshop.