Week 1 Relating

Watch the lecture

Video: https://www.youtube.com/watch?v=WXk7yDqsKxs

Week 1 Relating

Relational Databases. Relationships: One-to-one, One-to-many, Many-to-many. Entity Relationship Diagrams. Keys: Primary Keys, Foreign Keys. Subqueries. IN. Joins: INNER JOIN, Outer Joins, LEFT JOIN, RIGHT JOIN, FULL JOIN, NATURAL JOIN. Sets: INTERSECT, UNION, EXCEPT. Groups: GROUP BY, HAVING.

How to download lecture source code into Visual Studio Code

Log into cs50.dev.
In your terminal window, type
```
wget https://cdn.cs50.net/sql/2023/x/lectures/1/src1.zip
```
followed by Enter in order to download a Zip file of lecture’s source code into your codespace.
In your terminal window, type
```
unzip src1.zip
```
followed by Enter to unzip (i.e., decompress) that Zip file.
In your terminal window, type
```
cd src1
```
followed by Enter in order to “change directory” into that src1 directory (i.e., folder).
In your terminal window, type, e.g.,
```
ls
```
followed by Enter in order to see the files.

Lecture
- Audio
- Notes
- Slides
  - Keynote
  - PDF
- Source Code
  - Index
  - PDF
  - Zip
- Subtitles
- Transcript
- Video
  - CS50 Video Player
  - MP4
    - HDR
      - 360p
      - 720p
      - 1080p
      - 4K
    - SDR
      - 360p
      - 720p
      - 1080p
      - 4K
  - YouTube
Problem Set 1