Day 14 of 14 45 minModellingBuildingQuerying
Design, build and query a complete library system. Use everything from the course, including tables, constraints, joins, grouping, views, indexes and transactions, to answer real questions.
By the end of today you can
- Design a schema with keys and constraints from requirements
- Borrow and return books safely inside transactions
- Answer business questions with joins, grouping and CTEs
- Package a report as a view and support it with indexes
What's inside
- 6 sections
- 3 diagrams and mind maps
- 8 code examples you can run
- 4-question quiz
- 1Step 1: build the schema and data
- 2Step 2: borrow a book, safely
- 3Step 3: return a book
- 4Step 4: answer real questions
- 5Step 5: a view for the front desk
- 6Recap: your two weeks
Sign in free to read this lesson
Get the full lesson with diagrams, runnable code and the quiz. Your progress is saved across devices.
Sign in free