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

Course Materials

How to use the slide decks?

  • Check the schedule in the syllabus for the dates we are covering the material in each slide deck.
  • Review the slide deck prior to class.
  • Take notes during class.

Here they are:

No.  Module Slides In-Class Activities (ICA)
Additional Files
1 Course Introduction;

Things You Can Do with Data

0. Course Introduction

1. Things You Can Do With Data

   
2 Information Architecture of an Organization 2. Information Architecture of an Organization    
3 Relational Data Modeling 3. Relational Data Modeling ICA #1 – Identifying Entities (due by Friday 9/8, 11:59 pm)

ICA #1 – Identifying Entities [KEY]

ICA #2 – ER Modeling (due by Wednesday 9/13, 11:59 pm)

ICA #2 – ER Modeling [key].pdf

ICA #3 – Converting ERDs to Schemas (due by Wednesday 9/20, 11:59 pm)

 

(right click and save as…)

ICA #2 Inventory and Parts.erdplus

ICA #2 Housing Authority.erdplus

ICA #3 Schema Template.pptx

4 SQL 1: Getting Information Out of a Database Before start, make sure you’ve followed the guide for setting up a connection in MySQL Workbench 

4.1 SQL 1 – Out – Basics

4.2 SQL 1 – Out – Advanced

4 Supplement – MySQL and Workbench (review on your own)

   SQL Quick Reference 1
5 SQL 2: Putting Information Into a Database      
6 Principles of Data Visualization      
7 Extract, Transform, Load (ETL)      
8 Dimensional Data Modeling      
9 Advanced Data Analytics and R      
10 Classification Using Decision Trees      
11 Clustering      
12 Association Rules      
13 Advanced topic