Database design, normalisation and data integrity for developers

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 deck See the full outline

Try the course Preview the survey

Length: 40 min
Lessons: 6 lessons
Frequency: At onboarding
Last reviewed: 21 Oct 2026

Transactions and data integrity

What would you do?

Stock is reduced but the order row fails to save

Try it: this is one of 16 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 40 minutes
Scenario, process, timeline, accordion and quizzes

Live session deck

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

10 slides
Quiz, poll, ranking, word cloud 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.

ID	Objective	Source	Where it's covered
TO 333.0	Achieve ≥ 80% on the final assessment	-	Whole course
SO 333.1	Identify update, insert and delete anomalies in a table design and normalise it	Best practice	Whole course
SO 333.2	Choose keys and relations that keep records consistent	Best practice	Whole course
SO 333.3	Explain transactions and what can go wrong without them	Best practice	Whole course
SO 333.4	Handle errors in a stored procedure so data is never left half-written	Best practice	Whole course
SO 333.5	Decide when an index helps and when it hurts	Best practice	Whole course
SO 333.6	Describe data accuracy duties for personal data in design choices + your info	ISO/IEC 25012 data quality model; GDPR Art. 5 accuracy principle	Whole 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 40 minutes

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

ContentInteractiveVideoYou customise

A customer stored twice

3 pages

7 min

Before you beginNoteList

The duplicateTextImage

What went wrongTimelineQuiz

Keys, relations and normalisation

3 pages

7 min

KeysAccordion

Spot the anomalySorting activity

CheckFlashcardsMatching quiz

Transactions and data integrity

3 pages

7 min

ACID in plain wordsTabs

The half-done transferScenarioQuiz

ConstraintsNoteYour info

Stored procedures and error handling

3 pages

7 min

PatternProcess

Review the snippetTextMulti-select quiz

CheckQuiz

Indexes and performance

3 pages

7 min

What an index doesText

Index or not?ScenarioQuiz

Raise it earlyProcessYour infoKey fact

Design review and final assessment

2 pages

5 min

The reviewer's checklistChecklistYour info

PracticeQuizKey factNoteButtonYour info

Live deck and surveys

10 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, "bring a table you maintain

PollDo you know where each key fact is stored once?

QuizA supplier address sits in 40 rows. What anomaly risk is that? (Update anomaly ✔ · Insert · Index · Join)

ContentKeys, normal forms and one worked fix

RankingOrder a safe migration: backup, test copy, migrate, verify counts, release

QuizStock reduced but the order row failed. Best fix? (One transaction with rollback ✔)

Word cloudThe worst data bug you have met

ScaleHow confident are you reviewing a schema?

Q&AAsk the trainer anything

Content · customiseClosing {{HELP_CONTACT}}, {{COURSE_URL}}, {{SURVEY_2_URL}}

Post-course feedback: 11 questions, about 2 min

Overall rating 5 stars
Relevant, realistic, right length, helpful activities agree/disagree grid
What was most useful? multi-select
Confidence before this course, and now 1-5 scale
Confidence in keys · normalisation · transactions · procedures · indexes grid
How are schema changes reviewed today? multiple choice
Which table in your area worries you most? short text
I can say ‘this design stores a fact twice’ without feeling judged. 1-5 scale
One thing we should change or add open text
Would you recommend this course? NPS

30-day check-in

Have you used what you learned since the course? multiple choice
How confident are you today? Compare with day 1 1-5 scale
Do you know where to find the data standards and migration route? yes / no / not sure
A moment where the training helped, or where you weren't sure open text
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.

Link to the engineering standards or style guide{{ENGINEERING_STANDARDS_LINK}}
Who to ask for help or to report a concern{{HELP_CONTACT}}
Link to the change management policy{{CHANGE_MANAGEMENT_POLICY_LINK}}
Where completion is recorded{{LMS_OR_RECORD_SYSTEM}}
Link to the post-course and 30-day survey{{SURVEY_2_URL}}
Link to the self-paced course{{COURSE_URL}}

Show all 8 fields

List of approved tools and versions{{APPROVED_TOOLS}}
Link to the baseline survey{{SURVEY_1_URL}}

FAQ

Common questions

Can I run database design, normalisation and data integrity for developers 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, and before a schema review or migration project.

Who needs this training?

Developers, database administrators and data engineers; run by engineering and data platform leads with L&D.

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 automation templates →

Global

Data analysis code for analysts: Cleaning, reproducibility and responsible data collection

Analysts · Data and automation

45 min

Global

SQL for business analysts: Pulling and checking your own data

Analysts and operations · Data and automation

45 min

Global

Python for business automation and data scripts

Finance · Data and automation

45 min

Global

Scripting and automation for IT and business: Shell, powershell, bash and VBA

Sysadmins · Data and automation

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