Module 7 Activity: Join and Reconcile Course Tables

Estimated active time: 90 minutes

Task

Combine fictional enrolment, course, and support ticket tables.

Steps

1. Identify the main table.
2. Identify join keys.
3. Check missing keys in each table.
4. Check duplicate keys where uniqueness is expected.
5. Join course details to enrolments.
6. Count support tickets by enrolment.
7. Join ticket counts to enrolments.
8. Record row counts before and after each join.
9. Investigate missing matches.
10. Complete the join reconciliation checklist.

Deliverable

• Joined analysis table.
• Key check table.
• Row-count reconciliation.
• Join decision note.

Quality bar

The activity is ready when row counts are explained and missing matches are not ignored.