Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL Fundamentals for Business Intelligence
Installing Postgres and Our Initial Dataset
The Course Overview (4:14)
Installation on Windows and Mac Via PostgresApp (3:17)
Installing pgAdmin (2:16)
Downloading and Restoring the DVD Rental Database (2:24)
Putting SQL Clauses into Practice
SELECT, WHERE, GROUP BY, and COUNT Clauses (13:09)
Most Common JOINs (10:44)
More LEFT JOIN and SELF JOIN (9:45)
Everything Is a Table (7:02)
JOIN and Filtering Gotchas – Common Errors to Avoid (7:28)
WHERE Versus HAVING for Filtering (8:18)
The Big Picture of Non-Trivial SQL with Examples
Subqueries (9:21)
Correlated Subqueries (6:00)
Common Table Expressions (CTEs) (7:37)
Dealing with Dates and Times (7:28)
The CASE Statement (5:58)
Inserting External Data (11:54)
SELECT, WHERE, GROUP BY, and COUNT Clauses
Complete and Continue