SQL joins and constraints
Use sql joins and constraints to make decisions inspectable.
What you should be able to do
Independently: Check primary keys, foreign keys and join results on example tables.
Suggested prerequisites
A short guide
Use sql joins and constraints to make decisions inspectable. Check primary keys, foreign keys and join results on example tables. Read the indicated source section, identify its key concepts and conditions, and work through the example. Record inputs, sources, units and assumptions. Keep your method separate from the result, mark unanswered questions, and review the output against the checklist.
An example
Missing foreign-key matches need explicit handling.
Your task
Check primary keys, foreign keys and join results on example tables.
Start with this source
Read the indicated section relevant to sql joins and constraints and complete the foundation task.
This source is awaiting renewed review. Try the task above and adjacent skills; reviewed sources will appear here.
Your learning checklist
Required items: 0 / 10 completed or already known
Next: Read a role through its responsibilities
Checklist statuses are self-reported; exercise scores are recorded separately. You can reset any item.