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, DRAFT 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; Hashing;
Textbook sections 15.1-15.6.4; 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 HW5 (Physical Design)
21:00 Final Project: Proposals due
17:00 Week 7 Check-ins and Worksheet Due
17:00-20:50 Lecture
MSDS Classroom
Partitioning; 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
21:00 HW6 (Query Execution) due
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
17:00 Week 9 Check-ins and Worksheet Due
17:00-20:50 Lecture
MSDS Classroom
Course Wrapup
18:00 Final Project: (Optional) Early presentations
16:00-16:50 Rudra Support Hours
MSDS Open Area
16:00-16:50 Hannah Support Hours
MSDS Open Area
21:00 HW8 (Designing Database Applications) due
June
SundayMondayTuesdayWednesdayThursdayFridaySaturday
17:00 Final Project: Presentations
21:00 Final Project: Documentation and Reflection due