Schedule

March
MondayTuesdayWednesdayThursdayFriday
31 01
17:00-20:50 Lecture
L039 400
Course Expections, Relational Data Models, SQL
Slides, Section Slides, Demo SQL
02 03
READING: Textbook Ch. 2.1-2.3, 6.1-6.2, 6.5
14:30-15:30 Megan
MSDS
04
April
MondayTuesdayWednesdayThursdayFriday
07 08
16:00-17:00 Soohyun
MSDS
17:00 Week 1 Activities
17:00-20:50 Lecture
L039 400
SQL: Joins and Aggregation
Slides, Section Slides, Demo SQL
09 10
READING: Textbook Ch. 6.3.6, 6.4
14:30-15:30 Megan
MSDS
21:00 HW1 SQL/sqlite (Gradescope)
11
14 15
16:00-17:00 Soohyun
MSDS
17:00 Week 2 Worksheet,Employee pay,Employee titles
17:00-20:50 Lecture
L039 400
SQL: Sub-queries
Slides, Section Slides, Demo SQL
16 17
READING: Textbook Ch. 6.3
14:30-15:30 Megan
MSDS
21:00 HW2 Basic SQL
18
21 22
16:00-17:00 Soohyun
MSDS
17:00 Week 3 Worksheet
17:00-20:50 Lecture
L039 400
Database design / ER Diagrams
Slides, Section Slides
23 24
READING: Textbook Ch. 3.1-3.3, 4.1-4.6
21:00 Advanced SQL/Postgres, and Postgres Setup
25
28 29
16:00-17:00 Soohyun
MSDS
17:00 Week 4 Worksheet
17:00-20:50 Lecture
L039 400
Physical database / Indices
Slides, Section Slides
30 01
READING: Textbook Ch. 3.1-3.5, 13.1-13.2, 14.1-14.3
14:30-15:30 Megan
MSDS
02
May
MondayTuesdayWednesdayThursdayFriday
05 06
16:00-17:00 Soohyun
MSDS
17:00 Week 5 Worksheet
17:00-20:50 Lecture
L039 400
Query design / Relational Algebra
Slides, Section Slides
07 08
READING: Textbook Ch. 2.4, 5.1-5.2, 16.1-16.4
14:30-15:30 Megan
MSDS
21:00 HW4 Database Design
09
12 13
16:00-17:00 Soohyun
MSDS
17:00 Week 6 Worksheet
17:00-20:50 Lecture
L039 400
Parallel Processing, MapReduce, Distributed Data
Slides, Section Slides
14 15
READING: Textbook Ch. 20.1 - 20.4.1
14:30-15:30 Megan
MSDS
21:00 HW5 Query Execution
16
19 20
16:00-17:00 Soohyun
MSDS
17:00 Week 7 Worksheet
17:00-20:50 Lecture
L039 400
Hashing, Intro to NoSQL
Slides, Section Slides
21 22
READING: Textbook Ch. 14.2 - 14.3, 20.1 - 20.3
14:30-15:30 Megan
MSDS
23
Team Selection for Project due, on Canvas
26
Memorial Day
27
16:00-17:00 Soohyun
MSDS
17:00-20:50 Lecture
L039 400
NoSQL Conclusion
Slides
28 29
Explore Neo4j
14:30-15:30 Megan
MSDS
21:00 HW6 Parallel Data & MapReduce
30
June
MondayTuesdayWednesdayThursdayFriday
02 03
16:00-17:00 Soohyun
MSDS
17:00 Week 8/9 Worksheet Week 8/9 Worksheet
17:00-20:50 Lecture
L039 400
Wrap-up / Final Projects
Slides
04 05
14:30-15:30 Megan
MSDS
21:00 HW7 NoSQL Design
06
09 10
17:00 Project Presentations
17:00-20:50 Lecture
L039 400
Final Projects
11 12
21:00 Project Reflections Due
13