Lecture 4 - SQL
Presented by Anthony D. Joseph
Content by Anthony D. Joseph, Allen Shen, Josh Hug, John DeNero, Joseph Gonzalez
- 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.
Databases and database management systems.
Relational database schemas.
SQL overview and the DISTINCT keyword.
Types of joins in SQL.
NULL values in SQL.
SQL predicates and casting.
SQL sampling, subqueries, and common table expressions.
SQL CASE expressions and the SUBSTR function.
SQL summary and conclusion.