Slide Decks
There is no required textbook for this course. I will post the slide decks prior to class.
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.
| No. | Module | Slides |
| 0 | Introduction | 0.1. Course Introduction 0.2. Things You Can Do With Data |
| 0 | Information Architecture of an Organization | 0.3. Information Architecture of an Organization |
| 1 | Relational Data Modeling | 1.1. Relational Data Model
1.2. Converting ERDs to Schemas |
| 2 | SQL 1: Getting Information Out of a Database | Supplement – MySQL and Workbench
2.1. SQL 1 – Out – Basics 2.2. SQL 1 – Out – Advanced SQL queries for PPT 2.2: [SQL Format] [Word Format] |
| 3 | SQL 2: Putting Information Into a Database | 3. SQL 2 – In |
| 4 | Extract, Transform, Load (ETL) | 4. ETL (Extract, Transform, Load) |
| 5 | Dimensional Data Modeling | 5. Dimensional Data Modeling |
| 6 | Principles of Data Visualization | 6. Data Visualization |
| 7 | Advanced Analytics and R | Supplement – Basic Statistics
7.1. Advanced Analytics 7.2. Introduction to R and RStudio |
| 8 | Classification Using Decision Trees | 8. Decision Trees |
| 9 | Clustering | 9. Clustering |
| 10 | Association Rules | 10. Association Rules |