Introduction to SQL for Querying Databases (Part 1 of 2) 2024-04-23

From Glenda Gaines May 08, 2024

39 plays comments You unliked the media.

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.

The copyright on this video is owned by the Regents of the University of California and is licensed for reuse under the Creative Commons Attribution 4.0 International (CC BY 4.0) License.