​Keywords

  • SQL (sequel or S-Q-L)
  • Query
  • Criteria
  • Operator
  • Boolean
  • SELECT
  • INSERT
  • WHERE clause

Independent Tasks

Download both the superheroes database and the SQL query task sheet to your home directory (right click 'Save As'). Open the database and create a separate query for each question. Write down the full SQL statement in your books next to the question number...e.g.

1. SELECT * FROM ... 
​2. SELECT * FROM ...
Task Resources
superheroes.accdb
File Size: 479 kb
File Type: accdb
Download File
SQL Query Tasks
File Size: 237 kb
File Type: pdf
Download File
Support and Challenge
SQL using MS Access Guide
File Size: 372 kb
File Type: pdf
Download File
SQL Syntax Guide
File Size: 320 kb
File Type: pdf
Download File
Super Challenge - INSERT
File Size: 169 kb
File Type: pdf
Download File

Plenary

  1. Update the progress check section of your sheet
    ​
  2. Open the link -  http://b.socrative.com
    Room: BSCSCOMP
    ​
  3. Complete the 1 thing I will take away box on your sheet.

Staff Resources

suspects_db.pptx
File Size: 3284 kb
File Type: pptx
Download File