Behind the Models: Databases & SQL
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
SQL and Migrations
Objectives
- Create databases.
- Connect to databases.
- Create tables.
- Add / query / delete rows from tables.
Resources