Hands-on Intro to SQL (Structured Query Language)

RSS

Date and Time 
October 24, 2018
9:00am to 12:00pm
Location 
Branner Earth Sciences Library Teaching Corner, Mitchell Earth Sciences Building 2nd floor
Audience 
Faculty/Staff
Students
Event Sponsor 
Data Management Services, Stanford Libraries, Stanford University 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.
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.

accessibilityaccessprivsarrow-circle-rightaskus-chataskus-librarianbarsblogsclosecoffeecomputercomputersulcontactsconversationcopierelectricaloutleteventsexternal-linkfacebook-circlegroupstudyhoursindividualinterlibrarynewsnextoffcampusopenlateoutdoorpeoplepolicypreviousprinterprojectsquietreservesscannersearchstudysupportingtabletourstwitter-circleworking