Sep 25: GP2 Feedback, Outer Joins
Learning Objectives
After today's class, you should be able to:
- Read and write queries that include inner, outer, and self joins.
- Summarize tables and relationships in the
tpchdatabase.
Lesson Outline¶
GP2 Feedback [35 min]
- Discuss the feedback you will give
[8 min]- Compare your individual review responses
- Identify the main points to share verbally
- Meet other teams and give feedback
[24 min]- Each round is 8 minutes (4 minutes/team)
- Round 1: 3 and 5 4 and 6 7 and 2
- Round 2: 2 and 4 5 and 7 6 and 1
- Round 3: 1 and 3 (when available)
- Discuss the feedback you received (during round 3)
- Make plans and divide up the work to be done
Lecture Slides [20 min]
Group Activity [20 min]