Data Analysis with SQL & Python
Why this course mattersEvery business runs on data, and the people who can turn it into clear answers are in demand everywhere. This course teaches you to query databases with SQL, clean and analyse data with Python and pandas, build honest charts, and present recommendations people act on — no prior coding experience required.
Make room for your next skill.
Build something you can be proud of.
Learn it.
Put it to work.
You will work as the analyst for Bazaar, an online store, from the first class to the last. Every lesson asks a real business question about the same sales database — which products sell, which customers come back, whether a discount worked — so your skills build on each other into one complete portfolio project.
The first half teaches SQL from first principles: filtering, sorting, aggregating, joining tables, subqueries, CTEs and window functions. The second half moves into Python: pandas for cleaning and reshaping data, exploratory analysis and descriptive statistics, and charts with matplotlib and seaborn.
The course finishes with communication — KPIs, data stories, reproducible notebooks and a GitHub portfolio — and a capstone where you answer a business question end to end and present your recommendation.
What's included
- 20 live, guided classes across 10 modules
SQL from first principles through window functions, then Python, pandas, statistics, charts and communication.
- One continuing project on real-shaped data
Every class analyses the same Bazaar online store database, so you finish with one complete portfolio project.
- AI-assisted analysis woven into the curriculum
Guided practice using AI tools to write, explain and check queries and code, always verified against your own results.
- A focused quiz after every class
Every live class ends with a focused knowledge check, with a 70% pass mark and up to three attempts.
- One focused assessment each teaching week
Each weekly milestone contains three clear tasks: do the analysis, show your checks, and submit it with a short reflection.
- A certificate of completion
Awarded once all classes, quizzes and assignments are complete and reviewed.
AI tools are part of how analysts work today, and this course teaches you to use them well: asking AI to draft or explain a SQL query, suggest pandas code, interpret a statistic or improve a chart — then checking every answer against the data yourself with row counts, totals and sanity checks, so you never present a number you can't stand behind.
Before you begin
Your next skill,
step by step.
See how each module moves you from the foundations towards a complete, practical project.
modules
01Module 1 · Thinking Like a Data Analyst
02Module 2 · SQL Querying Fundamentals
03Module 3 · Combining and Shaping Data with SQL
04Module 4 · Advanced SQL for Analysis
05Module 5 · Python Foundations for Data
06Module 6 · Cleaning and Shaping Data with pandas
07Module 7 · Exploratory Data Analysis
08Module 8 · Data Visualisation
09Module 9 · Communicating Insights
10Module 10 · Capstone Project
Less just knowing.
More actually building.
Put your skills into practice with the projects in this course.
By the end of the course you will have a portfolio of real analysis work on the Bazaar store data: a SQL query library, a cleaned and merged pandas dataset, an exploratory analysis with customer segments and retention, a chart dashboard notebook, a one-page data story for managers, and a capstone analysis published on GitHub.
Take the first step.
Choose your learning path. We will help you with what comes next.

