Week 5 Optimizing

Watch the lecture

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

Week 5 Optimizing

Indexes. CREATE INDEX. EXPLAIN QUERY PLAN. Covering Indexes. B-Trees. Partial Indexes. VACUUM. Concurrency. Transactions. ACID: Atomicity, Consistency, Isolation, Durability. BEGIN TRANSACTION. COMMIT. ROLLBACK. Race Conditions. Locks.

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/5/src5.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 src5.zip
```
followed by Enter to unzip (i.e., decompress) that Zip file.
In your terminal window, type
```
cd src5
```
followed by Enter in order to “change directory” into that src5 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 5