Intro to SQL for Querying Databases Workshop

Nov. 7, 2019, 2 p.m. - Nov. 7, 2019, 4 p.m.

Organizer -

DataLab: Data Science and Informatics

Contact -

Michele Tobias Pamela Reynolds

Location -

DataLab: Data Science and Informatics classroom (Shields Library room 360). Directions:

This workshop provides an overview of the utility and base SQL commands for working with data in a relational database. We’ll focus on querying data to get to know a database and answer questions, and combining data from separate tables.

After this workshop learners should be able to:
– Perform common SQL commands including sorting, filtering, calculating values, aggregating, combining data, and basic data cleaning (i.e. replace missing values).
– Combine commands to construct a query to answer a specific question.
– Identify the benefits of working with SQL.
– Access additional resources for using SQL in other software like R.

No prior programming experience is necessary. Bring your laptop with SQLite installed and running. Please ensure that you can connect to the campus wireless (“Eduroam” preferred). This is a condensed workshop targeted for UC Davis graduate student, postdoc and faculty researchers. Undergraduates are encouraged to sign up for the 2-part “Getting to Know SQL” workshop on November 14-15.

DSI Affiliates receive priority registration. You will receive a confirmation once you are accepted into the workshop.

Registration is closed for this event