- Multiple Table SQL
- Inner and Outer Joins
- Partitioning and Aggregation of Joined Data
- Subqueries in Multi-table Operations
- Relational Database Programming
| 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 |
| 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 |
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.