SQL for Data Analytics · Database design
Database design
This unit is about designing a database from a business problem: working out which tables it needs, what goes in each one, and how they connect. The lessons start with a video of an example design. Then they walk through designing a database for Edanava, a consulting company that needs to track its sales opportunities, one decision at a time. The diagram boxes in the lessons check each piece as you build it.
The lessons:
- Designing a database (25 min). An example design from start to finish, and the steps it goes through.
- The Edanava problem (20 min). Edanava's problem, the sales team's documents, and the first tables: clients, contacts, and the sales team.
- Opportunities & steps (30 min). Opportunities, the five steps every opportunity goes through, and the joining table that records each step of each opportunity.
- Testing the design (15 min). Putting the example opportunity into the design, one way to design it, and where reasonable designs differ.
When you've finished the lessons, do the Practice. It's worth fifteen points, and every question is about a property management company. This is what you turn in on Canvas.