Print the page
Add to a Calendar using iCal
Share page on Facebook
This link opens in a new window
Add to Google Calendar
This link opens in a new window
Share page on Twitter
This link opens in a new window
Introduction to SQL for Querying Databases In-Person / Online
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:
- Identify the benefits of working with SQL;
- 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; and
- Access additional resources for using SQL in other software like R.
Prerequisites
Learners should attend the "Introduction to databases and data storage technologies" workshop. No prior programming experience is necessary. Bring your laptop to the workshop with SQLite (https://sqlitestudio.pl/) installed and running.
Can't make it to this training? Check out upcoming workshop schedule. Links to recordings of prior workshops are available at DataLab's training archive.
- Date:
- Tuesday, April 23, 2024
- Time:
- 10:00am - 12:00pm
- Time Zone:
- Pacific Time - US & Canada (change)
- Location:
- DataLab Classroom (Shields Library room 360) (Map )
- Campus:
- Davis Campus
- Categories:
- DataLab Workshop
Registration has closed.
UC Davis DataLab