Explore all courses
BUKIVA LEARN / COURSE

Data Analysis with SQL & Python

Why this course matters

Every 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.

Duration10 teaching weeks · 2 live classes per week · within 4 calendar months
Experience levelBeginner to Intermediate
Learning formatOnline
See what you will learn

Make room for your next skill.
Build something you can be proud of.

THE BIG PICTURE

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.

PART OF YOUR LEARNING EXPERIENCE

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.

FIND YOUR FIT

Is this course for you?

Beginners who want a first data role, professionals in finance, operations, marketing or sales who work with spreadsheets and want to move to SQL and Python, and developers who want solid analysis skills.
Your next chapter starts with you.
A LITTLE PREPARATION

Before you begin

A computer (Windows, macOS or Linux) you can install free software on, a stable internet connection and a free GitHub account. No prior coding or statistics experience is required; comfort with basic spreadsheets helps.
A strong start makes a difference.
THE CURRICULUM

Your next skill,
step by step.

See how each module moves you from the foundations towards a complete, practical project.

10course
modules
01Module 1 · Thinking Like a Data Analyst
What data analysis is for, how analysts work, and a first look at the Bazaar store data you will analyse for the whole course.
02Module 2 · SQL Querying Fundamentals
Filter, sort and summarise data with SQL — the queries analysts write every day.
03Module 3 · Combining and Shaping Data with SQL
Join tables together and reshape results with CASE, dates, subqueries and CTEs.
04Module 4 · Advanced SQL for Analysis
Window functions for rankings and trends, and SQL checks for data quality.
05Module 5 · Python Foundations for Data
The Python you need for analysis, in Jupyter notebooks, and loading Bazaar's data into pandas.
06Module 6 · Cleaning and Shaping Data with pandas
Select, filter, transform, clean and combine DataFrames — the core of everyday analysis work.
07Module 7 · Exploratory Data Analysis
Use descriptive statistics and a structured exploration process to find what's really going on in the data.
08Module 8 · Data Visualisation
Choose the right chart, build it in Python, and make it honest and easy to read.
09Module 9 · Communicating Insights
Turn analysis into recommendations people act on, and make your work reproducible and shareable.
10Module 10 · Capstone Project
Answer a real business question end to end with SQL and Python, and present your findings.
FROM CONCEPT TO CREATION

Less just knowing.
More actually building.

Put your skills into practice with the projects in this course.

  1. 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.

MAKE IT FIT YOUR LIFE

Find your
learning option.

Explore available cohorts and schedules before taking your next step.

WEEKEND COHORT · FRI–SUN

November 2026 Cohort

27 Nov 2026 – 17 Feb 2027Saturdays 10:00-13:00 and Sundays 14:00-17:002 practical sessions weekly · 3 hours each · Africa/Lagos
Choose this cohort
YOUR NEXT CHAPTER

Take the first step.

Choose your learning path. We will help you with what comes next.

Join this course