SQL for Analysts
Query databases confidently and extract the insights your organisation needs.
About this course
A complete SQL course designed for analysts and data professionals with no programming background. You will write queries to extract, filter, join, and aggregate data, use window functions for advanced analytics, and complete five real business analysis exercises using a provided dataset from an e-commerce company.
Target audience: Business analysts, marketing analysts, operations staff, finance professionals accessing data
What you will learn
- SQL
- Database querying
- Window functions
- CTEs
- Data analysis with SQL
Course syllabus
10 modules · video + exercises
- 1What is SQL and how databases work
- 2SELECT, FROM, WHERE: the core query
- 3Sorting and limiting results: ORDER BY and LIMIT
- 4Filtering with WHERE: operators, IN, BETWEEN, and LIKE
- 5Aggregations: COUNT, SUM, AVG, MIN, MAX, and GROUP BY
- 6HAVING: filtering aggregated results
- 7Joining tables: INNER, LEFT, RIGHT, and FULL JOIN
- 8Subqueries and CTEs (WITH)
- 9Window functions: ROW_NUMBER, RANK, LAG, LEAD, and running totals
- 10Writing business analysis queries: five real exercises
Prerequisites
- –Basic spreadsheet skills helpful
Frequently asked questions
Which database does this course use?
All exercises use PostgreSQL, which has a free browser-based environment. The SQL taught is ANSI-standard and works in BigQuery, MySQL, Snowflake, and Redshift with minor syntax adjustments.
Ready to start SQL for Analysts?
Join 9,800+ learners already enrolled. Self-paced, certificate on completion.