Subscribe to this calendar (Google, iCal, etc.)
| March | ||||
|---|---|---|---|---|
| Monday | Tuesday | Wednesday | Thursday | Friday |
|
17:00-20:50 Lecture
MSDS Classroom Course Expectations and Relational Model; SQL Basics (SELECT-FROM-WHERE, nested-loop semantics); SQL Joins: Inner Joins Textbook sections 2.1-2.3; 6.1-6.2 Expectations, Basics, Inner Joins, Demo 1, Demo 2 |
16:00-16:50 Hannah Support Hours
MSDS Open Area |
|||
| April | ||||
|---|---|---|---|---|
| Monday | Tuesday | Wednesday | Thursday | Friday |
|
17:00 Week 1 Check-ins (formerly "reflection") and Worksheet Due
17:00-20:50 Lecture
MSDS Classroom SQL Joins: Outer Joins and NULL; SQL Aggregates; SQL Aggregates with Joins Same textbook sections (6.1-6.2); 6.4 Outer Joins/NULL, Demo, Aggregates, Agg + Join, Payroll/Registry SQL |
16:00-16:50 Rudra Support Hours
MSDS Open Area |
16:00-16:50 Hannah Support Hours
MSDS Open Area
21:00 HW1 (Intro to SQL and SQLite) due
|
||
|
17:00-20:50 Lecture
MSDS Classroom SQL Subqueries; SQL Query Patterns; Data in Context Textbook section 6.3 |
16:00-16:50 Rudra Support Hours
MSDS Open Area |
16:00-16:50 Hannah Support Hours
MSDS Open Area
21:00 HW2 (Basic SQL Queries) due
(direct link to flights schema documentation) |
||
|
17:00 Week 3 Check-ins and Worksheet Due
17:00-20:50 Lecture
MSDS Classroom Design: Entities, Relationships, and ER Diagrams; Design: Design Theory and Normalization Textbook sections 4.1-4.6; 3.1-3.5 |
16:00-16:50 Rudra Support Hours
MSDS Open Area |
16:00-16:50 Hannah Support Hours
MSDS Open Area
21:00 HW3 (Advanced SQL Queries and Society) due
|
||
|
17:00 Week 4 Check-ins and Worksheet Due
17:00-20:50 Lecture
MSDS Classroom Design: Physical Design and Indices; Query Execution: Relational Algebra Textbook sections 13.1-13.2, 14.1-14.2, 8.3-8.4.3; 2.4, 5.1-5.2 |
16:00-16:50 Rudra Support Hours
MSDS Open Area |
16:00-16:50 Hannah Support Hours
MSDS Open Area
21:00 HW4 (Design Theory) due
|
||
| May | ||||
|---|---|---|---|---|
| Monday | Tuesday | Wednesday | Thursday | Friday |
|
17:00 Week 5 Check-ins and Worksheet Due
17:00-20:50 Lecture
MSDS Classroom Query Execution: Relational Algebra (cont.); Query Execution: Cardinality Estimation; Query Execution: Physical Algorithms and Pipelining Same textbook sections (2.4, 5.1-5.2); 16.1-16.4; 15.1-15.6.4 |
16:00-16:50 Rudra Support Hours
MSDS Open Area |
16:00-16:50 Hannah Support Hours
MSDS Open Area
21:00 HW5 (Physical Algorithms and Design)
21:00 Team selection due
|
||
|
17:00 Week 6 Check-ins and Worksheet Due
17:00-20:50 Lecture
MSDS Classroom Data Governance; Hashing; Partitioning and Parallel Query Execution Textbook sections 20.1; 20.3-20.4.2; NYC Taxicab post |
16:00-16:50 Rudra Support Hours
MSDS Open Area |
16:00-16:50 Hannah Support Hours
MSDS Open Area
21:00 HW6 (Query Execution) due
|
||
|
17:00 Week 7 Check-ins and Worksheet Due
17:00-20:50 Lecture
MSDS Classroom Parallel Query Execution (cont.); MapReduce; Intro to NoSQL |
16:00-16:50 Rudra Support Hours
MSDS Open Area |
16:00-16:50 Hannah Support Hours
MSDS Open Area |
||
|
Memorial Day
|
17:00 Week 8 Check-ins and Worksheet Due
17:00-20:50 Lecture
MSDS Classroom NoSQL (cont.) |
16:00-16:50 Rudra Support Hours
MSDS Open Area |
16:00-16:50 Hannah Support Hours
MSDS Open Area
21:00 HW7 (NoSQL Design) due
|
|
| June | ||||
|---|---|---|---|---|
| Monday | Tuesday | Wednesday | Thursday | Friday |
|
17:00 Week 9 Check-ins and Worksheet Due
17:00-20:50 Lecture
MSDS Classroom Course Wrapup
18:00 Project Presentations (part 1)!
|
16:00-16:50 Rudra Support Hours
MSDS Open Area |
16:00-16:50 Hannah Support Hours
MSDS Open Area
21:00 HW8 (Database Applications) due
|
||
|
17:00 Project Presentations (part 2)!
|
21:00 Project Reflections due
|
|||