Hands-on Intro to SQL (Structured Query Language)

Date
Wed October 3rd 2018, 9:00am - 12:00pm
Event Sponsor
Data Management Services, Stanford Libraries, Stanford University Libraries
Location
Branner Earth Sciences Library Teaching Corner, Mitchell Earth Sciences Building 2nd floor
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.

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.

Contact Phone Number