SQL & data analysis
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.
49 min · 10 pages · practice task · quiz · part of Data analyst
Sponsor this courseWhat you will be able to do
Skills you add to your Herizon profile when you finish: SQL, Data Analysis.
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 customers have never bought a Home product. 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.
What is inside
- What is SQL and why it matters
- Your first queries with SELECT
- Filtering and sorting data
- Aggregating data with GROUP BY
- Combining tables with JOIN
- Subqueries and nested logic
and 4 more pages
Finish with a short quiz to earn your certificate.
More in Data analyst
- Data analytics fundamentals41 min · 11 pages
- Excel for office and data jobs30 min · 12 pages
- Python for beginners53 min · 11 pages
- Desk research that actually informs decisions28 min · 11 pages
- Machine learning fundamentals36 min · 11 pages
- Power BI basics for data roles27 min · 12 pages