BAN 702 - Data Transformation and SQL

(3 units)

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.

Prerequisite(s): Admission to the MSBA program; introductory statistics and/or MSBA Bootcamp.

Grading Basis: Graded
Units of Lecture: 3
Offered: Every Fall, Spring, and Summer

Student Learning Outcomes
Upon completion of this course, students will be able to:
1. categorize the different types of data used in organizations and identify how best to store that data.
2. describe the governance and ethical issues that must be addressed when data is collected, organized, stored, and accessed to help support human decision making.
3. design a small relational database using an entity-relationship diagram (ERD) that is stable and explain why the design is stable.
4. implement a database using Microsoft’s SQL Server DBMS with structured query language (SQL) to create, update, and access data in a database.
5. 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.
6. 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.

Click here for course scheduling information. | Check course textbook information