Lecture 8 - SQL
Presented by Raguvir Kunani
Content by Raguvir Kunani, 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
The Quick Checks for this lecture are not yet ready to be released; please check back later. 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 | |
|---|---|---|
| 8.0 Introduction |
||
| 8.1 Databases |
8.1 | |
| 8.2 SQL Basics |
8.2 | |
| 8.3 Column Aggregation Functions and Arithmetic |
8.3 | |
| 8.4 Types of Joins in SQL |
8.4 | |
| 8.5 NULL values in SQL |
8.5 | |
| 8.6 Grouping |
8.6 | |
| 8.7 Relational Databases |
8.7 | |
| 8.8 DISTINCT and SQL CASE expressions |
8.8 | |
| 8.9 Conclusion |
8.9 | |
| 8.10 (EXTRA) Predicates in SQL |
8.10 | |
| 8.11 (EXTRA) SQL Sampling, subqueries, and common table expressions |
8.11 | |
| 8.12 (EXTRA) SQL CASE expressions and SUBSTR |
8.12 |