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.

SQL 102: Slightly More Advanced SQL Workshop


Date and Time 
November 18, 2019
1:30pm to 3:30pm
Branner Library Teaching Corner, Mitchell Earth Sciences Building
Event Sponsor 
Stanford University Libraries

Time and Date: Monday 18 November 2019 / 1:30PM - 3:30PM
Location: Branner Library Teaching Corner, Mitchell Earth Sciences Building
Admission: Free. Open to Current Stanford Affiliates only. Registration is required. Space is limited, with a waitlist when all slots are full. Logging into Google using your Stanford credentials (you may need to sign out of your personal account), sign up here:
Audience: Faculty / Staff / Students
Event Sponsor: Stanford University Libraries
Contact: Zac Painter,
More Information and Description: If you know the basics of writing a SQL query (they always start with SELECT!), but you're having trouble figuring out how to get exactly what you need, then this workshop may just have the tips and tricks you need to up your SQL game. This hands-on, interactive workshop will review the basics of SQL as the basis for introducing some of the more nuanced topics of writing better queries.
Instructor: Dr. Amy Hodge, Stanford Libraries
Prerequisite: Amy's Getting Started with SQL course or some previous experience with writing SQL queries.
 After attending this workshop you will be able to:
    Import individual files to create a database    Limit query results, do simple calculations, and identify unique values    Simplify queries with IN and AS    Understand how order of execution impacts your queries    Understand how to document your queries so that you and others can understand what they do and how they work    Run SQL queries from the command line
 You should bring a laptop to the workshop. Please install DB Browser for SQLite ( before you come.