Moodle, Syllabus

 

Week #

Date

Assignment

 

 

This Course Calendar should follow my MBA8150 format

 

 

 

1

January 1

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

Read:
Dyer: Chapters 1, 2, 3, 4, 5

DuBois: preface

Vasilik: How to use this book (that's all)

 

Course Introduction and Overview

Who is this course for (see the Perl textbook for a good introduction.)

 

Virtual PC on a Mac

The Relational Database Model Overview
Setting up your computer's database environment, MySQL,

XAMPP & MAMPP
Installing Tableau

The MySQL client and phpMyAdmin

Upgrading and Configuring phpMyAdmin

MySQL configuration file my.cnf or my.ini

Browsing data
mysql and phpMyAdmin methods

Excel versus SQL
Both views of our databases

draw.io

2

January 2

Review what we have

Show various ways to backup and restore data.

Documeting the database
ER Diagramming,
phpMyAdmin: data dictionary
Supplemental: Diagramming techniques: draw.io

3

January 3

Importing and Exporting Data

Manually creating and inserting data

Importing Data
.sql, .csv, .xlsx, .txt,
Data Types
text, numbers, dates, other

Our databases
Importing large datasets
Viewing your data in MySQL and Tableau

Cleaning Data

4

February 4

SELECTing Data

Chapter 7 - Dyer book
This is a good start, it covers some two and three table examples. I think that this is the opportunity to illustrate many more clauses of the SELECT statement.

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

SQL Column and Row Filtering
Sorting Results

Additional Filtering

4

February 7

Tableau

Connecting Tableau to MySQL

 

 

Relational Databases (not sure where this fits in, yet.)

Codd

 

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

PowerBI connection

Exporting Data

A little data cleaning (sed???, awk???, via Excel, via Word.)

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