Global

SQL and database fundamentals for business users

A ready-made course you customise for your organisation, with a live session deck and two surveys. You only add the 8 details that are specific to your organisation.

See the live deckSee the full outline
Try the coursePreview the survey
Length
45 min
Lessons
6 lessons
Frequency
At onboarding for analyst, operations and product roles
Last reviewed
21 Oct 2026
Reading and checking a query result: grey areas
What would you do?

A joined query returns an order total larger than finance expects

Try it: this is one of 22 interactive activities in the course.

What's included

Three pieces that work together

Copy once, get everything. Learners prepare on their own, you answer questions live, and the surveys tell you what stuck.

Self-paced course

Short lessons with real workplace scenarios, not walls of text.

  • 6 lessons, about 45 minutes
  • Process, scenario, sorting activity, flashcards and quizzes

Live session deck

An AhaSlides presentation to run after the course, in person or online.

  • 11 slides
  • Quiz, poll, scale, open-ended slides
  • A closing slide for your contacts

Two surveys

Find out what landed, and whether people use it on the job.

  • Post-course feedback, about 2 minutes
  • 30-day check-in
  • Anonymous by default
  • Results feed your next refresher

Learning objectives

At the end of this course, learners can

Each objective and the lesson that covers it.

IDObjectiveSourceWhere it's covered
TO 188.0Achieve ≥ 80% on the final assessmentnoneWhole course
SO 188.1Describe tables, rows, columns and keys, and how related tables are designedBest practiceWhole course
SO 188.2Read and predict the result of a basic SELECT query with WHERE and ORDER BYBest practice; ISO/IEC 9075 (SQL) as a reference onlyWhole course
SO 188.3Explain how a join combines two tables and what happens to rows with no matchBest practiceWhole course
SO 188.4Read a grouped query that counts or adds up valuesBest practiceWhole course
SO 188.5Check a query result before using it, and ask the data owner for access or changes in the right way + your infoOrganisation's data policyWhole course

Your part: what a template can't do for you

  • Your workplace details: fill in the 8 highlighted fields so the course describes your own policies, contacts and locations.
  • Records: record completion in your own LMS or record system.

Course outline

6 lessons, about 45 minutes

Minutes per lesson are an estimate, shared out by page count.

ContentInteractiveVideoYou customise
1

Why databases matter: tables, rows, columns, keys and tidy design

3 pages

9 min
Before you beginNoteList
An invented storyTextImage
Anatomy of a tableTabsSorting activityKey factQuiz
2

SELECT, WHERE and ORDER BY: predict the result

3 pages

9 min
The three building blocksProcessText
Predict the rowsTableTicketsSorting activity
Match the clause and its jobMatching quizFlashcardsQuiz
3

Joining tables, grouping and adding up

3 pages

9 min
What a join doesTimelineTextCustomersOrders
Count the rowsQuizAccordion
GroupingProcessFlashcardsMulti-select quiz
4

Reading and checking a query result: grey areas

3 pages

9 min
ScenarioScenario
ScenarioScenario
ScenarioScenarioChecklistMatching quiz
5

Asking for data and where to get help

2 pages

6 min
A good data requestAccordion
Who to askProcessYour infoYour infoYour infoYour infoQuiz
6

Final assessment

1 page

3 min
PracticeQuizKey factNoteButtonYour info

Live deck and surveys

11 slides to run live, two surveys to close the loop

Pink slides are interactive. Both surveys are anonymous; pink questions are written for this course.

ContentTitle, agenda, "invented sample tables; nothing is run on a real system
PollHow do you get data today?
ContentThe sample tickets, customers and orders tables, with one query read aloud
QuizSELECT COUNT(*) FROM tickets WHERE status = 'Open'; returns… (4 ✔)
QuizWhich clause chooses the rows? (WHERE ✔)
QuizA colleague sends a DELETE query to run on the live database. You… (Do not run it; ask the data owner ✔)
Content · customiseCustomise: how we ask for data {{DATA_REQUEST_ROUTE}}, who owns it {{DATA_OWNER_CONTACT}}
ScaleHow confident are you reading a SELECT query?
Open-endedA question I would like to ask our data
Q&AAsk the trainer anything
Content · customiseClosing {{DATA_OWNER_CONTACT}}, {{IT_HELPDESK_CONTACT}}, {{COURSE_URL}}, {{SURVEY_1_URL}}, {{SURVEY_2_URL}}
Post-course feedback: 11 questions, about 2 min
  1. Overall rating 5 stars
  2. Relevant, realistic, right length, helpful activities agree/disagree grid
  3. What was most useful? multi-select
  4. Confidence before this course, and now 1-5 scale
  5. How many queries have you run or reviewed since the course? multiple choice
  6. What check did you add before trusting a result? short text
  7. How confident are you explaining what a join does? 1-5 scale
  8. I would tell the data team about a result that looks wrong without worrying. 1-5 scale
  9. One thing we should change or add open text
  10. Would you recommend this course? NPS
30-day check-in
  1. Have you used what you learned since the course? multiple choice
  2. How confident are you today? Compare with day 1 1-5 scale
  3. Do you know where to find the data owner and the data request route? yes / no / not sure
  4. A moment where the training helped, or where you weren't sure open text
  5. Which topics should the next refresher focus on? ranking

Results show whether people use the training on the job, not just whether they finished it.

Make it yours

8 fields to fill in, and you're ready

Everything else is done. These are the details only your organisation knows; each one is highlighted inside the course.

  • Data owner contact{{DATA_OWNER_CONTACT}}
  • Data request route{{DATA_REQUEST_ROUTE}}
  • Data classification policy link{{DATA_CLASSIFICATION_POLICY_LINK}}
  • It helpdesk contact{{IT_HELPDESK_CONTACT}}
  • LMS or record system{{LMS_OR_RECORD_SYSTEM}}
  • Course URL{{COURSE_URL}}
Show all 8 fields
  • Survey 1 URL{{SURVEY_1_URL}}
  • Survey 2 URL{{SURVEY_2_URL}}

FAQ

Common questions

Can I run SQL and database fundamentals for business users training online?

Yes. The course is self-paced and online, and the live deck lets you add a live session in the room or online.

How often is this training needed?

At onboarding for analyst, operations and product roles, or before a team gets read-only access to a reporting database.

Who needs this training?

Analysts, operations and product staff who query or request data; run by L&D with data and analytics leads.

What records should I keep?

Record completion in your own LMS or record system, so you can show who finished the course and when.

Can I edit the content?

Yes, everything. Change the wording, swap scenarios for ones from your workplace, add your logo, or remove parts that don't apply.

Related templates

Often taught together

All Data and analytics templates →
Global

Power BI and data visualisation for business users

Analysts and managers · Data and analytics

45 min
Global

Data literacy: Reading, cleaning and questioning data

Non-analyst staff · Data and analytics

40 min
Last reviewed: 21 October 2026Templates are a starting point, not legal advice.

Ready to run it?

Open the live deck to see how the session runs alongside the course and both surveys.

See the live deck