Databases for A-level Computer Science
CP507 Live remote training course
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.
Skip to course bookingLearn 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.
Topics 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 long is this course?
This course will last 3 hours and is delivered in 2 sessions, these sessions maybe split across multiple days.
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.
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
This course is part of Teach secondary computing
Teach secondary computing
Our nationally recognised qualification will give you confidence to take your computing teaching to the next level and to apply those skills in the classroom.
Book this course
You need to be logged in to start the course.
Adapted teaching and effective learning interventions in secondary computing
Develop an evidence-informed approach to education recovery over a sustained period, securing the computing education of young people following a period of great disruption.
Adapting the Teach Computing Curriculum for mixed-year classes - short course
Explore progression within Teach Computing Curriculum and how to use this to adapt it for your own mixed-age setting.
AI and Ethics in GCSE computer science
Artificial intelligence, what is it? How does it work? What are the ethical considerations for GCSE students. How could you teach it to your students?