Planning for Week 9

High Level Topic Summary

Readings for the week

Day Reading Reading Questions
Monday Chapter 12, 12.1 through 12.3 None
Tuesday -
Wednesday Chapter 12, 12.4 and 12.5 None
Friday Chapter 13 TBD

Projected Class and Homework

HW Day Out Day Due Contents
HW_3.3 Monday Wednesday Tableau Practicum Turnin
HW_3.4 Wednesday Friday Single Table SQL Access Operations
Friday Monday None: Work on Project 1

Tuesday Problem Day


The work of the week will be roughly split up by treating multi-table SQL on Monday and Wednesday, and developing the abstractions, interface, and techniques for relational database programming on Friday. The focus on Monday will be in joining tables using inner and outer joins. This will be reinforced with some problems on Tuesday and the homework for Wednesday night. On Wednesday, we see how these composite/joined table give us additional power when we do group by and aggregation, and also how we can use a subquery, often which contains a joined table, as part of a larger query.

The focus of Friday is the integration of what we have learned in SQL with the programmatic techniques of “making it happen” in Python, when we are not using SQL magics or third-party client tools.