This course will introduce students to the database language SQL, using the open-source relational database management system MySQL. The class 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 relationships between tables; and manipulate numbers, strings, and dates.
Students will obtain a solid knowledge of the language, and 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