SQL Exercise Site:

This exercise is voluntary. It will allow you to familiarize yourself with SQL, and to utilize a database by formulating simple SQL queries. The database consists of two tables:

  1. One for students. You can provide fictional information for this.
  2. One for "favourites:" this can be for CD's, books, or both.

This activity consists of three steps. You can complete these steps as many times as you like. You must complete the first two steps in order at least once.

  1. Add your name to the database. This involves a basic insert query.
  2. From there, you should add two of your favourite books or CDs to the database. This involves two more basic insert queries.
  3. Query the database using two forms to find out about everyone in the database thus far, and their favourite CDs and books. You can repeat this step as many times as you like (after completing steps 1 & 2 at least once).

Here is a diagram of the two tables in the database: