Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL Fundamentals for Business Intelligence
Installing Postgres and Our Initial Dataset
The Course Overview
Installation on Windows and Mac Via PostgresApp
Installing pgAdmin
Downloading and Restoring the DVD Rental Database
Putting SQL Clauses into Practice
SELECT, WHERE, GROUP BY, and COUNT Clauses
Most Common JOINs
More LEFT JOIN and SELF JOIN
Everything Is a Table
JOIN and Filtering Gotchas – Common Errors to Avoid
WHERE Versus HAVING for Filtering
The Big Picture of Non-Trivial SQL with Examples
Subqueries
Correlated Subqueries
Common Table Expressions (CTEs)
Dealing with Dates and Times
The CASE Statement
Inserting External Data
SELECT, WHERE, GROUP BY, and COUNT Clauses
Complete and Continue