Explore
Career Tracks
Free Courses
Practice Labs
SQL Benchmark
Work Experience
Job Hunt Tracker
Portfolio Projects
AI Resume Grader
Career Tracks
Free Courses
Practice
Projects
For Employers
Blog
Support
INR
Sign in
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)
/
CODING - Window Functions - II
Back to WINDOW FUNCTIONS (ANALYTICS FOCUS)
CODING - Window Functions - II
5 minutes
Assignment
Loading lesson...
Feedback
