Skip to content

Nov 13: Set Ops, Window Funcs

Learning Objectives

After today's class, you should be able to:

  • Write subqueries in the FROM clause and the WHERE clause.
  • Connect two queries with UNION, INTERSECT, and EXCEPT.
  • Describe window functions that use OVER and PARTITION.

Lesson Outline

GP5 Feedback [40 min]

  • Understand the process [5 min]
  • Plan your demonstration [5 min]
    • Index/about pages, project goals
    • Action(s), Chart(s), and Form(s)
  • Meet with other teams [30 min]
    • Each round is 10 minutes (5 minutes/team)
    • Take notes so you know what to look for in their code!
    • Round 1:   3 and 6    4 and 7    5 and 1
    • Round 2:   6 and 2    7 and 3    1 and 4
    • Round 3:   2 and 5 (when available)
  • Discuss the feedback you received (during round 3)
    • Make plans and divide up the work to be done

Lecture Slides [35 min]

Your To-Do List