Skill Lab: SQL - Intro to Using Relational Databases to Analyze Publicly Available Data

1 unit

This course will introduce students to the database language SQL using the open-source relational database management system MySQL. The course will begin with an introduction to databases and then cover the major features of a database. Students will learn to create tables and fields, define relationship between tables, and manipulate numbers, strings, and dates. Students will obtain solid knowledge of the language, how to retrieve and manage data efficiently. By the end of the class, students will be able to download a publicly available dataset, import it into MySQL, and query to filter/extract subsets of data.