Micro Free Course — 100% Free Learning
All lessons in this module are free to learn. Sign in with Google to save your progress.
3
SUBQUERIES - SCALAR, CORRELATED
CASE WHEN, COALESCE, string and date functions for tidy analytics datasets.
Module Progress0% Complete
75 min total
6 Lessons
0 Completed
Module Content
Advanced SQL Tutorial | Subqueries
9 minVideo
Start
Subqueries in MySQL | Intermediate MySQL
10 minVideo
Start
Correlated Subqueries & NOT EXISTS
A short reading covering correlated subqueries and the EXISTS/NOT EXISTS anti-join pattern -- required by the next coding exercise but not covered in either subquery video.
6 minArticle
Start
QUIZ: Subqueries
15 minTutorial
Start
CODING: Subqueries - I
15 minAssignment
Start
CODING: Subqueries - II
15 minAssignment
Start