Learning path · Beginner

Data Foundations

Ask precise questions of real data.

Combine SQL and Python to clean, query and summarise data. Designed for analysts, operators and anyone who works with spreadsheets that have outgrown them.

6 weeks 2 courses 32 lessons 2 certificates

Start this path Browse tutorials

The sequence

2 courses, in the right order.

Each step assumes only what came before it. Follow the sequence or jump to a course you need.

Step 1 · Beginner

SQL & Databases

Open course

Learn to query, filter, join, summarise and reshape relational data with NULL handling, CASE, CTEs, window functions, indexes and safe writes. Every lesson runs against a realistic learning-platform database.

Querying dataDatabase skills from the startRelating and summarisingReshaping resultsComposing queriesData in practiceProject

0/16 lessons0%

SQL Fundamentals

Step 2 · Beginner

Python Foundations

Open course

Learn programming fundamentals with Python — variables, control flow, functions, collections, classes, files, tests and packaging — then ship a small project you can extend.

First stepsPython from zeroStructure your codeShape the dataBuild real programsQuality and deliveryShip it

0/16 lessons0%

Python Foundations

Portfolio project

Sales insight report

Answer a real business question with SQL and a short Python summary.

about 5 hours Portfolio piece

The brief

Use a sample orders database to report monthly revenue, top categories and repeat customers. Export the result to CSV, then use Python to validate and summarise it.

DeliverableSQL queries, a CSV export and a one-page summary of the findings.

Stretch goals

Add a monthly running total with a window function.
Produce a simple chart from the exported data.

Acceptance criteria

0/6

Uses joins, WHERE and GROUP BY to shape the data.
Uses a CTE or subquery for at least one intermediate result.
Handles missing or NULL values explicitly.
Exports the result to CSV and documents the query.
Python loads the CSV and prints totals that match the SQL.
The summary states assumptions and one limitation.

Path complete

Finish with proof, not just a folder of files.

Complete every course in this path to collect 2 verifiable certificates. Each one has a unique public ID and a QR code that resolves to a live status record.

How certification works Verify a credential

Data Foundations32 lessons · 7 hours

SQL & DatabasesPython Foundations

Other paths

All paths

01Most popular

Learning path

Frontend Developer

The complete starting point for a career in the browser. Build structure with HTML, shape it with CSS and make it react with JavaScript — then prove it with a certificate.

Portfolio project included

3 courses

8 weeks Certificate included

02Beginner

Learning path

Python from Zero

Learn to think in programs. Start with values and logic, build up to functions and files, and finish with an automation script that saves real time.

Portfolio project included

1 course

5 weeks Certificate included

03Intermediate

Learning path

Web Professional

Add version control and collaboration to your frontend skills. Learn the workflow real teams use: branches, meaningful commits, pull requests and clean merges.

Portfolio project included

4 courses

4 weeks Certificate included