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

Device specifications

Device Specifications is a simple site with a huge database of smart phones...

Smart phone specs explained

This excellent site is a detailed guide to smart phone specifications, expl...

Software as a Service (Saas)

This short video gives an overview of Software as a Service (SaaS), which s...

Amazon EC2 - Elastic Cloud Server

Amazon Elastic Cloud (Amazon EC) is a good example of Infrastructure as a S...

Changeover notes

IGCSE ICT provide short but clear notes and diagrams covering the different...

CommandPoint CAD

CommandPoint by Northrop Grumman offers a range of CAD systems for various ...

CAD+911 System

TriTech Software Systems is a company that specialises in Computer Aided Di...

London Ambulance CAD failure

The 1992 London Ambulance Service CAD failure is probably the most notoriou...

Washington State 911 Failure

A 911 emergency telephone system in Washington State and Oregon shut down f...

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

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