Career Tracks
Free Courses
Practice
Work Experience
Projects
More
For Employers
INR
Sign in
Start Free
Course Contents (0/31)
SQL Advanced (Analytics)
Micro Free Courses
SQL Advanced (Analytics)
31 lessons
1. CTE (COMMON TABLE EXPRESSION)
Video lesson
1. Advanced SQL Tutorial | CTE (Common Table Expression)
8m
Interactive tutorial
2. CTE Patterns Quiz
6m
Assignment
3. CODING: CTEs
10m
2. WINDOW FUNCTIONS (ANALYTICS FOCUS)
Video lesson
1. Window Functions for Analysts
10m
Video lesson
2. Window Functions - Difference between ROW_NUMBER(), RANK(), DENSE_RANK()
8m
Video lesson
3. Window Functions - Lead & Lag
11m
Reading
4. Bucketing with NTILE & Running Totals
6m
Interactive tutorial
5. QUIZ: Window Functions
16m
Assignment
6. CODING: Window Functions - I
5m
Assignment
7. CODING - Window Functions - II
5m
3. SUBQUERIES - SCALAR, CORRELATED
Video lesson
1. Advanced SQL Tutorial | Subqueries
9m
Video lesson
2. Subqueries in MySQL | Intermediate MySQL
11m
Reading
3. Correlated Subqueries & NOT EXISTS
6m
Interactive tutorial
4. QUIZ: Subqueries
15m
Assignment
5. CODING: Subqueries - I
7m
Assignment
6. CODING: Subqueries - II
6m
4. ADVANCED ANALYTICS - PIVOT/UNPIVOT, INDEXING, ORDER OF EXECUTION
Video lesson
1. PIVOT and UNPIVOT in SQL
8m
Video lesson
2. SQL - Indexes (Just filter or join on indexed columns)
6m
Video lesson
3. Order of Execution - Optimizing Queries
6m
Interactive tutorial
4. QUIZ - MODULE 4
16m
Assignment
5. CODING: Pivot via Conditional Aggregation
10m
Assignment
6. CODING: Optimize a Date Filter
5m
5. ADVANCED DATABASE CONCEPTS - STORED PROCEDURES, VIEWS, TEMP TABLES
Video lesson
1. Stored Procedures
13m
Video lesson
2. Views
4m
Video lesson
3. Temp Tables
10m
Video lesson
4. Recursive CTEs
13m
Reading
5. Functions, Triggers & Global Temp Tables
7m
Interactive tutorial
6. QUIZ: MODULE 5 - I
16m
Interactive tutorial
7. QUIZ: MODULE 5 - II
16m
Assignment
8. CODING: FINALE - I
20m
Assignment
9. CODING: FINALE - II
12m
Browse Topfolio
All courses
Practice
Projects
Career tracks
Home
/
Courses
/
SQL Advanced (Analytics)
/
SUBQUERIES - SCALAR, CORRELATED
/
QUIZ: Subqueries
Back to SUBQUERIES - SCALAR, CORRELATED
QUIZ: Subqueries
15 minutes
Interactive tutorial
🎯 Free Guest Mode: You are learning for free. Sign in to save your completion progress and quiz answers.
Sign in free
Question 1 of 20
Answer saved
0 answered
What is the most accurate definition of a subquery (or inner/nested query) in SQL?
An outer query that references two or more tables.
A temporary table created at the start of a query block.
A query that is nested or contained within another query.
A query that must always return a single aggregate value.
Previous
Next
← Back to Correlated Subqueries & NOT EXISTS
Feedback