Oct 15: SQL Views, Group Database

Learning Objectives

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

• Explain the difference between a view and a materialized view.
• Configure an SSH tunnel for connecting to the database server.

Announcements

• Due TODAY (before break)
  • Submit the MidEval survey
• Due before the next class
  • Read zyBook section 5.8
  • Skim faker documentation
• GP3 postponed one week
  • Watch for new deadlines
  • Have a wonderful break!

Lesson Outline

Exam Debrief [15 min]

• Answers posted on Canvas
• Grades coming after break

SQL Views [15 min]

• Views in SQL
• You will write views on GP3

SSH Tunnel [15 min]

• Setting up an SSH tunnel

Group Database [15 min]

• Each group has a user/password – see GitHub repo
• Test connecting from Python via your SSH tunnel to stu
  • connect.py – use your group's user/password
• Create new connection profiles in Workbench and pgAdmin

Project Data [15 min]

• Finding real data (Ex: awesome-public-datasets)
• Generating fake data (see last Tuesday's class)