/phase-3-lecture-6-sql-fundamentals-and-table-relations

Phase 3, Lecture 6: SQL Fundamentals & Table Relations

Lecture Topics

  • SQL
  • Primary Keys
  • Foreign Keys
  • Join table

Introduction

In today's lecture, we will discuss the SQL Fundamentals & Table Relations between tables in a relational database that we will build and interact with using SQL code.

Setup

  1. Run sqlite3 hotel_reviews.db in your terminal to enter the sqlite3 environment and begin writing SQL code to create tables and rows in the hotel_reviews database.