That Blue Square Thing

Computer Science GCSE

A record, but not in a database

Exercises Using SQL

SQL (Structured Query Language) needs some work if you're going to get good enough at it. Here are some exercises to help with that.

The SQL interpretor at Tutorials Pointwiki link will probably be useful for working on coding.

You might also find the tutorials are the W3C Schoolwiki link helpful. You can delve a little deeper into individual commands there and there is a database set up for you to experiment with SELECT commands. You can't use CREATE TANBLE though so you're stuck with their database.

There are some tutorials at SQL Zoowiki link as well which might be helpful. Be aware that some of the stuff on both of these tutorial sites deals with the stuff on the Complex SQL page and some goes beyond what you need to know.

Don't forget - you need to be able to read and write SQL by hand in an exam. It's really useful to be able to write code in an interpretor as well, but don't ignore the importance of hand coding.

The Zoo Database

This set of simple SQL exercises uses a version of my Zoo database. It focuses on understanding the results you should get from SELECT commands.

PDF iconThe Zoo Database Exercises sheet. It might be easier to print this.

Text file iconCode to create the zoo database. You can copy and paste this into the SQL interpretor at Tutorials Pointwiki link to create the database and then try out the commands from the exercises.

Don't forget - once you've created the table in the interpretor you can delete the code - otherwise every time you execute the code it will try to create the table again and will add the same records to your database!

The Simple Food Wholesaler Database

The database here is for a food wholesaler which buys in products from a number of different suppliers. In this case you're asked to write SQL commands.

PDF iconThe Food Wholesaler Exercises sheet. Again, it might be easier to print it.

Once you've answered the questions it would probably be helpful to check that your answers work in the SQL interpretor at Tutorials Pointwiki link.

Text file iconCode to create the Simple Food Wholesaler database. This will allow you to create the whole database without having to spend ages writing INSERT INTO commands.

The Product Code field is particularly important in this database. That's the first thing that's dealt with on the Complex SQL page.

Birds database example question

This is a simple, exam style database question. It includes some wider knowledge rather than simply SQL and databases. That's exactly what they do in exams.

PDF iconThe Bird Database Exam Question sheet. Print it and work on it.