SQL
Advanced SQL Queries
Join tables together, write a query inside a query, and put window functions to work.
Start the trackFree, no sign-up needed
What you'll learn
- Joining two tablesMatching rows with INNER JOIN
- Left joinsLEFT JOIN and checking with IS NULL
- Totals per customerCombining JOIN with GROUP BY
- Joining three tablesTwo JOINs in a row
- SubqueriesA query inside a query
- Naming intermediate resultsNaming each step with WITH
- The top row in each groupNumbering with ROW_NUMBER and splitting with PARTITION BY
- Running totalsSUM with OVER
- Changing dataINSERT, UPDATE and DELETE
- Table constraintsRules the database enforces
Track contents
10 lessons, 2.5 hours in total- 1Joining two tablesSQLMatching rows with INNER JOIN13 min
- 2Left joinsSQLLEFT JOIN and checking with IS NULL12 min
- 3Totals per customerSQLCombining JOIN with GROUP BY13 min
- 4Joining three tablesSQLTwo JOINs in a row13 min
- 5SubqueriesSQLA query inside a query14 min
- 6Naming intermediate resultsSQLNaming each step with WITH14 min
- 7The top row in each groupSQLNumbering with ROW_NUMBER and splitting with PARTITION BY15 min
- 8Running totalsSQLSUM with OVER12 min
- 9Changing dataSQLINSERT, UPDATE and DELETE14 min
- 10Table constraintsSQLRules the database enforces16 min