CS 374: Database Systems
James Madison University, Spring 2022

Feb 17: GitHub, Join Queries, Indexes

Lesson Outline

15 min psql / meld
* Finish slides 6–10 from end of Tuesday
* Running meld from the command line
25 min Git / GitHub
* Group repository
* Group database
* Environment variables
15 min JOIN Queries
* JOIN and LEFT JOIN
* NULL and UNKNOWN
20 min Query Optimization
* Indexes
* EXPLAIN

Before Thursday

  1. Textbook: Read PDBM 7.3.1.5--6 (10 pages).

  2. Homework: Keep working on HW4 (due in 10 days).

  3. Project: Keep working on GP2 (gater data, write DDL).