BUSM 2010 - Introduction to Data Management for Business

Assistant Dean: Brooke Miller, M.B.A.

3 Credit(s)
Students are introduced to database management and database tools from a business application perspective. Students will learn the important role that databases play in organizations for strategic decision-making and business intelligence. This introductory course will include the fundamentals of relational database design and provide students with an understanding of the key concepts of Structured Query Language (SQL). Students will create SQL statements for data storage, data collection, data computation, and data analysis and reporting.

2 Lab Hour(s)

2 Lecture Hour(s);

College Wide Outcomes

College-Wide Learning Outcomes	Assessments - - How it is met & When it is met
Communication – Written
Communication – Speech
Intercultural Knowledge and Competence
Critical Thinking
Information Literacy
Quantitative Literacy

Student Learning Outcomes for Course

Outcomes	Assessments – How it is met & When it is met
1. Explain the importance of data, databases, and database management in relationship to business operations.	Quiz, report, midterm Week 2,8
2. Describe database design concepts and the difference of between non-relational and relational databases.	Quiz, lab assignment, midterm Week 4,8
3. Demonstrate the process of database development and administration using SQL.	Quiz, lab assignment, midterm Week 4,8
4. Process data by Sorting, filtering, grouping, and retrieving data.	Lab assignment, final project Week 7,16
5. Use calculated fields and functions.	Lab assignment, final project Week 8,16
6. Create and use Table Joins.	Lab assignment, final project Week 10,16
7. Design and apply SQL queries to be used to create and manipulate data from within a database.	Lab assignment, final project Week 12,14,16
8. Identify the major issues regarding database management systems.	Report Week 15