SQL Practical for A-level CS

Teaching the Databases topic to an A-level class, I have made these tasks and suggested solutions in

  1. First teach the basics of SQL e.g. using Craig n Dave’s video here: OCR A-level SQL
  2. Check for understanding of the basics e.g. by asking a few basic SQL query questions, using a quick quiz like this: W3Schools SQL Quiz or better still, use the premium resources from Craig n Dave that are intended to follow the above video lesson.
  3. Share the skeleton code here with the students. Explain the code. (Needs you to be familiar with it, so read through it and try it out first!).
  4. Optionally walk through the first one or two problems and code the solution live with them.
  5. Assign as homework, or continue as a lesson, whatever you are more comfortable with.
  6. Use the suggested solutions here when stuck, or share this with the students after they have attempted the problems.

Feedback welcome on Twitter or in the comments. Thanks.


By mraharrisoncs

Freelance consultant, teacher and author, professional development lead for the NCCE, CAS Master Teacher, Computer Science lecturer.

One reply on “SQL Practical for A-level CS”

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s