AMS 521, Data Management

This course teaches how to manage databases, which are important tools for organizations. Students will learn about the different parts of a database system, how data is stored, and how to get information from databases. The course will also cover how to design and build large databases, including creating logical structures, handling multiple processes at the same time, distributing data, and managing databases.

There are no prerequisites for this course, and we will start learning R and SQL from the very beginning.  However, having some prior experience would be helpful.

3 credits; ABCF grading

Course materials will be supplied by the instructor via Brightspace

Topics:

Students will also explore topics like data warehousing (storing large amounts of data), cleaning data, and data mining (finding useful information from data). The course includes hands-on practice with R and SQL, where students will clean, organize, and combine raw data to prepare it for analysis. This practical experience will help students develop key skills in getting data ready for use in projects.

Learning Outcomes:

By the end of this course, students will understand
--the basics of managing databases, which are important tools for organizations;
--receive practical experience in designing and building databases, cleaning up raw data, and preparing it for analysis using R and SQL.