SQL for Data Analysts
Ask the database directly: filtering, grouping, joins and window functions.

Taught by Dr Reem Al-Hinai
What you will learn
- Write SELECT queries with filters and sorting
- Aggregate with GROUP BY and HAVING
- Combine tables with the different JOINs
- Compute rankings and running totals with window functions
About this course
When data outgrows Excel, SQL becomes your main tool. We work on a sample shop database and answer real business questions with clear queries.
Before you start
- Comfort with tables (for example Excel)
Syllabus
3 sections · 6 lessons · 1 h 3 min
First queries2 lessons · 19 min
- SELECT and WHEREFree preview10 min
- Missing values (NULL)9 min
Aggregation2 lessons · 19 min
- GROUP BY11 min
- HAVING8 min
Joins and windows2 lessons · 25 min
- INNER and LEFT JOIN12 min
- Window functions13 min
- SQL quiz4 questions
Your instructor

Data scientist and analytics lecturer · 3 courses
Reem holds a PhD in applied statistics and has led analytics teams in banking and healthcare. She loves turning complex numbers into clear stories, and teaching analysts when to doubt their own results.
Questions
Which database do we use?
SQLite and PostgreSQL; the syntax is close across most systems.
How long do I keep access?
The course stays in your account with no time limit, including any updates to its lessons.
How do I get the certificate?
When you finish every lesson and pass the required quizzes, issue it from the course page. It carries a code anyone can verify.
Can I get a refund?
Yes, within 14 days of purchase if you have completed less than 20% of the lessons. Contact us from the messages page.
Reviews
No reviews yet. Enrolled learners can write the first one.