This course introduces fundamental concepts in organizational information management, focusing on database design and usage. Students will learn data modeling, relational databases, SQL, big data tools, and analytics. The course is organized into four parts: Web-based information systems, data modeling and design, analytics, and data management practices.
Athena Title
Data Management and Analytics
Equivalent Courses
Not open to students with credit in MIST 4610E
Prerequisite
MIST 2090 or MIST 2090E or MIST 2090H
Semester Course Offered
Offered every year.
Grading System
A - F (Traditional)
Student learning Outcomes
Students will design and implement relational databases using valid data models and optimize complex SQL queries to retrieve, aggregate, and manipulate data across multiple related tables, including the use of subqueries, joins, and conditional logic. Ensure systems meet standard practices associated with data governance, data quality and integrity.
Students will communicate analytical findings effectively through the design of compelling visualizations and interactive applications using data analytics tools such as Tableau.
Students will collaborate effectively in team-based projects by planning, developing, and delivering data-driven solutions, while incorporating peer feedback and demonstrating professional responsibility.
Topical Outline
The organizational perspective on data management
Data modeling and SQL
Relational DBMS
Organizational intelligence technologies
Data analysis
Data structure and storage
Data processing architectures
Data integrity and data administration
Institutional Competencies Learning Outcomes
Analytical Thinking
The ability to reason, interpret, analyze, and solve problems from a wide array of authentic contexts.
