Teach Computing

Revision notes, activities, lesson plans, teaching ideas, and other resources for GCSE, A-Level, and IB Computer Science teachers and students.

What's New

Examples of Local Cryptocurrencies

Digital Money for Local Communities covers three examples of country-wide c...

Hash function A hash function takes arbitrary sized input data (e.g. a fil...

Cryptocurrencies vs regular currencies

What is Bitcoin and How Does it Work? is a high level overview of the Bitco...

Examples of Cryptocurrencies

Bitcoin is by far the most well known cryptocurrency. The Bitcoin website w...

Practice paper 3 exam questions

One of the drawbacks of the yearly case study is that there are no past p...

Emergency Management System Explainer Video

This short video gives an overview of some EMIS features. It includes many ...

Geographic Information Systems (GIS)

For some functionality, an EMIS may also be connected to a GIS (Geographic ...

Programming languages - from Scratch to machine code

The CS Field Guide has a very comprehensive guide to different types of pro...

Assembly language simulators

There are several assembly language simulators available for use online. Si...

Resources discount offer

3.5 Databases

Database tutorials

Database tutorials - GCFLearnFree YouTube channel

GCFLearnFree's YouTube channel has videos on a wide range of subjects, including Microsoft Access. The videos start with the absolute basics, introducing the background concepts and simple single table databases (very useful for the IGCSE Computer Science course). They then move on to more complex topics such as designing different types of queries, creating forms, and formatting reports. Video are generally less than 5 minutes, which means they get straight down into the details and make it easy to skip to the right part. The video focus on Access 2013 but students should be able to adapt the techniques to other versions too.

Updated: 2015-04-11
Databases revision


A good overview of database theory, which is sufficient to cover the syllabus for most GCSE courses, and is a good introduction to the topic for A Level and IB courses. The differences between structured and unstructured data are covered, along with database basics (fields, records, tables). The second half of the video explains relationships in more detail, including 1-to-1 and 1-to-many relationships.

Updated: 2018-02-17

Live Database Example - Try SQL

This site lets users try out queries and commands using SQL. The supplied test databases has a dozen tables and hundreds of records, and can easily be reset if a mistake is made. Although SQL is no longer part of the Edexcel Computer Science syllabus, this is still a great site to help students understand what queries are and how they work.

Updated: 2019-03-14