CatalogData Analytics
SQL for Analysts
Answer business questions with SQL you can explain: joins that mean something, filters that match the question, and a result a colleague can rerun.
- Length
- 6 weeks
- Lessons
- 22
- Exam
- 70 min
- Pass mark
- 70%
What you learn
- Read a small schema and say which tables hold the event you care about
- Filter, aggregate, and join without double-counting
- Write queries for cohorts, funnels, and simple retention
- Leave a query readable: names, comments, and a stated grain
What the exam covers
- Write queries against a provided shop schema
- Explain why a join inflated an order count
- State the grain of your final result in one sentence
Certificate
Certificate in Analytical SQL
Awarded by Skillvane when you pass. It can help you get hired. It is not a government accreditation and it does not promise employment.
Jobs this prepares you for
- Data analyst
- Reporting analyst
- Business intelligence associate
These are the kinds of roles where the skill is used. Passing does not guarantee an interview or an offer.
Before you enrol
More in Data Analytics
Data Analytics
Dashboard Storytelling
Design a dashboard that answers one decision, with the number, the comparison, and the caveat a reader needs in the same view.
- 16 lessons
- 5 weeks
- Certificate
€135
Exam + 1 retake included
Data Analytics
Data Analyst Career Track
A career path through questions, spreadsheets, SQL, and a dashboard, ending in an exam that asks you to answer one business question in public.
- 48 lessons
- 14 weeks
- Certificate
€249
Exam + 1 retake included
Data Analytics
Professional Analytics Program
The academy's long analytics program: from a raw export to a decision memo, with a capstone exam marked against a published rubric.
- 78 lessons
- 24 weeks
- Certificate
€500
Exam + 1 retake included