Data Management Fundamentals

9 units · Undergraduate

Intermittent: 9 units Students completing this course will develop a solid conceptual understanding of modern approaches to corporate data management, as well as developing hands-on skills with a variety of commonly used data management and analysis tools. More specifically, by the end of the course students should be able to do the following: o Write SQL queries to retrieve data from a relational database o Setup, connect to, and retrieve data from, database servers in the cloud via Amazon Web Services (AWS) o Use data wrangling tools such as Tableau Data Prep to profile, clean, and transform datasets o Improve the quality of a given dataset through data transformation, cleaning, and wrangling techniques o Explore, analyze, and visualize data with Tableau or a similar data visualization toolset o Present the results of your data exploration and analysis to others in a concise and compelling way. Prerequisites: 15-112 or 70-110 or 15-110 or 15-104