Premium course
MySQL
PostgreSQL
15 hours
SQL for Data Analysis
Turn raw data into actionable insights. In this course, you will learn how to build pivot tables, analyze time series, calculate retention rates, build product funnels, and segment users — all using pure SQL.
- Answer product questions in Slack in minutes, not days
- Build cohorts, funnels, and retention in pure SQL — no Python exports
- Stop hitting the GROUP BY ceiling — windows and time series handle 80% of cases
11 lessons
Certificate upon completion
This course is part of Premium — along with the other advanced courses, the AI assistant and certificates.
retention.sql
SELECT cohort, week,
round(100.0 * active / cohort_size)
AS retention -- %
FROM cohort_weeks;
W0
W1
W2
W3
W4
Jan
100
47
34
29
26
Feb
100
52
38
31
28
Mar
100
58
44
37
33
Apr
100
63
51
44
41
↗ retention is climbing — the product is getting healthier
What changes after the course
Now
After the course
Every report means an Excel export and an hour of manual work
You build pivot tables right in SQL with a single query
Retention and cohorts are something only the analyst with scripts can do
You assemble cohort analyses with window functions yourself
“What happened to the metric?” means a chat message and waiting
You compare MoM and YoY periods and explain what grew and why
Dirty data and gaps break every other report
You clean the data and fill gaps by generating date series
Course curriculum
Each lesson is short theory with runnable examples plus practice in the trainer with automatic checking.
01
About the Course: Why SQL Analytics?
Get to know the course database, understand how real-world data differs from tutorials, and prepare for business tasks.
02
Data Cleaning & String Manipulation
Learn how to prepare data using LOWER, TRIM, SPLIT_PART, REPLACE, and NULLIF.
03
Pivot Tables & Smart Aggregation
Learn how to reshape data with pivot tables and smart aggregation techniques.
04
Time Series I: Grouping & Running Totals
Round time with DATE_TRUNC, build revenue trends, and calculate running totals using window functions.
05
Period Comparison: MoM & YoY Growth
Compare metrics across time periods with Month-over-Month and Year-over-Year growth.
06
Time Series II: Smoothing & Moving Averages
Smooth charts with moving averages, define window frames (ROWS BETWEEN), and find trends in noisy data.
07
Filling Data Gaps
Handle missing data points and fill gaps in your datasets.
08
Product Funnels: Finding Bottlenecks
Build and analyze multi-step product funnels to find conversion bottlenecks.
09
Cohort Analysis: Calculating Retention Rate
Group users into cohorts and calculate retention rates over time.
10
Sessionization: Gaps and Islands Pattern
Split continuous event streams into meaningful user sessions.
11
Conclusion: Product Analyst Cheat Sheet
Wrapping up. How to combine all the tools covered in this course into a unified approach.
How the learning works
01
Read a lesson with live examples
No-fluff theory: every query in a lesson can be run and tweaked right in your browser.
02
Solve exercises on a real database
You write SQL in the trainer and your answer is automatically checked against a real database. Nothing to install.
03
Stuck? The AI mentor helps
The built-in assistant points out what's wrong with your query and nudges you towards the solution without giving it away.
Who this course is for
Product and marketing analysts
Cohorts, funnels, retention and segmentation — right in the database, with no Python exports or waiting for a data engineer.
Developers moving into data
Window functions, time series and sessionization are the missing layer between “I can SELECT” and “I can answer business questions”.
Product managers
Get the answer to “what happened to the metric” yourself in ten minutes instead of queueing for an analyst.
You'll need solid SQL basics — SELECT, JOIN, GROUP BY. If you don't have them yet, start with the free course.
A certificate you can verify
Complete all lessons and receive a personalized course certificate. Attach it to your CV or LinkedIn profile.
Your name and the course title
QR code and verification link
What learners say
Anna
After completing the course, I got promoted to data analyst. The course paid for itself in just one working day with my new salary!
Nikolay
Excellent presentation of the material! Very pleased with tasks from interviews at large IT companies.
Liza
The site is great! Tasks are interesting, UX is at a high level! Verification based on query results, not the query itself like on other sites.
One Premium — all courses at once
You're not buying a single course but the whole SQL Academy Premium: three advanced courses and every trainer feature.
FAQ
Who is this course for?
Data analysts, product managers, and developers who want to perform advanced data analysis directly in SQL without exporting data to external tools.
Do I need to install DBMS?
No, all learning takes place in the browser, so no setup is required.
Can I get a certificate for the course?
Yes, after completing every lesson in the course, you can get a personalized certificate.
Is my SQL good enough to start?
You need solid SQL basics: SELECT, JOIN, GROUP BY. Window functions and everything advanced is explained from scratch in the course.
What's included in Premium besides this course?
All advanced courses — query optimization, SQL for data analysis and database design — plus the AI assistant, interview tasks from top companies, reference solutions and certificates.
How long does access last?
6 months from the moment of payment — more than enough to complete all three advanced courses.
Log in to your account
Log in to access the course.
Log in