Behind the Models: Databases & SQL

Introduction to Databases

ERD

Objectives

  • Understand why we use databases?
  • Understand what Tables, Rows, & Columns represent.
  • Know what primary keys and foreign keys are.
  • Know the difference between database relationship types.
  • Practice drawing Entity Relationship Diagrams (ERD).

Resources

SQL and Migrations

Objectives

  • Create databases.
  • Connect to databases.
  • Create tables.
  • Add / query / delete rows from tables.

Resources

sql_interactions.png

results matching ""

    No results matching ""