Planning for Week 10
High Level Topic Summary
- Python Database Programming
- Database Design and Creation
- Populating/Inserting into a Database
Readings for the week
Monday |
Chapter 13 |
None |
Tuesday |
- |
|
Wednesday |
Chapter 14, 14.1 to 14.3 |
None |
Friday |
Chapter 14, 14.4 and 14.5 |
None |
Projected Class and Homework
|
Monday |
Wednesday |
None: Quiz 3 and work on Project 1 |
HW_3.4 |
Wednesday |
Friday |
Python Database Programming |
|
Friday |
Monday |
None: Work on Project 1 |
Tuesday Problem Day
Progression
We begin the week by developing the abstractions, interface, and techniques for relational database programming in Python. After the quiz on Tuesday, which will focus on SQL and XPath, we launch into some of the most important principles for when we need to create our own databases. This will revisit some of the tidy data principles and then extend to being intentional about the relationships between tables in a database. SQL for table creation and for population of tables with data will be covered as time permits.