Event box

Introduction to SQL for Querying Databases

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 is required. There are 61 in-person seats available. There are 84 online seats available.

Event Organizer

Profile photo of UC Davis DataLab
UC Davis DataLab

More events like this...