SHSubjectHub

SQL: Querying, Updating & Defining Relational Databases

AQA 75174.10.4A-levelLesson packSubscription
Also online

This worksheet marks itself

Set it as homework or classwork and every answer is marked as pupils go, with feedback on what they got wrong. The scores go straight into your mark book, so you can see who needs help before the next lesson.

  • 11 questions
  • 39 marks
  • about 55 minutes
  • marked instantly

Question types: multiple choice, matching, short answer.

Try it with a class, freeHow it works

About this resource

Use SQL to retrieve, insert, update and delete data across multiple linked tables of a relational database, and to define a new table with CREATE TABLE. Covers SELECT (column list/*, WHERE with AND/OR/NOT and comparison/BETWEEN/LIKE/IN, ORDER BY, DISTINCT, aggregate functions, GROUP BY, HAVING),…

26 slides.

Lesson outline

  1. Retrieval: What You Already Know About Relational Databases
  2. Key Vocabulary
  3. Quick Check — Reading the Glossary
  4. SELECT: Retrieving Exactly What You Need
  5. We Do — SELECT with WHERE and AND
  6. Hinge Check — AND or OR?
  7. Sorting, De-duplicating and Pattern-Matching
  8. You Do — LIKE and ORDER BY
  9. Hinge Check — Which Wildcard Pattern?
  10. Summarising Data: Aggregate Functions, GROUP BY, HAVING
  11. We Do — Aggregate Functions with GROUP BY and HAVING
  12. Hinge Check — WHERE or HAVING?
Unit bundlePaper 2
Part of: Paper 2: the whole unitEvery resource in the unit in one zip.

More from 4.10 Fundamentals of databases