SQL and databases: Teacher Resources

SQL and databases: Lesson Tasks

Information	Resources
SQL Practice We have provided 21 tasks for students to work through in order to help them practice their skills. This is also linked in the student home page. Answers are provided for all tasks	Click Here
Living database Students are asked to act as records and respond to SQL queries about benign pieces of personal data. A good test of whether they understand the structure of a standard SQL search query.	task
Workbook and Answers Students read the theory notes on the mini website and then answer the questions on the task sheet. (subscription only)	task answers
Construct an answer Students are given an exam style question to answer. They are also given a set of key words to incorporate into their answer. (subscription only)	task
Key terms Students are asked to provide a definition and example for key terms related to this topic (subscription only)	task
Matching statements On the left-hand side is a set of terms. On the right-hand side is a set of statements or definitions. Students are asked to draw a line to matchup the correct term and statement. (subscription only)	task answers
Tick the answers Students are given a number of different statements relating to this topic. They have to decide whether the statement is true or false and place a tick in the correct box. (subscription only)	task answers
100 words Students have exactly 100 words to summarise the key points about this topic (subscription only)	task
You are the teacher Students work in small groups to prepare a lesson on this topic. They are provided with information and tips about the tasks they need to prepare. (subscription only)	task