Lecture 4 - SQL

by Allen Shen (Summer 2020)

Make sure to complete the Quick Check questions in between each video. These are ungraded, but it’s in your best interest to do them.

Video Quick Check
4.1
Databases and database management systems.
4.1
4.2
Relational database schemas.
4.2
4.3
SQL overview and the DISTINCT keyword.
4.3
4.4
Types of joins in SQL.
4.4
4.5
NULL values in SQL.
4.5
4.6
SQL predicates and casting.
4.6
4.7
SQL sampling, subqueries, and common table expressions.
4.7
4.8
SQL CASE expressions and the SUBSTR function.
4.8
4.9
SQL summary and conclusion.
4.9
Notebook
Notebook walkthrough (Josh Hug).
N/A
Notebook
Notebook walkthrough (Allen Shen).
N/A