Databases Sprint 2: Prep covers a lot of technical material but no follow up in the day plan

[beaumoaj]

Which module(s) and week(s) does this change affect?
Module(s): Databases
Week(s): Sprint 2

What is the work that needs to be done?

The Prep for Sprint 2 in the Databases module covers a lot of very technical material, specifically :

• using aggregate functions
• inserting, updating and deleting rows
• joining tables
• creating tables
• defining primary and foreign keys

There are two issues, one being that these topics are a lot to cover in one week. The second issue is that the day-plan has a workshop that is unrelated to the prep material (it covers writing bug reports).

Why is this work important to do?

Learning the material relies on the trainees either understanding it directly from the prep material or asking questions in the study group session. This I think is quite risky and as these topics are core to the understanding of database development, it would be good to spend some time on the topics covered in the prep during the class in week 2.

I think a workshop based on the steps of identifying entities, creating tables, querying/updating data would be very useful here. Otherwise volunteers might end up making their own material if there were a lot of questions on the topics from the trainees.

Additional context

Who might need to know about this change?