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 mmtobias@ucdavis.edu Pamela Reynolds plreynolds@ucdavis.edu
Location -
DataLab: Data Science and Informatics classroom (Shields Library room 360). Directions: http://datalab.ucdavis.edu/dsl-location/
DESCRIPTION
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.
PREREQUISITES & TARGET LEARNERS
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.