• Home
  • Y9
    • Unit 1 - Introduction
    • Unit 2 - Text Adventure
  • Y10
    • Term 1 >
      • Introduction
      • 1 - Solving Problems
      • 2 - IPO
      • 3 - Strings
      • 4 - Flowcharts
  • Y11
    • Coursework >
      • 1. Design of Solution
      • 2. Solution Development
      • 3. Programming Techniques
      • 4. Evaluation & Testing
      • Exemplars
      • Literacy Support
    • Theory >
      • Data Representation
      • Networks
      • SDLC
      • SQL
  • Home
  • Y9
    • Unit 1 - Introduction
    • Unit 2 - Text Adventure
  • Y10
    • Term 1 >
      • Introduction
      • 1 - Solving Problems
      • 2 - IPO
      • 3 - Strings
      • 4 - Flowcharts
  • Y11
    • Coursework >
      • 1. Design of Solution
      • 2. Solution Development
      • 3. Programming Techniques
      • 4. Evaluation & Testing
      • Exemplars
      • Literacy Support
    • Theory >
      • Data Representation
      • Networks
      • SDLC
      • SQL

SQL STATEMENTS

Picture


​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
Picture
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
Picture
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

Picture
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