The Libraries are resuming limited in-person research activities by appointment only as part of the University's Research Restart Plan.
Learn more about the Libraries' entry requirements and available services.

Hands-on Intro to SQL (Structured Query Language)


Date and Time 
October 17, 2017
1:00pm to 4:00pm
Branner Library Teaching Corner, Mitchell Earth Sciences Building 2nd floor

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).

Event Sponsor 
Stanford University Libraries, Data Management Services, Stanford Libraries

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 
  • lots more helpful tips 

Computers with all the necessary software will be supplied for you, or you can bring your own. The FIREFOX BROWSER is required for this course.
This workshop is only for individuals affiliated with Stanford University (SUNet ID required).