LAB 1
Introduction to R and Data Types

CLASS 3
SQL CREATE and MySQL


Let's start with CREATE so we have tables to work with!

LAB 2
Working With Tables

CLASS 5
SQL SELECT

Chapter 2 in Kroenke or Chapter 3 in Badia
LAB02 Due At 2359

CLASS 6
SQL SELECT (Joins)

Chapter 2 in Kroenke

LAB 3
Queries and Joins

CLASS 8
Sets

LAB 4
Advanced Queries

CLASS 9
Normalization

Chapter 3,4 in Kroenke

LAB 5
Normalization Lab

REVIEW 1
6wk Review

EXAM 1
6wk exam

PROJECT 1
Project Kick-Off

CLASS 11
ER Model

Chapter 5 in Kroenke

LAB 6
Entity Relationship Modeling

LAB 7
Python and MySQL

LAB 8
R and MySQL

LAB 9
Data Cleaning


Labs deliverables are due at the beginning of the Project Status presentations next week.

REVIEW 2
12 wk Review

EXAM 2
12wk exam

PROJECT 2
Project Status Review and Presentations


Teams will present their status, Milestone 2 is to be completed by this date. Although it is recommended to be through Part 3 of the project.

CLASS 19
Transactions and Concurrency Control

Chapter 9 in Kroenke

LAB 10
Transactions and Indexing


Previous lab due at 0745

LAB 11
SQLite


Previous lab due at 0745

LAB 12
Data Storage Hardware


Previous lab due at 0745

PROJECT 3
Project Prep Time


Previous lab due at 0745

PROJECT 4
Project Presentations

EXAM 3
Final Exam


Exam at 0755
Section 2141 HP107
Section 4341 HP108