|
Oct 14, 2024
|
|
|
|
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
|
Add to Portfolio (opens a new window)
|
|