Courses / AI & tools

SQL & data analysis

SQL & data analysis is a free, beginner online course from Herizon.

A practical course for anyone who wants to learn SQL and data analysis from scratch. Covers querying databases, analyzing data, and presenting findings. No installation needed.

You finish with SQL and Data Analysis added to your Herizon profile.

Free · 49 min read · certificate when you pass the quiz · part of Data analyst · last updated 11 November 2026

Start this course free

Free account, about two minutes. You can join if you live in the EU, EEA, UK or Switzerland, or a partner organisation invited you.

22 members have started this course, as of November 2026.

Already have an account? Open it in the portal

A look inside the course

  • Step 1: The Nordic Mug owner asks which city orders most, and one SQL query returns Helsinki with 9 orders
  • Step 2: The first four rows of the customers table, with city marked as a column and the row of Mikko Virtanen marked as a row
  • Step 3: The three tables of the practice database: customers with 8 rows, products with 4 rows and orders with 17 rows
How page 1 starts: What is SQL and why it matters

Nordic Mug is a small web shop in Helsinki. Every order, customer and product it has sits in a database. One morning the owner, Liisa, asks: "Which city orders most?"

It takes about 49 min of reading, plus exercises, a short quiz and a practice task. It teaches SQL and Data Analysis. Pass the short quiz at the end to get a certificate.

What you will be able to do

The situation you work through

Nordic Mug, a small Helsinki web shop, keeps its customers, products and orders in one small database that every page queries.

Your practice task

Pick one business question about the Nordic Mug practice database, for example which city has the highest average items per order. Choose a question the course does not answer. Save your query as nordic-mug-question.sql with the question as a comment on the first line. Save its result as a screenshot or CSV, and add one sentence with the answer. Use the free sqliteonline.com playground and share both files as evidence.

Key topics

  1. What is SQL and why it matters
  2. Your first queries with SELECT
  3. Filtering and sorting data
  4. Aggregating data with GROUP BY
  5. Combining tables with JOIN
  6. Subqueries and nested logic

and 4 more pages

What you get when you pass

A certificate with your name, the course and the date. Sharing it is your choice. If you share it, it has a public link that anyone can open to check it, and you can add it to LinkedIn.

Common questions about SQL & data analysis

Is SQL & data analysis free?
Yes. The course is free with a Herizon account, and the account is free too.
How long does SQL & data analysis take?
It takes about 49 min of reading, plus exercises, a short quiz and a practice task. You can stop and continue later, because the portal keeps your place.
Do I get a certificate?
Yes. Pass the short quiz at the end to get a certificate you can share, for example on LinkedIn.
What do I need to start?
A free Herizon account. The course is written at beginner level.
Who can join Herizon?
You can join if you live in the EU, EEA, UK or Switzerland, or a partner organisation invited you.

Start SQL & data analysis free

Start this course free

Common questions about SQL & data analysis

Is SQL & data analysis free?
Yes. The course is free with a Herizon account, and the account is free too.
How long does SQL & data analysis take?
It takes about 49 min of reading, plus exercises, a short quiz and a practice task. You can stop and continue later, because the portal keeps your place.
Do I get a certificate?
Yes. Pass the short quiz at the end to get a certificate you can share, for example on LinkedIn.
What do I need to start?
A free Herizon account. The course is written at beginner level.
Who can join Herizon?
You can join if you live in the EU, EEA, UK or Switzerland, or a partner organisation invited you.

More in Data analyst

Sponsor this course
Start this course free
SQL & data analysis: free online course | Herizon