This is exceptional value as it includes my “Relational Databases and Structured Query Language (SQL)” workbook and answer book, clear instructions to walk you through installing DB Browser and two databases to practice with. This pack is perfect for students studying for the AQA GCSE (9-1) in computer science and has been updated to completely cover the new specification 8525.
It can be used in the classroom as a teaching aid, for self-study or as a revision tool. In this resource you will receive an interactive PDF workbook so your students can either print it out and complete the activities by hand or fill it in electronically making this an ideal workbook for use in school or for students studying at home. As part of that workbook it also includes gives clear, easy to follow instructions for creating an SQL database using DB Browser. It also shows how Python can be used to insert, update and delete data in the SQL database as well as retrieving specific data from the SQL database using select, from, where and order by.
A separate PDF answer booklet is provided giving you all the answers to the tasks in the workbook so you can assign your students the workbook without including the answers.
The 39-page workbook completely covers the new specification 8525 3.7 Relational Databases and Structured Query Language (SQL) section of the AQA (8525) GCSE in Computer Science.
Table of Contents:
- Explain the concepts of databases
- Relational databases
- Primary Key
- Foreign key
- ORDER BY … ASC / DESC
- INSERT INTO
- DELETE FROM
Relational databases and SQL AQA GCSE Computer Science Workbook (8525)
Digital resources purchased from Nichola Wilkin Ltd. are to be used in the original individual school which purchases the resources only.
Resources may not be shared, distributed or displayed digitally for public view, uploaded to school or borough websites, distributed via email, submitted to file sharing sites or shared with another school or institution, even those within the same academy chain.
For full terms and conditions visit https://www.nicholawilkin.com/terms