Course · SQL & Data Analytics
Advanced SQL: Window Functions & Data Quality
The next step after the basics: window functions, ageing and retention analysis, data-quality checks and query performance.
- Level
- Intermediate
- Format
- Live online, small group
- Length
- 9 hours, 3 sessions
- Price
- $119
Price and enrolment
$119 per learner
- 3 sessions × 3 hours (9 hours)
- Live online, groups of up to 12
- Hands-on labs and course materials
- Q&A with the instructor
We confirm the next cohort dates and send an invoice. Your seat is held once payment is received. Prices in US dollars, excluding any local taxes.
Who it is for
This course is for
- BI professionals and analysts who already write SQL
- Data professionals strengthening fundamentals
Syllabus
What each session covers
Session 1 · Window functions
- Ranking, running totals and moving averages
- Period-over-period comparison
- Retention and ageing analysis
Session 2 · Data quality
- Duplicate detection and null handling
- Unexpected values and control totals
- Reusable data-quality checks
Session 3 · Performance basics
- How queries are executed
- Indexes and sargable filters
- Writing queries that scale
Hands-on labs
What you will build
- Build a retention analysis
- Write a data-quality check suite
- Speed up a slow query
Before you join
Prerequisites and setup
- Level
- Intermediate
- Prerequisite
- SQL for Data Analysis or equivalent
- You need
- Practice database provided
Outcomes
After the course you should be able to
- Use window functions confidently
- Catch data problems before reporting
- Write faster queries
Courses build practical skills. They do not promise certification passes, job placement, salary increases or expert-level mastery.
Related courses
Continue learning
SQL for Data Analysis
Write SQL that answers business questions: filter, join, aggregate and check your results before they reach a report.
$129 per learner
Need it built? · Datazeb Consulting
Need clean, reliable data underneath your reports?
Datazeb builds data pipelines and data-quality checks for organisations that rely on their numbers.
datazeb.com
Reserve your seat on Advanced SQL: Window Functions & Data Quality
Send the short form; we confirm the next cohort dates and send an invoice.