Lecture 9 – SQL II

Presented by Alvin Wan

Content by Alvin Wan, Fernando Pérez, Suraj Rampure, Ani Adhikari, Sam Lau, Yifan Wu

The Quick Checks for this lecture are not yet ready to be released; please check back later. A reminder – the right column of the table below contains Quick Checks. These are not required but suggested to help you check your understanding.

Video Quick Check
9.1
Introduction
9.2
Motivation
9.2
9.3
Types of Relationships
9.3
9.4
Join Tables
9.4
9.5
Handling Null
9.5
9.6
Subsampling
9.6
9.7
Practice
9.7
9.8
Conclusion
9.8