Week 5, Day 1

Block 1 & 2: Introduction to Databases

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

• Slide Deck | Markdown Version
• ERD Relationship and Diagrams
• Postgres Data Types

Block 3 & 4: SQL and Migrations

Objectives

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

Resources

• Postgres.app
• Slide Deck | Markdown Version
• Postgres Cheatsheet

After Hours

SQL Reps!