Free masterclass · SQL · Live online
Ask your data.Get the answer.
SQL for Data Analytics: query, analyse and extract business insights
Learn to ask a database real business questions and get answers back, from your first SELECT to JOINs.
- When
- Saturday 12 December 2026
- 6:00 – 9:00 PM WAT · 3 hours
- Where
- Google Meet
- Free setup clinic from 5:00 PM WAT
Taught by Segun Umoru · Data Analytics Trainer and AI/ML Engineer
-- Which region sells most?
SELECT region, SUM(revenue) AS total
FROM orders
JOIN customers ON orders.customer_id = customers.id
GROUP BY region
ORDER BY total DESC;| region | total |
|---|---|
| Lagos | ₦21.4M |
| Abuja | ₦14.9M |
| Port Harcourt | ₦9.8M |
What you will learn
From your first SELECT to real business answers.
Beginner-friendly and hands-on. You work alongside Segun on a real business dataset, not slides.
- Explain what a relational database is.
- Understand tables, columns, records, primary keys and foreign keys.
- Retrieve data using SELECT and WHERE.
- Sort and filter records.
- Apply aggregate functions.
- Group records using GROUP BY and HAVING.
- Join related tables.
- Answer basic business questions using SQL.
The programme
Three hours, minute by minute.
Saturday 12 December 2026. All times are Lagos time (WAT).
5:00 – 6:00 PM
Free setup clinic
Optional. Help installing and opening everything you need, on the same link.
6:00 – 6:15 PM
Introduction
What is SQL? Databases and their role in analytics.
6:15 – 6:35 PM
Database fundamentals
Tables, rows, columns, keys and relationships.
6:35 – 7:05 PM
Basic SQL
SELECT, FROM, WHERE, DISTINCT, ORDER BY and TOP.
7:05 – 7:30 PM
Aggregations
COUNT, SUM, AVG, MIN and MAX.
7:30 – 7:40 PM
Break
Questions.
7:40 – 8:10 PM
Grouped analysis
GROUP BY, HAVING and CASE WHEN.
8:10 – 8:40 PM
Joining tables
INNER JOIN, LEFT JOIN and practical exercises.
8:40 – 8:55 PM
Business analysis
Revenue, customer and product analysis.
8:55 – 9:00 PM
Wrap-up
Questions and next steps.
The practical project
Retail Database Analysis
You work in a relational retail database of five tables: Customers, Products, Orders, Order Items and Regions. Together we answer the questions a business really asks.
You finish with a collection of working SQL queries, real business analysis results and a clear understanding of how relational data supports business decisions.
Questions you will answer
- 1How many customers have purchased from the business?
- 2What is the total revenue?
- 3Which products generate the highest revenue?
- 4Who are the top 6 customers?
- 5What are the monthly sales trends?
- 6Which regions generate the most orders?
- 7Which customers have never placed an order?
Before you join
What to have ready.
Not sure about something? The free setup clinic runs from 5:00 to 6:00 PM WAT, an hour before the class, on the same link.
A Windows laptop
We use SQL Server and SQL Server Management Studio (SSMS), which run on Windows. On a Mac, come to the setup clinic and we will get you onto a browser-based option.
SQL Server Express and SSMS, installed
Both are free from Microsoft. A step-by-step install guide is emailed to registered attendees about a week before. Install early, and bring questions to the setup clinic.
Google Meet and a stable connection
Join from a laptop browser. You will switch between the call and SSMS, so a second screen or a large window helps.
The database script
One script creates the retail database for you. It is emailed before the class. You run it once at the setup clinic and you are ready.
Certificate of participation
Finish, and it is yours.
Attend at least 2 of the 3 hours live and complete the practical project.
After the class we email you a personal link. Type your full name, exactly as you want it printed, and download your certificate on the spot.
Register
Reserve your free seat.
SQL for Data Analytics · Saturday 12 December 2026 · 6:00 – 9:00 PM WAT. Seats are limited so the class stays interactive. Your joining link is emailed the moment you register.
Your local time
| City | Setup clinic | Class |
|---|---|---|
| Lagos | 5:00 pm | 6:00 pm – 9:00 pm |
| London | 4:00 pm | 5:00 pm – 8:00 pm |
| Dubai | 8:00 pm | 9:00 pm – 12:00 am |
| New York | 11:00 am | 12:00 pm – 3:00 pm |
| Los Angeles | 8:00 am | 9:00 am – 12:00 pm |
Share it with someone who needs it
Questions
Good to know.
I use a Mac. Can I still join?
SQL Server Management Studio only runs on Windows. Come to the setup clinic at 5:00 PM and we will set you up with a browser-based option so you can still run every query in class.
I did not attend the Excel masterclass. Can I join the SQL one?
Yes. The two are independent. Many people do both because they fit together, but each starts from zero.
Is it really free?
Yes. Registration, the live class, the practice files and the certificate are all free. You need a laptop and a stable internet connection.
Do I need any experience?
No. Both sessions start from the beginning and are built for graduates, working professionals and career switchers who want a first real taste of data analytics.
Where does it hold, and how do I join?
Online, on Google Meet. Register and the joining link is emailed to you straight away, then repeated in the reminder emails a week before, the day before and on the morning of the class.
What is the setup clinic?
A free hour before each class, 5:00 to 6:00 PM WAT, on the same Meet link. Come early if you want help installing or opening what you need, so the three hours of class are spent learning and not troubleshooting.
Will there be a recording?
The class is taught live and the practical work is done together, so attending live is how you get the most from it. Do not plan to watch later.
How do I get the certificate?
Attend at least two of the three hours live and complete the practical project. After the class we email you a personal link. Type your full name there and download your certificate of participation straight away.
What happens if the class is full?
Seats are limited to keep the class interactive. Once the cap is reached registration closes, so register early and join a few minutes before the start.
Also free
Excel for Data Analysis, Saturday 28 November 2026
Turn a messy retail sales file into a working business dashboard, live, in three hours.
Powered by Blagetech Labs Ltd.