Topfolio
Career TracksMicro Free CoursesTask CoursesPracticeInterview PracticeWork ExperienceProjects
Career TrackBlog
Support
Micro Free Courses

SQL Advanced (Analytics)

31 lessons

  1. 1. CTE (COMMON TABLE EXPRESSION)
    1. Video lesson1. Advanced SQL Tutorial | CTE (Common Table Expression)4m
    2. Interactive tutorial2. CTE Patterns Quiz10m
    3. Assignment3. CODING: CTEs10m
  2. 2. WINDOW FUNCTIONS (ANALYTICS FOCUS)
    1. Video lesson1. Window Functions for Analysts10m
    2. Video lesson2. Window Functions - Difference between ROW_NUMBER(), RANK(), DENSE_RANK()7m
    3. Video lesson3. Window Functions - Lead & Lag10m
    4. Reading4. Bucketing with NTILE & Running Totals6m
    5. Interactive tutorial5. QUIZ: Window Functions15m
    6. Assignment6. CODING: Window Functions - I15m
    7. Assignment7. CODING - Window Functions - II15m
  3. 3. SUBQUERIES - SCALAR, CORRELATED
    1. Video lesson1. Advanced SQL Tutorial | Subqueries9m
    2. Video lesson2. Subqueries in MySQL | Intermediate MySQL10m
    3. Reading3. Correlated Subqueries & NOT EXISTS6m
    4. Interactive tutorial4. QUIZ: Subqueries15m
    5. Assignment5. CODING: Subqueries - I15m
    6. Assignment6. CODING: Subqueries - II15m
  4. 4. ADVANCED ANALYTICS - PIVOT/UNPIVOT, INDEXING, ORDER OF EXECUTION
    1. Video lesson1. PIVOT and UNPIVOT in SQL30m
    2. Video lesson2. SQL - Indexes (Just filter or join on indexed columns)7m
    3. Video lesson3. Order of Execution - Optimizing Queries6m
    4. Interactive tutorial4. QUIZ - MODULE 435m
    5. Assignment5. CODING: Pivot via Conditional Aggregation12m
    6. Assignment6. CODING: Optimize a Date Filter10m
  5. 5. ADVANCED DATABASE CONCEPTS - STORED PROCEDURES, VIEWS, TEMP TABLES
    1. Video lesson1. Stored Procedures15m
    2. Video lesson2. Views5m
    3. Video lesson3. Temp Tables10m
    4. Video lesson4. Recursive CTEs15m
    5. Reading5. Functions, Triggers & Global Temp Tables7m
    6. Interactive tutorial6. QUIZ: MODULE 5 - I20m
    7. Interactive tutorial7. QUIZ: MODULE 5 - II20m
    8. Assignment8. CODING: FINALE - I15m
    9. Assignment9. CODING: FINALE - II15m
Dashboard
Career TracksMicro Free Courses
Task Courses
SQL & PythonInterview Prep
Work ExperienceProjectsResume Feedback
CertificatesMy OrdersRefer & Earn
Join Community
Micro Free Courses

SQL Advanced (Analytics)

31 lessons

  1. 1. CTE (COMMON TABLE EXPRESSION)
    1. Video lesson1. Advanced SQL Tutorial | CTE (Common Table Expression)4m
    2. Interactive tutorial2. CTE Patterns Quiz10m
    3. Assignment3. CODING: CTEs10m
  2. 2. WINDOW FUNCTIONS (ANALYTICS FOCUS)
    1. Video lesson1. Window Functions for Analysts10m
    2. Video lesson2. Window Functions - Difference between ROW_NUMBER(), RANK(), DENSE_RANK()7m
    3. Video lesson3. Window Functions - Lead & Lag10m
    4. Reading4. Bucketing with NTILE & Running Totals6m
    5. Interactive tutorial5. QUIZ: Window Functions15m
    6. Assignment6. CODING: Window Functions - I15m
    7. Assignment7. CODING - Window Functions - II15m
  3. 3. SUBQUERIES - SCALAR, CORRELATED
    1. Video lesson1. Advanced SQL Tutorial | Subqueries9m
    2. Video lesson2. Subqueries in MySQL | Intermediate MySQL10m
    3. Reading3. Correlated Subqueries & NOT EXISTS6m
    4. Interactive tutorial4. QUIZ: Subqueries15m
    5. Assignment5. CODING: Subqueries - I15m
    6. Assignment6. CODING: Subqueries - II15m
  4. 4. ADVANCED ANALYTICS - PIVOT/UNPIVOT, INDEXING, ORDER OF EXECUTION
    1. Video lesson1. PIVOT and UNPIVOT in SQL30m
    2. Video lesson2. SQL - Indexes (Just filter or join on indexed columns)7m
    3. Video lesson3. Order of Execution - Optimizing Queries6m
    4. Interactive tutorial4. QUIZ - MODULE 435m
    5. Assignment5. CODING: Pivot via Conditional Aggregation12m
    6. Assignment6. CODING: Optimize a Date Filter10m
  5. 5. ADVANCED DATABASE CONCEPTS - STORED PROCEDURES, VIEWS, TEMP TABLES
    1. Video lesson1. Stored Procedures15m
    2. Video lesson2. Views5m
    3. Video lesson3. Temp Tables10m
    4. Video lesson4. Recursive CTEs15m
    5. Reading5. Functions, Triggers & Global Temp Tables7m
    6. Interactive tutorial6. QUIZ: MODULE 5 - I20m
    7. Interactive tutorial7. QUIZ: MODULE 5 - II20m
    8. Assignment8. CODING: FINALE - I15m
    9. Assignment9. CODING: FINALE - II15m

Browse Topfolio

All coursesPracticeProjectsCareer tracks
  1. Home/
  2. Courses/
  3. SQL Advanced (Analytics)/
  4. ADVANCED DATABASE CONCEPTS - STORED PROCEDURES, VIEWS, TEMP TABLES/
  5. Views
Back to ADVANCED DATABASE CONCEPTS - STORED PROCEDURES, VIEWS, TEMP TABLES

Views

5 minutesVideo Lesson
🎯 Free Guest Mode: You are learning for free. Sign in to save your completion progress and quiz answers.

Ready to continue?

Mark this lesson as complete when you're ready to proceed.

Previous: Stored ProceduresNext: Temp Tables
Topfolio

Learn data analytics online. Real skills, real projects, real community.

courses

  • Career Tracks
  • Work Experience
  • Best Data Analyst Course in India
  • SQL Fundamentals
  • SQL Advanced
  • Python for Data
  • Micro Free Courses

practice

  • SQL Fundamentals Interview Test
  • SQL Advanced Coding Test
  • All Practice Tests

resources

  • How to Become a Data Analyst
  • SQL Interview Questions
  • Data Analyst Salary Guide
  • Free Datasets for Practice
  • SQL vs NoSQL Guide
  • Data Analyst vs Data Engineer vs Data Scientist

employers

  • Enterprise Screening
  • AI Proctoring Demo
  • Volume Pricing
  • Employer Portal

company

  • About
  • Terms
© 2026 Topfolio. All rights reserved.Made with ❤️ for aspiring analysts