SQL Beginner Workbook PDF, SQLite Database and 18 Query Examples

SQL Data Detective Lab — Ask useful questions. Run SQL. Check the results.

Learn SELECT, filters, joins, grouping and dates by answering questions about a fictional tool library. Run the exact examples, try a variation, then check the output.

WHO IT IS FOR
Teens and adult beginners. Choose the guided, independent or challenge route to match the learner or project.

WHAT YOU RECEIVE
• One 29-page A4 PDF
• One 29-page US Letter PDF
• START_HERE download and printing guide
• Companion ZIP: a fictional SQLite database, setup.sql, 18 worked queries, practice answer queries, expected results, README and a read-only Python 3 runner. Choose a SQLite-compatible tool or Python 3; third-party software is not included.

Both PDF editions contain the same content. The page count includes the cover, instructions, contents and closing reference/licence page.

INSIDE THE WORKBOOK
• Your tool-library dataset
• Open the practice files
• Read the schema and the grain
• 01 Choose useful columns
• 02 Filter a category
• 03 Combine two conditions
• 04 Choose from a short list
• 05 Match part of a name
• 06 Order and limit results
• 07 Find missing return dates
• 08 Count rows deliberately
• 09 Join loans to members
• 10 Join all three tables
• 11 Group by borrower
• 12 Filter groups with HAVING
• 13 Keep tools with no loans
• 14 Calculate completed durations
• 15 Average the completed durations
• 16 Use an explicit date window
• 17 Summarise by tool category
• 18 Answer a combined question
• Independent mini-project
• Practice answers: 1–9
• Practice answers: 10–18
• Project solutions and next steps

THREE WAYS TO USE IT
Start: Read the result tables and explain what each query asks.
Build: Run all 18 examples and complete the practice variations.
Stretch: Write the independent report and check its limitations.

MATERIALS AND REQUIREMENTS
A computer with a SQLite-compatible tool, or Python 3 for the included standard-library runner. Software is not included. The companion ZIP contains the database, setup script, query files, expected results and runner.

DOWNLOAD AND PRINT
After Etsy confirms payment, use Etsy in a web browser and open Purchases and reviews to download. The Etsy app does not currently support digital downloads. Guest buyers should use the download link in their Etsy receipt email. Save the files before opening them; extract any ZIP first. Message PDF Worx through Etsy if you need file help.
Choose A4 or US Letter, then print at 100% / Actual size. Check one page first. These are fixed-layout printable PDFs with no fillable fields. They are not editable Canva templates. You can annotate them in your own compatible PDF app.

PLEASE NOTE
Digital download only; no physical item is shipped. Work on the supplied fictional data, not a live database. The included runner opens the database read-only. Do not put private data or credentials into practice files.
Original PDF Worx writing, exercises and layouts with AI-assisted decorative artwork. Listing previews show actual pages; the cover illustration is decorative, not a promised finished result.

USE LICENCE
One purchaser may print and reuse pages in their household, one classroom they teach, or their own business as a working tool. Supplied files and blank page designs may not be shared, uploaded, redistributed or resold. Original work you create with the exercises remains yours.

MORE FROM PDF WORX
Browse the Computers & Coding section for related practical workbooks. Choose a single resource that fits your next project, and reuse the recording pages as needed.