Skip to content
Oak National Academy
Oak National Academy
Teachers
Pupils
Choose a curriculum

All exam boards (KS4)

KS3 & KS4 computing curriculum

Unit sequence

Skip to units

Filter and highlight

Year group

Highlight a thread
Computer Science
Year 11

Databases and SQL

8 lessons

Threads

  • Data and information
  • Impact of technology

Description

This unit introduces pupils to databases and SQL, they will explore the key terms used in a database and why relational databases are used to eliminate the redundancy that can occur in a flat file database. They will explore SQL commands to retrieve, update, and delete data in a relational database.

This unit introduces pupils to the world of databases and SQL. Pupils will have worked with datasets in KS3 but will not have experienced data management systems. Pupils will explore the key terms used in a database and learn why relational databases are used to eliminate the redundancy and inconsistencies that can occur in a flat file database. Pupils will explore increasingly challenging SQL commands where they retrieve, update, and delete data in a relational database. To conclude the unit pupils will investigate the legal, ethical and environmental impacts of data and data systems.

  1. Database fundamentals
  2. Database design
  3. SQL fundamentals
  4. SQL searches
  5. Data protection, copyright and the law
  6. Data and privacy
  7. Big data
  8. The environmental impact of data systems

67 units shown,

Need help with our new curriculum?

Visit our help centre for technical support as well as tips and ideas to help you make the most of Oak.

Go to help centre