Skip to content

Databases and SQL

Download complete unit ↓(not available yet)

Why this, why now

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.

Prior knowledge requirements

  • Ardaydu waa inay yaqaanaan aasaaska maadada.
  • Ardaydu waa inay awoodaan inay raacaan tilmaamo fudud.
Unit 9 / 11

Databases and SQL

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.

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