Database Concepts for Analytics – BUSI 341

CG • Section 8WK • 07/01/2018 to 12/31/2199 • Modified 07/28/2020

Course Description

This course will explore the fundamentals of relational databases as they relate to business analytics, including normalization, data modeling, and Structured Query Language to extract meaning from data for decision making. The topics of data quality and integrity will be considered, as well as the impact of big data on analytics and the traditional relational database model.

Prerequisite

BUSI 333

Rationale

It is important for analysts to be able to query and manipulate data in a database. This course will teach fundamental SQL skills that will enable the student to create, query, and manipulate data using DDL and DML statements.

Measurable Learning Outcomes

Upon completion of this course, the student will be able to:

A. Transform raw data into a normalized data model. Program Learning Outcome 2, Introduced

B. Use Data Definition Language (DDL) and Data Manipulation Language (DML) to create and modify a database. Program Learning Outcome 2, Introduced

C. Generate effective queries using SQL. Program Learning Outcome 2, Reinforced

  • Create different queries and apply them to case studies
  • Range of complexity

D. Discuss the application of query results in a business context for decision making. Program Learning Outcome 3, Emphasized

E. Discuss the relevance of course material in the context of a biblical worldview. Program Learning Outcome 1, Emphasized

Course Assignment

Textbook readings and lecture presentations

After reading the Course Syllabus and Student Expectations, the student will complete the related checklist found in Module/Week 1.

 

Discussion Board Forum

Discussion boards are collaborative learning experiences. Therefore, the student is required to create a thread in response to the provided prompt for each forum. Each thread must be at least 250 words and demonstrate course-related knowledge. In addition to the thread, the student is required to reply to the thread of at least 2 classmates. Each reply must be at least 150 words.

Database Setup

The student will submit a screenshot showing that a local Oracle database has been installed as well as SQL Developer.

Hands on exercises were the student can practice the SQL topic(s) that were taught in that module. Students will complete a series of questions/scenarios and write and execute the appropriate SQL statement.

Each week the student will take a 20-Question open book quiz on the assigned reading. The quizzes will consist of multiple choice and true/false questions and have a 1-hour time limit. 

Public Dataset Project

The student will find a publicly available dataset and demonstrate how to create a proper table and insert records into the table. 

Final Project

The student will analyze a dataset of aviation crashes using the SQL skills that are taught in this course. The student will then create a professional presentation showing their findings.