Moodle, Syllabus, Notes & Resources

 

Week #

Date

Assignment

1

January 17

Do this Pre-Course Assignment Course (after getting my "Welcome" email).

Introduction and Overview
The Relational Database Model
Setting up your computer's database environment, MySQL, and adding databases.
SQL Command Overview

2

January 24

Single Table Methods of Analyzing Data
SQL Column and Row Filtering
Sorting Results
Basic Importing Data
Installing Tableau and Connecting Tableau to MySQL

3

January 31

Upgrading and Configuring phpMyAdmin
Importing and Exporting Data
Data Types
Importing large datasets
Viewing your data in MySQL and Tableau

4

February 7

More Single-Table SQL techniques
Data Aggregation Methods and Filtering
More SQL Functions

5

February 14

SQL and Joins
Multiple Table Methods of Analyzing Data
Additional Filtering

6

February 21

Class Project Review
SQL and more Two-Table Queries
Unions
Full Outer Joins
Continue working with Tableau

7

February 28

Exam 1. This exam will be administered "online", so we will not be meeting in class.
Our first five week topics will be on this first exam. Week 6, UNIONs, will not be on this exam.

8

March 7

Mulit-table JOINS, continued.
Date Functions
Tableau Chart Types, continued.

 

March 14

Spring Break - No Class

9

March 21

Subqueries
Self-Joins
Views
User-Defined Variables
Tableau, continued.

10

March 28

SQL Statistical Functions
Visualizing statistics, regression and trends, forecasting, clustering in Tableau

11

April 4

SQL Miscellaneous Topics
More Data Visualization with Tableau
Tableau Public

12

April 11

Finals Week

Project Submittal Due: April 8, 11:55PM. Project Discussions due by Thursday, April 12, 11:55 PM.

Exam 2. This exam will be administered "online", so we will not be meeting in class.

Semester ends on Friday, April 13,11:55 PM