Instructor: Jing Gong. Class Time: M/W/F 2:00-2:50 pm




Jing Gong, PhD


Location: 201C Speakman Hall

Office hours:  Monday and Wednesday, 3:00 – 4:00 pm  or by appointment


Nathan Pham (

Class Location and Time

Section 002 (CRN: 19562)

·       Location: ALTER 232

·       Time: 2:00 – 2:50 PM, Monday/Wednesday/Friday


Course description

The course provides a foundation for designing database systems and analyzing business data to enhance firm competitiveness. Concepts introduced in this course aim to develop an understanding of the different types of business data, various analytical approaches, and application of these approaches to solve business problems. Students will have hands-on experience with current, cutting-edge tools such as MySQL and R.

 Course Objectives

  • Articulate the key components of an organizations’ information infrastructure.
  • Create data models based on business rules.
  • Create a transactional database from a model using SQL.
  • Create an analytical data store by extracting relevant data from a transactional database.
  • Perform extract, transform, load (ETL) functions such as data sourcing, pre-processing, and cleansing.
  • Discover trends in analytical data stores using the data mining techniques of clustering, segmentation, association, and decision trees.
  • Present data visually for clear communication to a managerial audience.

 Required Textbook

 There is no required textbook for this course.

 Course Websites

We will use both the community site and blackboard site. The detailed usage of the two sites is as follows.

Website Usage
Community Site:

The community site has an up-to-date copy of the syllabus, schedule, class announcements, slide decks, in-class exercises, assignment instructions, as well as other course documents. While I will try to make announcements both in class and on the community site, it is a good idea for you to check the web site regularly.

The Blackboard site is primarily for assignment submission and sharing videos/recordings. The grades will also be posted on Blackboard.