Overview
Description
This course introduces how data is stored, retrieved and transformed into information to support organizational objectives and decision making. This is a practical, hands-on course designed to help students develop both knowledge and skills related to the management and use of data.
Requirements
Prerequisites
- Admission to the MSBA program
- introductory statistics and/or MSBA Bootcamp
Original catalog text
Prerequisites
Admission to the MSBA program; introductory statistics and/or MSBA Bootcamp.
Units
Lecture3
Catalog Details
Offering
Offered: Every Fall, Spring, and Summer
Terms
fall, spring, summer
Restrictions
Admission to the MSBA program
Attributes
Standard
Learning Outcomes
- categorize the different types of data used in organizations and identify how best to store that data.
- describe the governance and ethical issues that must be addressed when data is collected, organized, stored, and accessed to help support human decision making.
- design a small relational database using an entity-relationship diagram (ERD) that is stable and explain why the design is stable.
- implement a database using Microsoft’s SQL Server DBMS with structured query language (SQL) to create, update, and access data in a database.
- import data from a variety of sources into a relational database. Use techniques to “clean” the data so that the data stored is reliable and consistent.
- create queries in SQL to produce datasets capable of being processed in other analytical software such as Excel, Tableau, SAS, Mini-tab and/or SPSS.