Loading Events

« All Events

  • This event has passed.

Workshop – Introduction to SQL for Querying Databases

April 23 @ 10:00 am - 12:00 pm

 

ftd

Register now!

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.

Join in person or via Zoom broadcast.

 

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? Links to recordings of prior workshops are available at DataLab’s training archive.

Details

Date:
April 23
Time:
10:00 am - 12:00 pm
Event Tags:
, , , , , ,

Resources

Recording - Part 1 of 2
Recording - Part 2 of 2



Organizer

DataLab: Data Science and Informatics (DSI)
Website:
https://datalab.ucdavis.edu

Venue

Shields Library, room 360