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.
