SQL
SQL 01 — From zero to your first analysis
- Pages
- 35 pages
- Language
- Arabic
- Format
- Version
- Version 1.0
Learn to extract, filter and aggregate data, then complete a first analysis on the Waha stores dataset.
About this guide
It starts with the question before the code, then builds the query step by step to a number you can explain and reconcile.
- Who is it for?
- For data and business analysts, and Excel and Power BI users, with no prior SQL experience.
- Scope
- Works on one table at a time and does not cover joins. Examples are written for PostgreSQL.
What you’ll learn
Where SQL fits next to Excel and Power BI, and reading a row before counting it.
Your first query: choose columns, sort the result and select a category.
Filter with WHERE, set the period precisely and handle NULL.
Aggregate with GROUP BY and HAVING, plus an orders-per-branch project.
Practice pack
Data and exercise files shared by SQL 01 and SQL 02 (ZIP).
Download the packCompanion guide
LibrarySQLComing soon
SQL 02 — From tables to decisions
Join tables, prepare the data and verify the metrics, then move from results to a decision.