August 2023

MondayTuesdayWednesdayThursdayFridaySaturdaySunday
  1








2








3








4








5








6








7








8








9








10








11








12








13








14








15








16








17
CLASS 1
Course Overview and the Relational Model






18








19








20








21
CLASS 2
SQL CREATE and MySQL


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



22








23
CLASS 3
SQL ALTER, INSERT, UPDATE, and DELETE






24
LAB 1
Working With Tables






25
HOLIDAY







26








27








28
CLASS 4
SQL SELECT

Chapter 2 in Kroenke or Chapter 3 in Badia




29








30
CLASS 5
SQL SELECT (Joins)

Chapter 2 in Kroenke




31
LAB 2
Queries and Joins






September 2023

MondayTuesdayWednesdayThursdayFridaySaturdaySunday
        1








2








3








4
HOLIDAY







5








6
CLASS 6
SQL SELECT (Advanced joins)






7
LAB 3
Advanced Queries






8








9








10








11
CLASS 7
Normalization

Chapter 3,4 in Kroenke




12








13
CLASS 8
Normalization Continued






14
LAB 4
Normalization Lab






15








16








17








18
CLASS 9
ER Model

Chapter 5 in Kroenke




19








20
CLASS 10
ER Model II






21
LAB 5
Entity Relationship Modeling






22








23








24








25
CLASS 11
6 wk Review






26








27
EXAM 1
6wk exam






28
ER MODELING LAB CONT







29








30








October 2023

MondayTuesdayWednesdayThursdayFridaySaturdaySunday
            1








2
CLASS 12
Python and MySQL






3








4
CLASS 13
Python and MySQL Continued






5
LAB 6
Python and MySQL






6








7








8








9
HOLIDAY







10
FRIDAY SCHEDULE







11
CLASS 14
R Review






12
LAB 7
R Review






13








14








15








16
CLASS 15
R and MySQL






17








18
CLASS 16
SQL Injections






19
LAB 8
R and MySQL






20








21








22








23
CLASS 17
SQL VIEWs






24








25
CLASS 18
SQL Stored Procedures and Triggers

p320-333 in Kroenke (part of chapter 7)




26
LAB 9
SQL Stored Procedures, Triggers, and Views






27








28








29








30
PROJECT 1
Final Project


Milestone 1 Due Nov 9 2359 Milestone 2 Due Nov 30 2359 Final Project due Dec 7 2023 NLT 0755



31








November 2023

MondayTuesdayWednesdayThursdayFridaySaturdaySunday
    1
CLASS 19
12 wk Review






2
EXAM 2
12wk exam






3








4








5








6
CLASS 20
Transactions and Concurrency Control

Chapter 9 in Kroenke




7








8
CLASS 21
Data Storage and Indexing






9
LAB 10
Transactions and Indexing


Project Milestone 1 due by 2359



10
HOLIDAY







11








12








13
CLASS 22
Data Storage Hardware: HD, SSD, Flash






14








15
CLASS 23
Data Storage Hardware: Caching






16
LAB 11
Data Storage Hardware






17








18








19








20
COMP DAY







21
VINT CERF LECTURE RI102 AT 1200







22
FRIDAY SCHEDULE







23
HOLIDAY







24
HOLIDAY







25








26








27
CLASS 24
Ethics and Data


NYTimes slideshow
Washington Post Article



28








29
CLASS 25
SQLite






30
LAB 12
SQLite


Project Milestone 2 due by 2359



December 2023

MondayTuesdayWednesdayThursdayFridaySaturdaySunday
        1








2








3








4
PROJECT WORK







5








6
PROJECT WORK







7
FINAL PROJECT PRESENTATIONS







8








9








10








11








12








13








14








15








16
EXAM 3
Final Exam


exam at 0755
HP123 - s2141, s4341 B-C
HP125 - s4341 D-W, S6541



17








18








19








20








21








22








23








24








25








26








27








28








29








30








31