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

UK Computing Laws

This video from Computer Science Tutor covers the main UK computing laws re...

Wireless Networking (Wi-Fi, Security, and Hardware)

This video about wireless networking includes everything that is needed for...

Network topology videos

These four excellent videos from Computer Science tutor cover the four ma...

Network protocols

These four videos explain the main networking protocols that students are l...

Embedded Systems video

This short video is a good over of embedded systems, covering the main poin...

Representing Text in Binary

This video clearly explains the two main ways of representing text in binar...

Types of Malware

This video explains the various types of malware including viruses and troj...

Protecting against Malware

Following on from the Types of Malware video, this video explains technique...

Video: Network Security #1

This video gives an overview of the threats to networked computer systems, ...

Resources discount offer

3.5 Databases

Click here for recommended Edexcel GCSE Computer Science textbooks.
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

Databases

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