Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

CodeSignal

Advanced SQL Analytics with an Online Shop

via CodeSignal Path

Go to class Write review

Overview

Take your SQL skills beyond the basics with hands-on analysis of online shop data. Build readable queries with CTEs, uncover revenue trends with window functions, rank customers and products, and compare orders over time with LEAD and LAG to turn transaction data into actionable insights.

Syllabus

  • Course 1: Structuring Queries with Common Table Expressions
  • Course 2: Window Functions Fundamentals
  • Course 3: SQL Ranking Functions: ROW_NUMBER, RANK, DENSE_RANK, and NTILE
  • Course 4: Comparing Rows with LEAD and LAG

Reviews

Start your review of Advanced SQL Analytics with an Online Shop

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.