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)
/
WINDOW FUNCTIONS (ANALYTICS FOCUS)
/
QUIZ: Window Functions
Back to WINDOW FUNCTIONS (ANALYTICS FOCUS)
QUIZ: Window Functions
16 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
Which statement best describes the primary behavior of a SQL Window Function?
It collapses groups of rows into a single summary row, like GROUP BY.
It performs a calculation on a set of table rows but returns a result for every individual row.
It creates temporary, indexed tables for use in a single session.
It is used exclusively to define and enforce foreign key constraints.
Previous
Next
← Back to Bucketing with NTILE & Running Totals
Feedback