Hands-on Intro to SQL (Structured Query Language)

RSS

Date and Time 
October 5, 2016
9:00am to 12:00pm
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).