Course · SQL & Data Analytics
SQL for Data Analysis
Write SQL that answers business questions: filter, join, aggregate and check your results before they reach a report.
- Level
- Beginner
- Format
- Live online, small group
- Length
- 12 hours, 4 sessions
- Price
- $129
Price and enrolment
$129 per learner
- 4 sessions × 3 hours (12 hours)
- Live online, groups of up to 12
- Hands-on labs and course materials
- Q&A with the instructor
We confirm the next cohort dates and send an invoice. Your seat is held once payment is received. Prices in US dollars, excluding any local taxes.
Who it is for
This course is for
- Aspiring analysts
- Finance and operations analysts
- Power BI users who need stronger SQL
Syllabus
What each session covers
Session 1 · Querying
- SELECT, filtering, sorting and limiting
- CASE expressions
- Reading a relational dataset
Session 2 · Aggregation
- Aggregations, GROUP BY and HAVING
- Revenue by customer and product mix
- Control totals
Session 3 · Joins
- Inner, left and full joins
- Join validation and grain awareness
- Avoiding accidental double counting
Session 4 · Reusable analysis
- Subqueries and CTEs
- Date logic: periods and growth
- Views and preparing a query for Power BI
Hands-on labs
What you will build
- Explore a business dataset
- Join multiple business tables
- Build a customer or product analysis
- Validate totals
- Prepare a query for Power BI
Before you join
Prerequisites and setup
- Level
- Beginner
- Prerequisite
- No SQL experience needed
- Prerequisite
- Comfortable with Excel
- You need
- Laptop; we provide a practice database and setup instructions
Outcomes
After the course you should be able to
- Write clear analytical queries
- Understand table relationships
- Validate results before sharing them
Courses build practical skills. They do not promise certification passes, job placement, salary increases or expert-level mastery.
Related courses
Continue learning
Advanced SQL: Window Functions & Data Quality
The next step after the basics: window functions, ageing and retention analysis, data-quality checks and query performance.
$119 per learner
Need it built? · Datazeb Consulting
Need clean, reliable data underneath your reports?
Datazeb builds data pipelines and data-quality checks for organisations that rely on their numbers.
datazeb.com
Reserve your seat on SQL for Data Analysis
Send the short form; we confirm the next cohort dates and send an invoice.