Introduction to SQL for Querying Databases – 2022-04-11
This workshop provides an overview of the utility and base SQL commands for working with data in a relational database. It focuses on querying data to get to know a database and answer questions, and combining data from separate tables.
Prerequisites: Learners should attend the "Introduction to databases and data storage technologies" workshop. No prior programming experience is necessary. Bring your laptop with https://sqlitestudio.pl/ installed and running.
Before coming to the workshop, please download the file '2022-04-04_intro-sql.zip' from https://bit.ly/38h1T8e and unzip the file. It contains a data set and script that will be used during the workshop.
Software needed: https://sqlitestudio.pl/
Install guide for SQLiteStudio: https://ucdavisdatalab.github.io/install_guides/sql-and-database-tools.html#sqlitestudio
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.