Lecture 4 - SQL
Presented by Anthony D. Joseph
Content by Anthony D. Joseph, Allen Shen, Josh Hug, John DeNero, Joseph Gonzalez
A random one of the following nine Google Forms will give you an alphanumeric code once you submit; you should take this code and enter it into the “Lecture 4” question in the “Quick Check Codes” assignment on Gradescope to get credit for submitting this Quick Check. You must submit this by Monday, September 14th at 11:59PM to get credit for it.
| 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 |