BUSM 2010 - Introduction to Data Manag

Academic Discipline: Business Administration (01255)

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. Undergraduate

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
Explain the importance of data, databases, and database management in relationship to business operations	Quiz, report, midterm Beginning of term Middle of term
Describe database design concepts and the difference between non-relational and relational databases	Quiz, assignment, midterm Beginning of term Middle of term
Demonstrate the process of database development and administration using SQL	Quiz, lab assignment, midterm Beginning of term Middle of term
Process data by Sorting, filtering, grouping, and retrieving data	Lab assignment, final project Second half of term End of term
Use calculated fields and functions	Lab assignment, final project Second half of term End of term
Create and use Table Joins	Lab assignment, final project Second half of term End of term
Design and apply SQL queries to be used to create and manipulate data from within a database	Lab assignment, final project Second half of term End of term
Identify the major issues regarding database management systems	Report End of term

BUSM 2010 - Introduction to Data Manag

Outcomes

Assessments – How it is met

& When it is met