Subscribe to this calendar (Google, iCal, etc.)

March
SundayMondayTuesdayWednesdayThursdayFridaySaturday
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
SundayMondayTuesdayWednesdayThursdayFridaySaturday
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 Week 2 Check-ins and Worksheet Due
17:00-20:50 Lecture
MSDS Classroom
SQL Subqueries; SQL Query Patterns
Textbook section 6.3
Subqueries, Query Patterns Slides, Query Pattern Video (approx ~15m)
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
SQL Query Patterns; Data in Context; Design: Entities, Relationships, and ER Diagrams; Design: Design Theory and Normalization
Textbook sections 4.1-4.6; 3.1-3.5
ER Diagrams, Context, Normalization
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) due (no late day tokens)
17:00 Week 4 Check-ins and Worksheet Due
17:00-20:50 Lecture
MSDS Classroom
Design: Design Theory and Normalization (cont.); Design: Physical Design and Indices; Query Execution: Relational Algebra
Textbook sections 13.1-13.2, 14.1-14.2, 8.3-8.4.3
Normalization, Indices
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 and Society) due (no late day tokens)
May
SundayMondayTuesdayWednesdayThursdayFridaySaturday
17:00 Week 5 Check-ins and Worksheet Due
17:00-20:50 Lecture
MSDS Classroom
Query Execution: Relational Algebra; Query Execution: Cardinality Estimation
Textbook sections 2.4, 5.1-5.2; 16.1-16.4
RA Slides, Cardinality Est
16:00-16:50 Rudra Support Hours
MSDS Open Area
16:00-16:50 Hannah Support Hours
MSDS Open Area
17:00 Week 6 Check-ins and Worksheet Due
17:00-20:50 Lecture
MSDS Classroom
Query Execution: Physical Algorithms and Pipelining; Data Governance
Textbook sections 15.1-15.6.4; NYC Taxicab post
Phys Algos, Data Governance
16:00-16:50 Rudra Support Hours
MSDS Open Area
15:30-16:20 Hannah Support Hours
MSDS Open Area
21:00 Final Project: Proposals due
21:00 HW5 (Physical Design) due
17:00 Week 7 Check-ins and Worksheet Due
17:00-20:50 Lecture
MSDS Classroom
Hash Tables; Partitioning and Parallel Query Execution; MapReduce
Textbook sections 20.1 and 20.3; 20.4.2; 20.2 and MapReduce paper
Hash Tables, Parallel Execution, MapReduce
16:00-16:50 Rudra Support Hours
MSDS Open Area
15:30-16:20 Hannah Support Hours
MSDS Open Area
21:00 HW6 (Query Execution) due
Memorial Day
17:00 Week 8 Check-ins and Worksheet Due
17:00-20:50 Lecture
MSDS Classroom
MapReduce (cont.); NoSQL Intro and Key/Value Stores; NoSQL Document Stores
MapReduce paper (optionally: Relational Operators using MapReduce)
MapReduce; NoSQL Intro; NoSQL Docstores
16:00-16:50 Rudra Support Hours
MSDS Open Area
15:30-16:20 Hannah Support Hours
MSDS Open Area
17:00 Week 9 Check-ins and Worksheet Due
17:00-20:50 Lecture
MSDS Classroom
NoSQL Wide Column Stores; NoSQL Wrapup
Bigtable paper
DRAFT widecol; DRAFT wrapup
18:00 Final Project: (Optional) Early presentations
16:00-16:50 Rudra Support Hours
MSDS Open Area
HW7 (NoSQL Modeling) due
15:30-16:20 Hannah Support Hours
MSDS Open Area
June
SundayMondayTuesdayWednesdayThursdayFridaySaturday
17:00 Week 10 Check-ins Due
17:00 Final Project: Presentations
21:00 Final Project: Documentation and Reflection due