Skip to content
Segun UmoruSEGUN UMORU

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;
regiontotal
Lagos₦21.4M
Abuja₦14.9M
Port Harcourt₦9.8M
Sample · you write queries like this live

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).

  1. 5:00 – 6:00 PM

    Free setup clinic

    Optional. Help installing and opening everything you need, on the same link.

  2. 6:00 – 6:15 PM

    Introduction

    What is SQL? Databases and their role in analytics.

  3. 6:15 – 6:35 PM

    Database fundamentals

    Tables, rows, columns, keys and relationships.

  4. 6:35 – 7:05 PM

    Basic SQL

    SELECT, FROM, WHERE, DISTINCT, ORDER BY and TOP.

  5. 7:05 – 7:30 PM

    Aggregations

    COUNT, SUM, AVG, MIN and MAX.

  6. 7:30 – 7:40 PM

    Break

    Questions.

  7. 7:40 – 8:10 PM

    Grouped analysis

    GROUP BY, HAVING and CASE WHEN.

  8. 8:10 – 8:40 PM

    Joining tables

    INNER JOIN, LEFT JOIN and practical exercises.

  9. 8:40 – 8:55 PM

    Business analysis

    Revenue, customer and product analysis.

  10. 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

  1. 1How many customers have purchased from the business?
  2. 2What is the total revenue?
  3. 3Which products generate the highest revenue?
  4. 4Who are the top 6 customers?
  5. 5What are the monthly sales trends?
  6. 6Which regions generate the most orders?
  7. 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

Class and setup clinic start times in five cities
CitySetup clinicClass
Lagos5:00 pm6:00 pm – 9:00 pm
London4:00 pm5:00 pm – 8:00 pm
Dubai8:00 pm9:00 pm – 12:00 am
New York11:00 am12:00 pm – 3:00 pm
Los Angeles8:00 am9:00 am – 12:00 pm

Share it with someone who needs it

Free, live, online

Reserve your seat

FREE

Your confirmation and joining details are sent to your email. No spam.

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.