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 |