Lecture 4 - SQL
Presented by Anthony D. Joseph
Content by Anthony D. Joseph, Allen Shen, Josh Hug, John DeNero, Joseph Gonzalez
- slides
- video playlist
- code (launch)
- code HTML
- code walkthrough by Josh Hug
- code walkthrough by Allen Shen
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 | |
|---|---|---|
| 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 |