Topfolio
Back to Micro Free Courses

SQL Advanced (Analytics)

Intermediate

Master analytics-grade SQL: CTEs, window functions, subqueries, advanced queries, and optimization techniques.

SQL Advanced (Analytics)
Duration

4 weeks

Content

5 modules, 31 lessons

Students

51

Total Time

~7 hours

100% Free Structured Micro Course

All video lessons, coding exercises, and quizzes are completely free with zero gatekeeping. Start learning right away!

Micro Free Course• 100% Free Learning & Quizzes

Start Learning Immediately

Every video, lesson, and practice quiz is completely free. Upgrade to an Official Verified Certificate & AI Review anytime for just ₹99.

Course Curriculum

1

CTE (COMMON TABLE EXPRESSION)FREE PREVIEW

CTEs (WITH) for modular analytics queries.

75 min3 lessons
Video lessonAdvanced SQL Tutorial | CTE (Common Table Expression)
4 min
Interactive tutorialCTE Patterns Quiz
10 min
AssignmentCODING: CTEs
10 min
Start Module
2

WINDOW FUNCTIONS (ANALYTICS FOCUS)FREE PREVIEW

RANK, ROW_NUMBER, DENSE_RANK, running totals, moving averages with PARTITION BY.

90 min7 lessons
Video lessonWindow Functions for Analysts
10 min
Video lessonWindow Functions - Difference between ROW_NUMBER(), RANK(), DENSE_RANK()
7 min
Video lessonWindow Functions - Lead & Lag
10 min
ReadingBucketing with NTILE & Running Totals
6 min
Interactive tutorialQUIZ: Window Functions
15 min
AssignmentCODING: Window Functions - I
15 min
AssignmentCODING - Window Functions - II
15 min
Start Module
3

SUBQUERIES - SCALAR, CORRELATEDFREE PREVIEW

CASE WHEN, COALESCE, string and date functions for tidy analytics datasets.

75 min6 lessons
Video lessonAdvanced SQL Tutorial | Subqueries
9 min
Video lessonSubqueries in MySQL | Intermediate MySQL
10 min
ReadingCorrelated Subqueries & NOT EXISTS
6 min
Interactive tutorialQUIZ: Subqueries
15 min
AssignmentCODING: Subqueries - I
15 min
AssignmentCODING: Subqueries - II
15 min
Start Module
4

ADVANCED ANALYTICS - PIVOT/UNPIVOT, INDEXING, ORDER OF EXECUTIONFREE PREVIEW

Pivot/unpivot, and perf basics (indexes, plans).

90 min6 lessons
Video lessonPIVOT and UNPIVOT in SQL
30 min
Video lessonSQL - Indexes (Just filter or join on indexed columns)
7 min
Video lessonOrder of Execution - Optimizing Queries
6 min
Interactive tutorialQUIZ - MODULE 4
35 min
AssignmentCODING: Pivot via Conditional Aggregation
12 min
AssignmentCODING: Optimize a Date Filter
10 min
Start Module
5

ADVANCED DATABASE CONCEPTS - STORED PROCEDURES, VIEWS, TEMP TABLESFREE PREVIEW

Stored procedures, views, temp tables

90 min9 lessons
Video lessonStored Procedures
15 min
Video lessonViews
5 min
Video lessonTemp Tables
10 min
Video lessonRecursive CTEs
15 min
ReadingFunctions, Triggers & Global Temp Tables
7 min
Interactive tutorialQUIZ: MODULE 5 - I
20 min
Interactive tutorialQUIZ: MODULE 5 - II
20 min
AssignmentCODING: FINALE - I
15 min
AssignmentCODING: FINALE - II
15 min
Start Module
Micro Free Course

Ready to Master SQL Advanced (Analytics)?

All videos, lessons, and practice exercises are 100% free with zero gatekeeping. Start learning immediately, or enroll with the ₹99 Verified Certificate Pass.

Reviews & Ratings

No reviews yet

Sign in to leave a review.