intermediate

Advanced SQL Analytics with an Online Shop

Data Science & Analytics

Trusted by learners working at top companies

Turn screen time into skills time

Practice anytime, anywhere with our mobile app.

Join the 1M+ learners on CodeSignal

Be a part of our community of 1M+ users who develop and demonstrate their skills on CodeSignal

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.

See courses

Learn to replace nested subqueries with named CTEs, compose multi-step query pipelines, stage order and customer revenue aggregations, and generate a recursive month spine. By the end, you can make complex online-shop analysis clearer and easier to extend.

Course 2

Window Functions Fundamentals

4 lessons

12 practices

Learn to calculate analytics without collapsing detail rows, partition results by business groups, track cumulative revenue over time, and compute three-month moving averages. By the end, you can combine CTEs with foundational window functions for online-shop reporting.

See details

Course 3

SQL Ranking Functions: ROW_NUMBER, RANK, DENSE_RANK, and NTILE

4 lessons

12 practices

Learn to select one row per entity, compare ranking functions when values tie, find top-selling products within each category, and segment customers into spend quartiles. By the end, you can use window-based rankings to solve common online-shop reporting problems.

See details

Course 4

Comparing Rows with LEAD and LAG

4 lessons

12 practices

Learn to compare each order with neighboring rows, identify long purchase gaps, calculate month-over-month gross order-value growth, and analyze order-value trends within customer cohorts. By the end, you can combine CTEs with LAG and LEAD for time-based shop analysis.

See details

From our community

Hear what our customers have to say about CodeSignal Learn

I'm impressed by the quality and can't stop recommending it. It's also a lot of fun!

Francisco Aguilar Meléndez

Data Scientist

+11

I love that it's personalized. When I'm stuck, I don't have to hope my Google searches come out successful. The AI mentor Cosmo knows exactly what I need.

Faith Yim

Software Engineer

+14

It's an amazing product and exceeded my expectations, helping me prepare for my job interviews. Hands-on learning requires you to actually know what you are doing.

Alex Bush

Full Stack Engineer

I'm really impressed by the AI tutor Cosmo's feedback about my code. It's honestly kind of insane to me that it's so targeted and specific.

Abbey Helterbran

Tech consultant

I tried Leetcode but it was too disorganized. CodeSignal covers all the topics I'm interested in and is way more structured.

Jonathan Miller

Senior Machine Learning Engineer

+12

I'm impressed by the quality and can't stop recommending it. It's also a lot of fun!

Francisco Aguilar Meléndez

Data Scientist

+11

From our community

Hear what our customers have to say about CodeSignal Learn

I'm impressed by the quality and can't stop recommending it. It's also a lot of fun!

Francisco Aguilar Meléndez

Data Scientist

+11

I love that it's personalized. When I'm stuck, I don't have to hope my Google searches come out successful. The AI mentor Cosmo knows exactly what I need.

Faith Yim

Software Engineer

+14

It's an amazing product and exceeded my expectations, helping me prepare for my job interviews. Hands-on learning requires you to actually know what you are doing.

Alex Bush

Full Stack Engineer

I'm really impressed by the AI tutor Cosmo's feedback about my code. It's honestly kind of insane to me that it's so targeted and specific.

Abbey Helterbran

Tech consultant

I tried Leetcode but it was too disorganized. CodeSignal covers all the topics I'm interested in and is way more structured.

Jonathan Miller

Senior Machine Learning Engineer

+12

I'm impressed by the quality and can't stop recommending it. It's also a lot of fun!

Francisco Aguilar Meléndez

Data Scientist

+11

Advanced SQL Analytics with an Online Shop

Trusted by learners working at top companies

Turn screen time into skills time

Join the 1M+ learners on CodeSignal

Certificate of Achievement

Verified skills you'll gain

From our community

Other paths you may like

From our community