Categories
Uncategorized

SQL Practical for A-level CS

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

  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 repl.it/@mraharrison/sqlite1 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. repl.it/@mraharrison/sqlite1-solutions-1

Feedback welcome on Twitter or in the comments. Thanks.

By mraharrisoncs

Head of Computing, Manchester.

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

Leave a Reply

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

WordPress.com Logo

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

Google photo

You are commenting using your Google 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