SQL 102: Slightly More Advanced SQL Workshop
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: https://docs.google.com/forms/d/e/1FAIpQLSeC-CQrPyn3qQZnR5n06oe8-0soCGVj3Ffx_jO2mRj7_JnCUQ/viewform?usp=sf_link
Audience: Faculty / Staff / Students
Event Sponsor: Stanford University Libraries
Contact: Zac Painter, firstname.lastname@example.org
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 (http://sqlitebrowser.org/) before you come.