SQL 102: Slightly More Advanced SQL Workshop

RSS

Date and Time 
November 18, 2019
1:30pm to 3:30pm
Location 
Branner Library Teaching Corner, Mitchell Earth Sciences Building
Audience 
Faculty/Staff
Students
Event Sponsor 
Stanford University Libraries
Contact 
zwp@stanford.edu

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, zwp@stanford.edu
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.

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