SQL_revision_BN23

SQL

OCR J277 GCSE

1 I can understand database terminology

2 I can use the 3 SQL keywords

3 I can answer exam-style questions on SQL

goals

Multiple Choice

What is a database?

• the basic way of storing data types

• algorithmic thinking, using a flowchart and pseudocode to help design sub-programs

• a means for programmers to maintain code using defensive design

• a computational system where data is stored and organised for quick access

Open Ended

record

field

table

In clear full-sentences, use the three technical terms above to describe how you think data is arranged in a database.

parent company	​name	​score
​Microsoft	​Bing	​9.0
​OpenAI	​ChatGPT	​9.2
​Meta	​LLaMA	​5.0
​Google	​Bard	​5.5

​<- record

​<- field

​table

data arranged in a database

Open Ended

Improve your first description of how data is arranged in a database.

Remember to use the 3 technical terms we saw before.

Challenge: could you use 'data item' too?

Multiple Choice

In a database, what is a field?

• a category, like a column header

• a single instance or entry

• a 2D arrangement of data, like an organised list

Multiple Choice

In a database, what is a table?

• a category, like a column header

• a single instance or entry

• a 2D arrangement of data, like an organised list

Multiple Choice

In a database, what is a record?

• a category, like a column header

• a single instance or entry

• a 2D arrangement of data, like an organised list

1 I can understand database terminology

2 I can use the 3 SQL keywords

3 I can answer exam-style questions on SQL

goals

parent company	​name	​score
​Microsoft	​Bing	​9.0
​OpenAI	​ChatGPT	​9.2
​Meta	​LLaMA	​5.0
​Google	​Bard	​5.5

​<- record

​<- field

​table

​create your own database table about something that interests you

use exactly 3 fields

as many records as you like

can you find real data items?

1 I can understand database terminology

2 I can use the 3 SQL keywords

3 I can answer exam-style questions on SQL

goals

1 I can understand database terminology

2 I can use the 3 SQL keywords

3 I can answer exam-style questions on SQL

goals

Multiple Choice

what is the FROM keyword for...?

• specifies the condition or criteria that results must meet

• identifies the field or fields the results can come from

• identifies the table or tables the results can come from

• any and all results are returned

Multiple Choice

what is the SELECT keyword for...?

• specifies the condition or criteria that results must meet

• identifies the field or fields the results can come from

• identifies the table or tables the results can come from

• any and all results are returned

Multiple Choice

what is the WHERE keyword for...?

• specifies the condition or criteria that results must meet

• identifies the field or fields the results can come from

• identifies the table or tables the results can come from

• any and all results are returned

Multiple Choice

what is the * (wildcard) for...?

• specifies the condition or criteria that results must meet

• identifies the field or fields the results can come from

• identifies the table or tables the results can come from

• any and all results are returned

​Recreate this worked example but in a more visual or graphical way

Open Ended

In full-sentences, write a clear guide for how to compose SQL commands using SELECT, FROM, and WHERE.

Challenge: Additionally explain the wildcard character and suggest how nested commands would work.

1 I can understand database terminology

2 I can use the 3 SQL keywords

3 I can answer exam-style questions on SQL

goals

​https://www.youtube.com/watch?v=c8yHTlrs9EA - SQLite

https://youtu.be/zrEF1jeMwS8 - revision

Open Ended

1 I can understand database terminology

2 I can use the 3 SQL keywords

3 I can answer exam-style questions on SQL

goals