Wednesday, November 20, 2019

New iSchool GenEd - DSSP - INST123 Databases for All


INST123 Databases for All (3 credits, DSSP)

This course is an introduction to relational databases for students with no previous programming experience. This course provides a means for students of diverse backgrounds to successfully learn how to store, retrieve, and maintain data in relational databases. Students are not expected to have any computer programming experience.

Topics include a brief comparison of database systems with an emphasis on relational databases, fundamental relational database concepts, and data types. It also includes technical approaches to accessing information stored in relational databases, including problem analysis, query creation, and execution, as well as debugging techniques. 

Students will implement solutions by learning and using the Structured Query Language (SQL) and a relational database management system (RDBMS) to populate and query a series of sample databases. This is a hands-on course; students will be writing, analyzing, and testing SQL queries. The overall objective of this course is to provide a foundational understanding of relational databases, the methods through which the information housed in such databases can be efficiently accessed and maintained, and the process of working with information professionals to design and implement relational databases to meet the information needs for a wide variety of subjects.