Databases Intro Prep

Overview

It’s finally time to start thinking about organizing your data better than just a giant list or dictionary! Today we’ll be diving more deeply into how to organize a project like this using the Model-View-Controller design pattern and getting started with putting your data into a database and using a model to access it.

Basic Learning Objectives

Before class, you should be able to:

• Define MVC
• Identify basic SQL commands
• Identify how to create a database table using postgres

Advanced Learning Objectives

After class, you should be able to:

• Explain why MVC is important and useful
• Create a postgres database and load data into it
• Execute basic SQL commands on your database

Readings

To achieve the basic learning objectives, you should read the following:

• Model-View-Controller Explained
• The following sections of the SQL tutorial:
  • Intro through and including SQL Between
  • SQL Create Table
  • SQL Data Types
  • Postgres Data Types for reference

Checks

Write down your answer to the following and bring it to class:

• What is one query that you’d like to be able to do for your team project?

You should also be able to answer the relevant exercises on W3Schools