Databases for A-level Computer Science CP507

An introduction to databases for A-level teachers. Gain confidence in teaching the databases content in the A-level specification including attempting and marking exam questions.

Summary

Learn about a new topic from GCSE, the world of databases. We will discuss the key terminology you need to learn to teach the students in your classes. 

You will learn the skill of normalising a database right from 1st normal form to 3rd normal form which, is a topic many students find a challenge. As well as learning about the theory of databases you will also learn how to use SQL to search and query the database.

You’ll develop key pedagogical approaches to teaching databases at A level including looking at the exam questions students are asked. We want you to come away from the course with the confidence to deliver this in your school or college. 

Who is it for?

This course is aimed at teachers delivering A Level computer science. Since this content is not covered in most GCSE specifications we will take you right from the very basics to the more advanced topics.

During this course you’ll access the Isaac Computer Science platform, it is advised you sign up for a free, teachers account ahead of the course.

What topics are covered?

01 | Intro to databases

  • What is a DB? Flat files v Relational DBs
  • Structure of a DB and key terms
  • What is a DBMS?
  • Entity Relationship Modelling
  • Resolving many-to-many relations

02 | Designing and using databases

  • The purpose of normalisation
  • Normalisation in practice
  • Transaction processing and ACID
  • Introduction to SQL
  • Practice exam questions

How will you learn?

Scheduled live, interactive online sessions led by an experienced practitioner. Flexible Professional Development Leader-supported, participant-led tasks, involving deep exploration of the subject content. 

How long is this course?

This course will last 3 hours and is delivered in 2 sessions, these sessions maybe split across multiple days.  

Outcomes

By the end of this intensive CPD pathway you will be able to:

  • Explain the key terminology needed for teaching A Level databases
  • Be able to teach the rules of database normalisation
  • Be able to use SQL with students to develop their knowledge of the subject
  • Be able to attempt exam board questions with students and mark their attempts confidently

No suitable dates?
Let us know and we'll be in touch

Actions

Share this