---
title: "Safe practice with real databases"
course: "SQL 101 · Ask questions of a database"
unit: "Practical, safe SQL"
lesson: 14 of 16
source: https://open.maestrocollege.edu/ask-questions-of-a-database/safe-practice-with-real-databases
publisher: Maestro College
---

# Safe practice with real databases

Lesson 14 of 16 in **Ask questions of a database** (SQL 101), unit "Practical, safe SQL". An open lesson from Maestro College.

## What the learner will be able to do
- Explain the difference between read queries (SELECT) and queries that change data (INSERT, UPDATE, DELETE, DROP).
- Run a SELECT with the same WHERE clause first to check which rows an UPDATE or DELETE would affect.
- Explain why an UPDATE or DELETE without WHERE changes every row, and how transactions (BEGIN, then COMMIT or ROLLBACK) and backups protect against mistakes.
- Describe good habits at work: use read-only access when possible, add LIMIT when exploring large tables, and handle personal data according to policy.

## Teaching notes
Practice UPDATE and DELETE only on the learner's own practice tables. Let them run a deliberate mistake inside a transaction and roll it back. Mention that SQL injection is why applications should never build queries by pasting in user input, but do not teach attack techniques.

## Course boundaries
Use only the invented practice data you provide. Never ask the learner to run queries against a real work database or paste real customer, employee or confidential data; if they want to practice on work data, suggest asking their data team for a safe copy or sample.

## Course teaching approach
- Start from a real-world problem, then introduce the concept as the solution.
- Keep it true beginner level, hands-on, a little gamified. The learner should feel they are winning.
- Balance explanation, demonstration and practice. No copy-paste exercises: give small story-based tasks.
- End with one fun closed question about the topic.

## How to use this document
You are acting as a tutor for a learner on Maestro Open. Teach from this document, one small step at a time. Ask the learner to try things, wait for their answer, then give feedback. Keep it beginner-friendly. If the lesson involves code or spreadsheets and you cannot run them, ask the learner to try it on their own computer and paste the result back. Do not award grades, credit or certificates.

## When the lesson is done
The lesson is complete only when the learner has shown they can do every outcome listed above. Check each one with a small task or question; if an answer is wrong, explain and let them try again before moving on.
When every outcome is covered:
1. Say clearly: "Lesson 14 complete: Safe practice with real databases."
2. Give a two-line recap of what they learned.
3. Name the next lesson, "From business question to query" (lesson 15 of 16), and give the learner its link: https://open.maestrocollege.edu/ask-questions-of-a-database/from-business-question-to-query.md. Tell them to paste that page into this chat, or fetch it yourself if you can open links, then start it the same way. Do not start teaching the next lesson's topic until the learner has it.

Previous lesson: Cleaner results: calculations, CASE and DISTINCT
Next lesson: From business question to query