Comp 305-001/488-305: Database Administration
Spring 2018: Tuesdays, 4:15-6:45, Comm 013
Week 3
Continuation: sql1.html,
starting with
- situations where we use the join
- Two kinds of join: "extension" and "relationship"
- A look at constraints
- foreign keys
- other constraints
- Data Consistency revisited (implicit constraints)
- On Update/Delete actions
- Insert, Delete, Update
- SQL examples
sql2.html:
- joins as simple loops
- self-joins
- WHERE
- a tricky foreign-key constraint
- employees who worked on project2 and project3
- outer joins
- NULL
- nested queries
- aggregation functions
- GROUP BY
- multi-valued nested queries
- EXISTS and UNIQUE
- ALL (universal quantification)
- except / minus
- GROUP BY with HAVING
- views
- triggers
Installation
assignment:
Install
PostgreSQL on your own machine