Skip to content
SQL Intermediate
Overview
Part 1. Advanced Retrieval Patterns
Subqueries (in SELECT, WHERE, FROM)
Collapse
Subqueries (in SELECT, WHERE, FROM)
6 Topics
Subqueries in SELECT
Subqueries in WHERE
Subqueries in FROM
CTEs (Common Table Expressions)
Nested Subqueries
Subquery vs CTE vs Derived Table Comparison
Part 2. Advanced Filtering & Logic
EXISTS
ANY / ALL
CASE (Advanced Patterns)
COALESCE / IFNULL (Applied)
CASE with Aggregations — Conditional Counting and Summarizing
NULL-Safe Filtering — IS NULL and IS NOT NULL
Part 3. Data Cleaning with SQL
TRIM, UPPER, LOWER
CAST / CONVERT
Handling Messy Strings
Date functions (DATEADD, DATEDIFF, EXTRACT)
NULL handling and imputation (COALESCE, default values)
Duplicate detection and removal (DISTINCT, GROUP BY, ROW_NUMBER)
Previous Lesson
Subqueries (in SELECT, WHERE, FROM)
SQL Intermediate
Subqueries (in SELECT, WHERE, FROM)
Lesson Content
0% Complete
0/6 Steps
Subqueries in SELECT
Subqueries in WHERE
Subqueries in FROM
CTEs (Common Table Expressions)
Nested Subqueries
Subquery vs CTE vs Derived Table Comparison
Previous Lesson
Back to Course
Cancel Preloader
Sign in
Sign up
Sign in
Don’t have an account?
Sign up
Remember me
Lost your password?
Sign up
Already have an account?
Sign in
Login
Accessing this course requires a login. Please enter your credentials below!
Username or Email Address
Password
Remember Me
Lost Your Password?
Register
Don't have an account? Register one!
Register an Account
