Oct 21: Database Scripts; Views

Learning Objectives

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

• Write scripts to automate dropping, creating, and loading a database.
• Explain differences between a table, a view, and a materialized view.

Lesson Outline

• [10 min] Q&A for HW4
• [15 min] Building the Project Database
• [50 min] Scripts for Project Database

Your To-Do List

• Submit HW4 – due today
  • Late submissions will be accepted without penalty until Tue 10/28 8:00am.
• Finish your project scripts
  • This could be done after fall break, or sooner if you would like to get ahead.
  • GP4 will assume your database already exists so you can run sqlacodegen.